POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

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:

crm2011

>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.

assign

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.

USE [organization_MSCRM]

GO

/****** Object: StoredProcedure [dbo].[p_CascadeCollectAssign] Script Date: 05/21/2010 10:25:09 ******/

SET
ANSI_NULLS
ON

GO

SET
QUOTED_IDENTIFIER
ON

GO

create
proc [dbo].[p_CascadeCollectAssign]

(

@operation_type nvarchar(40),

@root_entity_otc int,

@root_entity_oid uniqueidentifier,

@isOffline int,

@old_owner uniqueidentifier

)

as

begin


set
nocount
on


begin


insert
into #CascadeCollectAssign select o, t, p, q, s, y


from dbo.fn_CollectForCascadeAssign


(@root_entity_oid


,@root_entity_otc


,@isOffline


,@old_owner


)


update #CascadeCollectAssign set processed = 2


end

end

GO

assign

 

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?

Avatar for JoeCRM

JoeCRM

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 businesses and organizations around the world.