Article ID: 948843 - View products that this article applies to.
When you run or edit workflows in Microsoft Dynamics CRM 4.0, you may experience slow performance.
This problem occurs because Microsoft Dynamics CRM 4.0 creates records for all inactive workflow instances in the PluginAssemblyBase table. Additionally, if you modify a workflow rule, Microsoft Dynamics CRM 4.0 creates a record in the PluginAssemblyBase table and a record in the PluginTypeBase table. However, these records are never removed. Therefore, if you modify workflow rules many times, the PluginAssemblyBase and PluginTypeBase table tables become large.
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/949256/ )Microsoft Dynamics CRM 4.0 updates and hotfixes
To improve the performance of this hotfix, create the following index in the Organization_MSCRM Database.
Use the CRM 4 ScaleGroup Job Editor to schedule the Microsoft Dynamics CRM 4 deletion service to run after regular business hours to minimize the impact on Microsoft Dynamics CRM user performance. To obtain the CRM 4 Deployment Job Editor, visit the following Microsoft Web site:
After you install this fix, you may see the following errors logged in the application event log on the Microsoft Dynamics CRM 4.0 Server(s) if you do not follow the steps for improving performance listed below in the resolution secution the first time(s) that the deletion service runs
. Event Type: Error Event Source: MSCRMDeletionService Event Category: None Event ID: 16387 Date: 2009/01/26 Time: 11:41:54 AM User: N/A Computer: CRMSERVER Description: Error: Deletion Service failed to clean up table=CleanupInactiveWorkflowAssembliesProcedure For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
948629For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/948629/ )Error message when you try to go offline in the Microsoft Dynamics CRM 4.0 client for Outlook with Offline Access: "Failed move data for entity 'Plug-in Assembly' during action Insert, countRows=[Number]"
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards
Article ID: 948843 - Last Review: January 20, 2012 - Revision: 5.2