Auto assign user in workflow that starts with ADD1 task [message #5911] |
Thu, 29 September 2016 16:36 |
kong
Messages: 90 Registered: December 2011
|
Member |
|
|
If you apply http:// www.tonymarston.net/php-mysql/infrastructure-faq.html#faq161 to a workflow that starts with an ADD1 task, the ADD1 task will fail with the message "Nothing retrieved from the database".
Stepping through with a debugger shows that the error message is actually generated by the UPD4 task as triggered by the workflow engine.
It appears that upon hitting submit button on the ADD1 task, before the new record completes its commit to the database, the system will first check for and run workflow actions and as a consequence will suspend ADD1 and call UPD4 with the newly created but still uncommitted record as context. Thus, UPD4 won't be able to retrieve that new record from the database, returns the error message and the new record's commit never happens.
|
|
|