Skip to main content
Nintex Community Menu Bar

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

  • May 23, 2019
  • 6 replies
  • 27 views

Forum|alt.badge.img+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

Forum|alt.badge.img+11
  • Nintex Partner
  • May 27, 2019

Hi,

 

could you show your Execute SQL action configuration?


Forum|alt.badge.img+4
  • Author
  • Rookie
  • May 27, 2019

Attached for your reference.

 

2310iF5AC3507ED442EF2.png


Forum|alt.badge.img+4
  • Author
  • Rookie
  • May 30, 2019

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


Forum|alt.badge.img+14
  • Scholar
  • June 7, 2019

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?


Forum|alt.badge.img+4
  • Author
  • Rookie
  • October 6, 2019
Things worked automatically, I believe publishing from another user then system account worked.

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 6, 2019
Great to hear that you were able to resolve this issue.
If you require Urgent help in the future please email support@nintex.com.