SQL Query Action not working in workflow, if run to executes directly it works


Badge +4

The workflow that I created to update delegate comments into the main item.

The issue is if I provide HumanWorkflowID in SQL query and execute action, it is working properly in edit workflow mode as shown fig 2, but not running while when workflow automatically runs on tasks update fig 3.

 

Looking forward to your support.

 

.2289iC321F895320B44FE.jpg2290i3CB966BF80EB98FF.jpg2291i6793E49F4ACB0931.jpg


6 replies

Userlevel 4
Badge +11

Hi,

 

could you show your Execute SQL action configuration?

Badge +4

Attached for your reference.

 

2310iF5AC3507ED442EF2.png

Badge +4

Please reply if you have any idea to achieve this, waiting.

Userlevel 5
Badge +14

does workflow initiator, or a user which context the action runs in, have sufficient priviledges to access database and/or table?

 

have you checked the action haven't errored out?

 

did the queried record exist already at the moment the action was axecuted?

Badge +4
Things worked automatically, I believe publishing from another user then system account worked.
Userlevel 6
Badge +22
Great to hear that you were able to resolve this issue.
If you require Urgent help in the future please email support@nintex.com.

Reply