Getting error when upgrading Org to Service Pack 1 (2016.01)

(0) Share

Report

Posted on by Community Member

I'm trying to install the Service Pack to 2016.01 on-prem .

When I ran the installer, it said that some organizations were not upgraded, and that I should do so manually from Deployment Manager. I have 2 organizations that were not updated So I went to Deployment manager , selected my org, and tried to update.

This fails, and in the log I get the following:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmException: Error installing sp with name=t_ComponentSetTable Cannot drop type 'dbo.t_ComponentSetTable' because it is being referenced by object 'p_RetrieveMultipleDirectAncestors'. There may be other objects that reference this type. ---> System.Data.SqlClient.SqlException: Cannot drop type 'dbo.t_ComponentSetTable' because it is being referenced by object 'p_RetrieveMuldtipleDirectAncestors'. There may be other objects that reference this type.

Any solution for this .

Thanks in advance !!

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Nadeeja Bomiriya 6,804 on at

Like (0)

Report
Copy link

Link copied!

Hi Nirmal,

Please check out below threads which provides a workaround for the issue.

community.dynamics.com/.../184508

community.dynamics.com/.../201943

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nadeeja,

Thanks for your update.

I fixed this issue by removing store procedure 'RetrieveMultipleDirectAncestors'' from SQL . And then issue was resolved.

It worked.

Regards,

Nirmal

Was this reply helpful? Yes No