Developer forum

Forum » Integration » SQL timeouts on Data integration

SQL timeouts on Data integration

Daniel Hollmann
Reply

Hi.

We have created a data integration job under Settings -> Integration -> Data Integration.

Unfortunately it's not performing well, so it timeouts after the 30 seconds. Is there any way to increase the timeout threshold above 30 seconds?
I tried to set source connection with a SQL connection string where I set timeout to be 120 seconds instead, but that did not work?

Any way to get around this?


Replies

 
Dynamicweb Employee
Dmitriy Benyuk
Reply
Hi Daniel, What are your source and destination providers? What Dynamicweb version are you using? Kind regards, Dmitrij
 
Daniel Hollmann
Reply

Im using this:

Source provider: SQL PROVIDER WITH VIEWS
Destination Provider: CSV PROVIDER

My DW version is: 9.7.4

 
Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Daniel,
try to set the timeout in the Global settings using this path:

/Globalsettings/Settings/DataIntegration/SQLSourceCommandTimeout

Kind regards, Dmitrij

 
Daniel Hollmann
Reply

Wow :) That worked! Thanks a lot.

The setting wasn't there to begin with, so I had to add it in the GlobalSettings.aspx, but then it worked fine!

Thanks a lot Dmitiry!
 

 

You must be logged in to post in the forum