cancel
Showing results for 
Search instead for 
Did you mean: 
susinghal
Nintex Newbie

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

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.

 

.112233

Labels: (1)
0 Kudos
Reply
6 Replies
jackgelo
Automation Master
Automation Master

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

Hi,

 

could you show your Execute SQL action configuration?

0 Kudos
Reply
susinghal
Nintex Newbie

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

Attached for your reference.

 

SQL Action ConfigurationSQL Action Configuration

0 Kudos
Reply
susinghal
Nintex Newbie

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

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

0 Kudos
Reply
emha
Automation Master
Automation Master

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

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?

0 Kudos
Reply
susinghal
Nintex Newbie

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

Things worked automatically, I believe publishing from another user then system account worked.
0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

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

Great to hear that you were able to resolve this issue.
If you require Urgent help in the future please email support@nintex.com.
0 Kudos
Reply