Parallel job aborts with the following error message.
APT_CombinedOperatorController,0: Fatal Error: Could not connect to datasource[DataDirect][ODBC SQL Server Driver][libssclient20]
The job runs fine when it is rerun after sometime.This looks like a connectivity issue. Can this be handled in DS?
Search found 2 matches
- Wed Aug 01, 2007 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not connect to datasource
- Replies: 2
- Views: 1789
- Wed Aug 01, 2007 12:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Select query fails sometimes
- Replies: 4
- Views: 3336
Select query fails sometimes
Some of our server jobs which have the following flow odbc_stage(select from t1) -->transformer--> seq file --> odbc stage (update t1) fails sometimes with the following error message DSD.BCIGetNext call to SQLFetch failed. followed by the select query. When the job is executed say about 3 or 4 time...