ODBC SQL Server Driver Timeout expired error
Posted: Tue Apr 03, 2012 9:14 pm
Hi,
I am using datastage version 7.5.2. There are several jobs in the project that connect to SQL Server database using ODBC stage. Randomly the jobs are failing with the below error. Some of the times the jobs are running absolutely fine but other times they fail with time out error.
"APT_CombinedOperatorController(1),0: Fatal Error: Could not connect to datasource[DataDirect][ODBC SQL Server Driver]Timeout expired"
Our DBAs are not being of much help. Any suggestions on how to avoid this error would be helpful. Appreciate any information.
Thanks!
I am using datastage version 7.5.2. There are several jobs in the project that connect to SQL Server database using ODBC stage. Randomly the jobs are failing with the below error. Some of the times the jobs are running absolutely fine but other times they fail with time out error.
"APT_CombinedOperatorController(1),0: Fatal Error: Could not connect to datasource[DataDirect][ODBC SQL Server Driver]Timeout expired"
Our DBAs are not being of much help. Any suggestions on how to avoid this error would be helpful. Appreciate any information.
Thanks!