Dynamics Community Forum Thread Details

SQL Stored Procedure Database Upgrade Issues - Update 2.3

We have successfully installed Update 2.3 for CRM 2016 On-Premise within our DEV, UAT and Production environments however the database for a single organisation on our DEV environment will not upgrade.

We receive the following error message when we attempt to upgrade the database using the CRM deployment manager.

Error installing sp with name=p_AccountSummaryRollup
Invalid object name 'Contract'.
Could not use view or function 'FilteredContract' because of binding errors.
Invalid object name 'Contract'.
Could not use view or function 'FilteredContract' because of binding errors.

So we have determined that the error message is related to a Stored Procedure name p_AccountSummaryRollup and an invalid object name. It would seem that entity 'Contract' has not been renamed and the table and view exists with the correct name.

Would someone please advise how I should go about resolving the error and upgrading the database. I am very reluctant to make changes directly on the database and would definitely like to follow a supported approach.

Thanks

Tony

Categories:

Other Functionality