SQL Server Timeout Error

[neilpadilla]

Hi Guys,

Good day!

I am currently encountering the following error during the run of my job.

<ODBC call <SQLDriverConnect> for data source <bodssql\bodssql,12345> failed:<[Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. >

I would like to ask for your help with the following:
     1. Where can I find the ODBC Configuration in BODS?
     2. Where can I find/modify the timeout values?

     3. Is this error related with the timeout configuration?
     4. What are the possible causes of this issue?

BODS Version: 4.0

Target Database 1: Microsoft SQL Server 2008
Target Database 2: Microsoft SQL Server 2005

Thanks,

Neil

[Former Member]

Hi,

Whats the volume of data you handle?

Arun

[neilpadilla]

Hi Arun,

The job processes an average of 260000 records per run. In each target table where the error is observed, the row count processed varies between 3000 - 170000.

In addition, I have observed that the issue occurs at a consistent time. This is also usually observed during the start week and end week of the month.

Regards,

Neil