Issue with Dynamics CRM 2013 SP1 upgrade after database import through CRM import wizard.

Recently in my project, i had to prepare a demo where we were going to show to the customers, the new service module enhancements. Since we needed our existing data to show the demo, we took a backup of our dev. environment and then restored into our POC environment. Since our dev. environment was with update rollup 2, we made sure that the demo environment also has the same update rollup.

We imported the database smoothly into our new environment and then applied CRM 2013 SP1 update. However we found that new entities shipping with SP1 update like Entitlements, SLA’s as such were not there even after the upgrade. We could not find them even through advanced find. However strangely enough those entities were all in the organization database. We tried with lot of workarounds including uninstalling and reinstalling CRM and then applying the updates as such. But still it didn’t work out for the restored organization.

Finally when we contacted Microsoft Premier Support, they update us that Microsoft is already aware of this issue and they have made the hotfixes available to install through the “Install Product updates” under the “Administration” section.

image

But when we tried to install the updates, it failed due to some of the system charts (“Top Customers”, “Case Mix By Priority”, “Case Resolution Trend”, “Activities By Month Due”) on Opportunity entity were deleted by the previous Rollups (1 or 2) in our all environment which prevented from running the below Product Updates.

Solution: MS engineer asked us to run the some SQL scripts in Demo Org and run the above “Install Product Updates” and all the missing forms in the new service module forms/views were re-created and all works fine now.

I am unable to share the SQL script because of legal considerations. However thought of sharing my experience since we lost sufficient time while resolving the issue. Hence if you face similar kind of issue, contact MS Support for the quick resolution.

Hope this helps!

Advertisements

About Debajit
I am a Dynamics CRM Most Valuable Professional (MVP) with 10 years of experience in Microsoft .NET Technologies and 7 years of dedicated experience in Microsoft Dynamics CRM. I have worked with companies like Microsoft, SanDisk, PwC, TMF Group and have extensive experience of implementing complex CRM solutions from both offshore and client side. Currently the face of XrmForYou.com with significant experience in delivering corporate training on Dynamics CRM and have already delivered multiple projects to client through XrmForYou.com Author of multiple tools on codeplex including the 'Role Based Views' and 'CRM-Sharepoint Metadata manager & Attachment Extractor' which are available for commercial use under XrmForYou.com For consulting/ training, drop me a note at info@xrmforyou.com or visit our website www.xrmforyou.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: