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

[kyle_wright]

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.

[vadim_tabakman]

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

[kyle_wright]

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

[vadim_tabakman]

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

[#5]

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

[#6]

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

[lgiambar]

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