Symptoms
The user successfully upgraded the k2 blackpearl version and K2 smartforms version to 4.6.10 from 4.6.7.
They are deploying applications one by one. While doing their FundsTransfer application. Only the form was getting deployed. They tried various times and every time the same error is coming as seen below.
Please could I request your help in find if this error is due to upgrade.
FTU_TelexTransfer_Form Form : Error 2601, Level 14, State 1, Procedure aDeploy, Line 888Cannot insert duplicate key row in object 'Form.EventInstance_Design' with unique index 'UX_Form_EventInstance_Design_ContextID_EventID_StateID_InstanceID_SubFormID'. The duplicate key value is (29d96274-de90-46ca-b6e4-28b49924403d, 92843696-a21d-4665-9cdd-a60398fdd45b, 06a5261a-6ab9-410f-8682-26809d569a56, 7a93ad96-d59f-8e63-b5d9-e7b6546ebb7b, ).
Error 2601, Level 14, State 1, Procedure aDeploy, Line 888Cannot insert duplicate key row in object 'Form.EventInstance_Design' with unique index 'UX_Form_EventInstance_Design_ContextID_EventID_StateID_InstanceID_SubFormID'. The duplicate key value is (29d96274-de90-46ca-b6e4-28b49924403d, 92843696-a21d-4665-9cdd-a60398fdd45b, 06a5261a-6ab9-410f-8682-26809d569a56, 7a93ad96-d59f-8e63-b5d9-e7b6546ebb7b, ). System.Data.SqlClient.SqlException (0x80131904): Error 2601, Level 14, State 1, Procedure aDeploy, Line 888Cannot insert duplicate key row in object 'Form.EventInstance_Design' with unique index 'UX_Form_EventInstance_Design_ContextID_EventID_StateID_InstanceID_SubFormID'. The duplicate key value is (29d96274-de90-46ca-b6e4-28b49924403d, 92843696-a21d-4665-9cdd-a60398fdd45b, 06a5261a-6ab9-410f-8682-26809d569a56, 7a93ad96-d59f-8e63-b5d9-e7b6546ebb7b, ).
at SourceCode.Hosting.Client.BaseAPI.BaseAPIConnection.RemoteCall(String TypeName, String MethodName, Object,] Parameters, Boolean ] NullList, MarshalMessageType CallType)
at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteSessionCall(String TypeName, String MethodName, Object,] Parameters, Boolean ] NullList)
at SourceCode.Forms.Management.FormsManager.DoSessionCall(String method, Object,] parameters, Boolean ] nullList)
at SourceCode.Forms.Management.FormsManager.Deploy(String definition, String category, Boolean checkIn)
at SourceCode.Runtime.Services.Forms.FormsSessionData.DeployForm(Form form, Boolean checkIn)
at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.DeployAuthoringInstance(AuthoringType instance)
at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.Deploy(IDeploymentContext context)
ClientConnectionId:8f19cc9d-cba9-4f74-ac1a-8f20d8af079c 17 s
Diagnoses
- Remove from the Package the Form that is posing a problem,
- Deploy all the other Forms,
- In the target environment delete the problem Form,
- Create a new Package for this Form in the dev environment,
- Deploy the new package.
then
- Do a full restart of the machine
- Verify as to whether the SmartForm you are trying to use is 'Checked-In'?
Resolution
Customer informed us that After a restart, a Repair and Clearing the cache the issue was resolved
