Cannot drop index 'cndx_PrimaryKey_OpportunityProduct'

(0) Share

Report

Posted on by Community Member

Hi All, we plan to update Dynamics 365 CRM 8.2.1 from local CRM 2016, but the upgrade program prompt us the update installation is complete, but it can't update the organization. When I try to update it manually, it shows below:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot drop index 'cndx_PrimaryKey_OpportunityProduct' because it enforces the full-text key for table or indexed view 'OpportunityProductBase'.
Could not drop constraint. See previous errors.

It looks like maybe this index has something wrong, what can I do for fixing this? Thanks very much !

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

joman 617 on at

Like (0)

Report
Copy link

Link copied!
You need to drop Fulltext Indexes, before you can drop PK index. More info here: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql

You can find Fulltext Indexes by this query:

SELECT object_id, property_list_id, stoplist_id FROM sys.fulltext_indexes where object_id = object_id('myTable');

Was this reply helpful? Yes No