I have a managed solution which is in our production environment. We have Dataflows which pulls data into a table from MSSQL and somehow created duplicates in one of the key fields and now that key is showing failed. Also the Dataflow is failing to refresh/run aswell.
See screenshot of the failed key below:
Also see the error message comig from the Dataflow:
gbca_project table's key gbca_uniqueprojectnumber could not be created. Please delete the existing key and create new key for the table and try again. Additional information: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.gbca_projectBase' and the index name 'ndx_for_entitykey_gbca_UniqueProjectNumber'. The duplicate key value is <redacted>.
I have since cleared the duplicate records in the managed solution but the error still shows in both the Key and the Dataflow. As it is a managed solution I cannot delete the key and recreate it.
Interestingly, in the Dev environment where the unmanaged solution sits, the keys are fine and the Dataflow runs successfully.
Any ideas how to fix this issue so that the keys will show active in the managed solution, I don't think re-importing the solution in the prod environment will help in this situation as nothing has changed structurally right?
