Job now gives fatal error re TCP protocol

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
gerardp
Participant
Posts: 7
Joined: Fri Jul 08, 2005 5:27 am

Job now gives fatal error re TCP protocol

Post by gerardp »

I'm running a job which extracts data from several Oracle 8 databases (using the DRS stage). The job has always worked in the past but now gives the following fatal errors:

buffer(5),2: Failure during execution of operator logic
buffer(5),2: Output 0 produced 0 records
buffer(5),2: Fatal Error: Cannot find protocol entry for tcp protocol!

I've tried other jobs which also access the same Oracle 8 databases using the DRS stage - some work and others give the same fatal errors.

The source databases appear to be working okay and allow connection via SQL*Plus.

Any help appreciated.
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Re: Job now gives fatal error re TCP protocol

Post by rwierdsm »

Getting the same errors.

Admin folks claim the server is busy!

Any insights? I'm running version 7.5x2 on Windows, which probably explains a lot.

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Post Reply