michaelbah40
Scholar

SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Hi everyone, I have been testing my form and only can i see the content populate from the database in the testing enviornment and not in the LIVE. Can anyone please tell me what is wrong? Why is this only populating in TEST MODE only?

 

 

nocontent1_form1.pngnocontent1_form2.pngnocontent1_form3.pngnocontent1_form4.png

0 Kudos
Reply
14 Replies
cherylshah
Scout

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Starting from square one... did you update the server/database names to your live SharePoint environment?

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

That is a good question. I'm not too sure, I will look into that now. 

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Good morning Cherylshah, the database/server is updated.  Problem still exist. 

0 Kudos
Reply
cherylshah
Scout

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Does the production database use a different authentication? Does the table have a different column name, for the query?

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
To my knowledge it doesn't use a different authentication than windows and no it does not have a different name.
0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
I'm trying to see if there is another way of pulling the same data using Active Directory using a list lookup control, if this SQL control doesn't do the trick for me
0 Kudos
Reply
cherylshah
Scout

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Maybe the production connection takes longer than 10 seconds? Try increasing your Timeout limit? Although I know 10 seconds already seems like forever to a user to wait for data to populate....

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
Ok I will try increasing time.
0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
the time change didn't work and I am looking at this example right now of Query LDAP Action ....no I actually never heard of this tool until today...I'm very new to Nintex

https://community.nintex.com/t5/Nintex-for-SharePoint/Display-meaning-full-name-from-Active-Director...


0 Kudos
Reply