Action "Move workflow (SQL)" giving the Error "Incorrect column PATH_ID format"

0

Hi Nick,

just to mention, as I see you have come across alterpaths, check out also this article https://alterpaths.com/massive-update-of-sub-workflows-in-webcon-bps/
if you want to get rid of that case when block :)

Hi Sebastian,

thanks for your help, that solved it. But I still got an issue.
The action is started when any child instance is moved to the finish(positiv) step and then all other child instances should be canceled.
Now I get an Concurrency Error, whilst trying to move a child instance in the finish(positiv) step.

Do you have any idea of how to fix this?

Hi Nick,

in case you are still stuck the following could be a reason.
A concurrency error will happen if workflow a triggers workflow b which in turn modifies other workflow. If this chain would modify workflow a again you can get this problem.
This could also happen if you have an external system which wants to change a workflow per REST API which triggered the external system.

Maybe your parent workflow also tries to modify the finished positive workflow.

Best regards,
Daniel

Hi Daniel,

that was the case here.
I fixed it with a system step in between that waits a minute before calling the action.

Thank you all for the great help

With kind regards,
Nick