After applying Update Rollup 8 to the CRM server we were unable to assign records. The error we were receiving in the CRM platform trace was the following:
>Crm Exception: Message: , ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException: Could not find stored procedure ‘dbo.p_CascadeCollectAssign’.
When we looked at the Stored Procedures for the organization, the dbo.p_CascadeCollectAssign was missing. Reinstalling Update Rollup 8 did not recreate the stored procedure. We also tried installing later rollups which also did not recreate the stored procedure.
We ended up manually creating the Stored Procedure with the following script:
Note: You will need to change organization to the actual name of your organization. Please make sure to make a complete backup of the database before making any changes.
/****** Object: StoredProcedure [dbo].[p_CascadeCollectAssign] Script Date: 05/21/2010 10:25:09 ******/
into #CascadeCollectAssign select o, t, p, q, s, y
update #CascadeCollectAssign set processed = 2
Welcome to the #1 Dynamics CRM Partner in the World
Proud winner of the 2015 Microsoft Partner of the Year for Cloud Customer Relationship Management, PowerObjects is the preferred partner for implementing, supporting, and growing CRM solutions. Through unparalleled offerings of service, support, education, and add-ons, PowerObjects can help tailor custom solutions for your business.
How Can We Help You Today?