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
  • 40 views
  • Translate All

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?

Translate

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

Attached for your reference.

 

2310iF5AC3507ED442EF2.png

Translate

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

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

Translate

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?

Translate

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

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