Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
urshit_1983
Participant
Posts: 73 Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ
Post
by urshit_1983 » Tue Aug 01, 2006 2:53 pm
I am getting this error :
ORA-03113: end-of-file on communication channel
I have not seen this error before. Can any one share their experience ?
Thanks.
"Nobody is expert in Everything,
But Everybody is expert in Something."
kris007
Charter Member
Posts: 1102 Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI
Post
by kris007 » Tue Aug 01, 2006 2:56 pm
The error says that the connection between Client and Server process was broken. Just check your sql plus connection and run the Job again. It should be gone.
Kris
Where's the "Any" key?-Homer Simpson
urshit_1983
Participant
Posts: 73 Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ
Post
by urshit_1983 » Tue Aug 01, 2006 3:00 pm
So kriss007 you mean just to re-run the job. It should be fine now ? No other issue except the broken link rite ?
"Nobody is expert in Everything,
But Everybody is expert in Something."
kris007
Charter Member
Posts: 1102 Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI
Post
by kris007 » Tue Aug 01, 2006 3:02 pm
Yes. Just re-run the Job. The Job failed because the connection was broken earlier while running the Job. Just one of those connection issues.
Kris
Where's the "Any" key?-Homer Simpson
kcbland
Participant
Posts: 5208 Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Post
by kcbland » Tue Aug 01, 2006 3:20 pm
If it doesn't work again, get a DBA. This error should be greatly infrequent.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle