After Installing CRM 4.0 Rollup 7 client you might experience an error during the synchronizing

  • Article

Within support we have seen the following problem several times.

After installing Update Rollup 7, you might experience an error when synchronizing your CRM client with CRM server.

A generic error is raised:

"A SQL Server error occurred. Try this action again."

 

How to identify the issue
Download CRMDiagTool4 from the following location: https://blogs.msdn.com/benlec/pages/microsoft-crm-support-tools-download-page.aspx

Reproduce the Client synchronization error and trace using this tool on CRM server side.

 

This error might show up in CRM server trace:

"Invalid object name 'SubscriptionManuallyTrackedObject'"

 

Troubleshooting
1. Open SQL Management Studio on SQL server that contains the CRM databases.
2. Connect to the <ORGANIZATION>_MSCRM database and open the plus sign beneath "tables".
3. Check if the table with the name SubscriptionManuallyTrackedObject exists.

If no such table exists, please follow up with the recommended solution. If the table exists, the error is different and the solution will not help.

 

Resolution
Update Rollup 7 creates a new sql table SubscriptionManuallyTrackedObject within <ORGANIZATION>_MSCRM database.

If this failed and no such table exists, please do the following:

1) Check in Control panel (Software or Add/Remove programs) if Update Rollup 7 was applied
2) In any case - if it was applied successfully or not, go ahead and re-apply Update Rollup 7
3) Check again if Sql table SubscriptionManuallyTrackedObject was created in <ORGANIZATION>_MSCRM database

4) If the table now exists you should be fine. If not, please repeat step 2+3.

Greetings,
Juliane