on 08-25-2014 3:29 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Whats the volume of data you handle?
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.