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

SQL Request Troubleshooting - works in "Run Now" but not on form

I am trying to do a very simple query in the SQL request control.  When I'm configuring the action and click the Run Now button it works fine, but when I preview or publish the form it doesn't populate anything in the drop-down.  I'm on SharePoint 2013, forms version 2.9.  Anyone have any ideas on how to troubleshoot this?  Does it use the Secure Store config during the run now process or does it use my login?  Thanks in advance for any help.

0 Kudos
Reply
6 Replies
Nintex Employee
Nintex Employee

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

Hi Kyle,

it should be using the Secure Store creds in both the Run Now and at Run Time.

But, I'd still recommend you check your creds in the Secure Store to make sure they are correct.

Vadim

0 Kudos
Reply
kyle_wright
Nintex Newbie

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

Thanks Vadim, I have confirmed that the Secure Store creds are correct.  Any other troubleshooting ideas?  Thanks for the help.

0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

Then I would recommend you check 2 other things.

1. SharePoint ULS logs to see if anything is logged there around the time you open this form.

2. See if there's any kind of SQL logs that might help explain if it is a credential issue.  I haven't looked into SQL logging, so I'm just guessing here.

Vadim

0 Kudos
Reply
Not applicable

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

Hi,

I Created a new Secure Store id, it works on Run Now but not in the Form(i am using a dropdown). I am using a Trial of Nintex Form.

Please help. I am not a SQL Guru.

Thanks and Regards,

Clavin

0 Kudos
Reply
Not applicable

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

Hi Kyle Wright

try this

if de SQL Query is "Select ProductName, UnitsInStock From Products", fill "Value field =UnitsInStock" and "Display field = ProductName"

check this post too Nintex Forms Enterprise - SQL Request Control

0 Kudos
Reply
lgiambar
Nintex Newbie

Re: SQL Request Troubleshooting - works in "Run Now" but not on form

I had this exact same issue. This thread has my answer.

 

Reply