cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Timeout Error

neilpadilla
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

I think SQL Server timeout issue is related to Non-Availability of the Host / Cluster.

Below are answers for your Questions......

1. Where can I find the ODBC Configuration in BODS?

     This Information is available in ODBC.INI file on your Job Server (/usr/sap/{SID}/dataservices/DataDirect/odbc

2. Where can I find/modify the timeout values?

     You will be able to get tie out value from QueryTimeOut Parameter in odbc.ini file

3. Is this error related with the timeout configuration?

     I am not sure, this could be related to incorrect parameters in the connection string (Check HostName, UserID      and Password)
4. What are the possible causes of this issue?

     Can you try to login using SQL Server Management console and see how it goes..this will help you      troubleshoot and will help you narrow down on the exact issue

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Whats the volume of data you handle?

Arun

neilpadilla
Participant
0 Kudos

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

Sriram2009
Active Contributor
0 Kudos

Hi Neil

1. For you time out issue kindly refer the SAP KBA

1671058 - ERROR: ODBC call <SQLDriverConnect> for data source <datasource> failed

2.

 1. Where can I find the ODBC Configuration in BODS?   

Check this SAP Note   1248222 - ODBC DBSL profile parameters and connect options

BR

SS

neilpadilla
Participant
0 Kudos

Hi SS,

Thanks for your answers. However, the timeout error that I am encountering is not related to a login error.

Thanks,

Neil