AnsweredAssumed Answered

sql query server connection error

Question asked by paulsexstone on Feb 25, 2015
Latest reply on Feb 25, 2015 by andrewg@intellinet.com

Greetings,

 

I am using an sql query successfully to pull data and process into a sharepoint list, but it crashes when I try to process 3000 records of 20+ columns of text. To avoid this I chunk the data by filtering on one of the fields and looping through them.

 

the issue is that only the first query works, the second iteration of the loop fails with a database connection error.

 

I have move from a loop to a workflow, called by another work flow which does the looping hoping the separation of the loop structure would resolve it but it has not.

 

sql error:

Error performing database operation. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is

 

if I run a single iteration of the query and processing it works fin, every time.

 

attached is the sql query action I am using

 

any thoughts?

Attachments

Outcomes