Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications

|

Microsoft CRM 4.0 Update Rollup failed to install

Post Author: Joe D365 | May 16th, 2011

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:

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

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

PowerObjects Recommends