XtkWorkflowTask duplicated key row error

anhg

20-07-2020

We recently upgraded to build 9032 and tonight was the first time I imported database schema from our test instance into our production instance. The import was successful without any errors, however, after the import all my workflows and campaigns started throwing this error. Has anyone encountered this issue before and how to resolve?

 

WDB-200001 SQL statement 'INSERT INTO XtkWorkflowTask (dMaxExecutionTime, iWorkflowId, iWorkflowTaskId, tsProcessing, tsNextProcessing, iStatus, iAbortReason, tsCompletion, iTaskIdentifier, tsCreation, tsRunning, iProcessingCount, sHostname, sActivity, i
LastErrorCode, iAssigneeType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' could not be executed. Param(0)=0s Param(1)=259395 Param(2)=0 Param(3)=07/20/2020 9:35:22 PM Param(4)=07/20/2020 10:00:00 PM Param(5)=0 Param(6)=0 Para
m(7)= Param(8)=71632 Param(9)=07/20/2020 9:35:22 PM Param(10)= Param(11)=1 Param(12)=SERVERNAME Param(13)=schedule Param(14)=0 Param(15)=0
ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'xxxxxxx.XtkWorkflowTask' with unique index 'XtkWorkflowTask_id'. The duplicate key value is (0). SQLState: 23000
ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. SQLState: 01000

Accepted Solutions (1)

Accepted Solutions (1)

_Manoj_Kumar

MVP

21-07-2020

Hello @anhg ,

 

You can refer to this documentation for how to resolve the sequence.

 

https://helpx.adobe.com/campaign/kb/sequence_auto_generation.html

 

Thanks,

Answers (0)