since ‎20-07-2020
‎23-07-2020
anhg
Level 1
Re: XtkWorkflowTask duplicated key row error
Avatar

anhg

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

422

Likes

0

Replies

0
Re: XtkWorkflowTask duplicated key row error
Avatar

anhg

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

437

Likes

0

Replies

0
XtkWorkflowTask duplicated key row error
Avatar

anhg

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

454

Likes

0

Replies

3