Developer forum

Forum » Integration » SQL timeouts on Data integration

SQL timeouts on Data integration

E-mail notifications
Daniel Hollmann
Reply
Posted on 15/10/2020 11:37:25

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

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/10/2020 11:42:13
Reply
Hi Daniel, What are your source and destination providers? What Dynamicweb version are you using? Kind regards, Dmitrij
 
Daniel Hollmann
Posted on 15/10/2020 12:00:28
Reply

Im using this:

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

My DW version is: 9.7.4

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/10/2020 13:46:18
Reply

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

/Globalsettings/Settings/DataIntegration/SQLSourceCommandTimeout

Kind regards, Dmitrij

 
Daniel Hollmann
Posted on 19/10/2020 11:41:20
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!
 

 
Allan Iversen
Allan Iversen
Posted on 24/11/2020 08:36:52
Reply

Hi!

I am occasionally running into similar issues regarding timeouts when importing EcomData (primarly large chunks of EcomProductCategoryFieldValues - 1 mio. rows). I have tried using /Globalsettings/Settings/DataIntegration/SQLSourceCommandTimeout but setting this does not seem to solve the issue.

Is it possible to increase the timout for the destination provider?

Import job failed: failed to move data from temporary table [dbo.EcomProductCategoryFieldValueTempTableForBulkImport1] to main table [dbo.EcomProductCategoryFieldValue]. Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 24/11/2020 08:51:11
Reply

Hi Allan,
that is not yet possible for the EcomDestinationProvider, it has a timeout of 1 hr. Could you create a new Data integration job and import this table using the Dynamicweb Destination provider instead?
Kind regards, Dmitrij

 

You must be logged in to post in the forum