Symptoms

Issue:

Client has a package that deployed successfully to Dev environment but not to Test environment where a view has this error on deployment :

Violation of PRIMARY KEY constraint 'PK__#XXXXX'. Cannot insert duplicate key in object 'dbo.@Field'. The duplicate key value is (xxxxx-xxx-xxx-xxxx-xxxxxxx). The data for table-valued parameter "@Field" doesn't conform to the table type of the parameter. The statement has been terminated.
 

Diagnoses

Diagnosis:

Known issue where the workaround was to:
Delete the effected artifacts and redeploy the package which solved the error

Client wanted more permanent solution as they would not want to have this issue when deploying to a live environment.
 

Resolution





Resolution:

This ticket has been linked to an existing bug

The proposed workaround for the issue is as follows (Avoid Deleting Artifacts):

1) Open the affected View in K2 Designer
2) Check Out and Edit the View
3) Click on the specific column and on the Body tab enter any Tool-tip (e.g. ?Due Date Body?)
4) Click on Finish and Check In
5) Deploy again