You’re offline. This is a read only version of the page.
195
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?
Thank you for your response.
However, when I try to run Solution 2 I get the following error:
I have no idea what object dbo.gbca_projectBase is, this is not any table or field that exists in the solution. Do you know if this could be referring to another type of object?
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
