Query timeout expired
We are receiving timeout error during the Map process. The sql server timeout parameter is set to 0, then we expected that SmartConnect waits indefinitely.
The error that SM shows is:
ERROR [HYT00] [Microsoft] [SQL Server Client 10.0]Query timeout expired
Have you seen it before?
I see this regulary when running a query on the SOP30300 Table with large amounts of data. I haven't tried this kb at this site, but on another site we were getting timeout issues and the kb solved. no harm in testing: "http://support.microsoft.com/kb/2539263". Regards, Mick
The problem continues, the timeout occurs when execute the Source Stored Procedure, it take the info from tables in the GP Company database.
It would look something like the following when setting the connection and command timeout properties:
myConn.ConnectionTimeout = 120
Per SmartConnect client you can launch "eOne.SmartConnect.Config.exe" from the SmartConnect install directory and modify the connection timeout. The default is only 15 seconds.
If you would like to submit an answer or comment, please sign in to the eOne portal.