anhg
Community profile anhg Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 20-07-2020 5:23:07 PM
Offline
Top badges earned by anhg
Customize the badges you want to showcase on your profile
Re: XtkWorkflowTask duplicated key row error
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
- Adobe Campaign Classic
Thank you so much _Manoj_Kumar! 9 rows of data were somehow removed from the XtkNewID table when I imported the new schemas and I had to manually add them back to the table to resolve the errors.

Views

644

Likes

0

Replies

0
Re: XtkWorkflowTask duplicated key row error
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
- Adobe Campaign Classic
It looks like the primary id sequence for this table is reset to 0 after my schemas import (the schemas were for new custom tables and did not have any changes made to any out of the box schemas). How do I reset this primary key to start from the latest value + 1?.

Views

659

Likes

0

Replies

0
XtkWorkflowTask duplicated key row error
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
- Adobe Campaign Classic
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, ts...

Views

676

Likes

0

Replies

3