Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

XtkWorkflowTask duplicated key row error

Avatar

Avatar
Validate 1
Level 1
anhg
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
anhg
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
anhg
Level 1

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)

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_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)