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
JoeCRM
Microsoft Dynamics CRM Expert at PowerObjects
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 business and organizations around the world.
Latest posts by JoeCRM (see all)
- How to Assign a Territory to a Lead in Dynamics CRM - May 17, 2013
- Out of the Box Report: Dynamics CRM User Summary - May 16, 2013
- Dynamics CRM / XRM Integration with GIS and PowerMap - May 15, 2013
