Skip to main content
Nintex Community Menu Bar

Hi,

I’m trying to deploy a K2 SmartForm that works on the development env. to the production with a package.

It’s a SharePoint online form for New item in a SharePoint list.

I have the bellow error. What could be the error for this?


Fail    View    NewKKKK_sharepoint_com___sites___YYYY_Lists_ZZZZItemView
    Error %d, Level %d, State %d, Procedure %s, Line %dCannot insert duplicate key row in object 'Form.EventInstance' with unique index 'UX_Form_EventInstance_ContextID_EventID_InstanceID_SubFormID_SubFormInstanceID_StateID'. The duplicate key value is (d732ab56-5d4d-4731-bdeb-615765b84ee0, c3e8535e-317e-45c7-9d10-bb1a132b08a4, <NULL>, <NULL>, <NULL>, 656963f9-e362-4eb8-b3fd-dc4ff7edccc0).
 Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. Warning: Null value is eliminated by an aggregate or other SET operation.    System.Data.SqlClient.SqlException (0x80131904): Error %d, Level %d, State %d, Procedure %s, Line %dCannot insert duplicate key row in object 'Form.EventInstance' with unique index 'UX_Form_EventInstance_ContextID_EventID_InstanceID_SubFormID_SubFormInstanceID_StateID'. The duplicate key value is (d732ab56-5d4d-4731-bdeb-615765b84ee0, c3e8535e-317e-45c7-9d10-bb1a132b08a4, <NULL>, <NULL>, <NULL>, 656963f9-e362-4eb8-b3fd-dc4ff7edccc0).
    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
    Warning: Null value is eliminated by an aggregate or other SET operation.
    at SourceCode.Hosting.Client.BaseAPI.BaseAPIConnection.RemoteCall(String TypeName, String MethodName, Object ] Parameters, Booleanj] NullList, MarshalMessageType CallType)
    at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteSessionCall(String TypeName, String MethodName, Objectm] Parameters, Boolean ] NullList)
    at SourceCode.Forms.Management.FormsManager.DoSessionCall(String method, Objecte] parameters, Booleano] nullList)
    at SourceCode.Forms.Management.FormsManager.Deploy(String definition, String category, Boolean checkIn, Boolean skipReferenceValidation)
    at SourceCode.Runtime.Services.Forms.FormsSessionData.DeployView(View view, Boolean checkIn, Boolean skipReferenceValidation)
    at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.DeployAuthoringInstance(AuthoringType instance)
    at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.Deploy(IDeploymentContext context)
    ClientConnectionId:113984c9-3e3f-4780-806a-b88aeb4bd625
    Error Number:50000,State:1,Class:14    00:00:05.0576917
 

The error was because an existing SMO that was not the result of a previous deployment, so with  a different ID. Removing the existent form the deployment was possible.


Reply