POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

We recently ran into an issue where we were receiving the error while trying to install update rollup 16 on a CRM 4.0 server:

crm2011

Action Microsoft.Crm.Setup.Common.UpdateAction failed. The INSERT statement conflicted with the FORGEIN KEY constraint “lk_timezonerule_timezonedefinitionid”.


Issue:
Missing Time Zones in the db,

Resolution:
1. Backup all of the CRM databases.
2. Uninstall all Rollups from the CRM Server.
3. Run the following SQL statement against all the _MSCRM databases (they are all currently Revision 2138 as you had verified)
Update BuildVersion
Set Revision = ‘3’
4. Install UR1
5. Install UR9
6. Install UR16

Happy CRM’ing from the CRM Experts at PowerObjects

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.