[DataDirect][ODBC SQL Server Driver]Communication link failu

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
challahari
Premium Member
Premium Member
Posts: 10
Joined: Tue Sep 25, 2007 9:38 am

[DataDirect][ODBC SQL Server Driver]Communication link failu

Post by challahari »

I have datastage job using ODBC Enterprise stage to load data into SQL server 2005. This job has been running fine for one year with no issues.
But now This job got failed due to the errors below. These error messages are taken from log.

APT_CombinedOperatorController(1),0: [DataDirect][ODBC SQL Server Driver][libssclient22]Timeout Expired.
[DataDirect][ODBC SQL Server Driver]Communication link failure
[DataDirect][ODBC SQL Server Driver]Communication link failure

Let me know If anyone has gone through this kind of issue or anyone knows the solution for this issue. I would appreciate your suggestions.

Thanks,
Hari.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Seems to be a pretty common problem and a quick google for 'communication link failure' only brings up results for SQL Server.

These kind of things are generally network related.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply