Adobe Campaign workflow Load File WDB-200001 error | Community
Skip to main content
C
Cogs
Level 2
June 17, 2021
Solved

Adobe Campaign workflow Load File WDB-200001 error

  • June 17, 2021
  • 1 reply
  • 2525 views

Hello all. I had a recent workflow stopped working after a while with an error (see below) on the Load file step which had previously worked. I’m pretty sure I did not change that process although I did change other ones in the workflow. I tried deleting the Load File step and adding a new one back in. No change to the error message.
Error Message: WDB-200001 SQL statement 'INSERT INTO XtkWorkflowEvent (iEventIdentifier, tsCreation, tsProcessing, sActivity, iStatus, iKeepResult, sTransition, iWorkflowId, iWorkflowEventId) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)' could not be executed. Param(0)=26 Param(1)=2021-06-08 08:43:23.884+01 Param(2)=2021-06-08 08:43:23.884+01 Param(3)=start1 Param(4)=2 Param(5)=0 Param(6)=initial Param(7)=17903625 Param(8)=18089801

It’s not obvious what is going on but I suppose the INSERT SQL is not working because either one of the unique key values / FK constraints already exists or else one of the values is not right. Either way its not something I think I can do anything about directly. I didn't directly create the Parameters as such.

How do I get around this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Cogs

Hello all - an update this which may help anyone coming across this in future. I spoke to my Adobe help and he indicated that the workflow or part of it had been corrupted. The workaround was to duplicate the workflow and start using the new copy. I did this (and also in the copy deleted the Load File and added a new one) and when I Started that copied workflow it went succesfully past the block and no more WDB-200001 error. Then deleting the old workflow and renaming my copy back to the original name and all is good.

1 reply

C
CogsAuthorAccepted solution
Level 2
June 18, 2021

Hello all - an update this which may help anyone coming across this in future. I spoke to my Adobe help and he indicated that the workflow or part of it had been corrupted. The workaround was to duplicate the workflow and start using the new copy. I did this (and also in the copy deleted the Load File and added a new one) and when I Started that copied workflow it went succesfully past the block and no more WDB-200001 error. Then deleting the old workflow and renaming my copy back to the original name and all is good.

E
EwelinaKolacz
New Member
July 15, 2021
Hi, how to duplicate the import workflow?
Terms & ConditionsAccessibility statement

Loading footer...