Error connecting to Oracle database"Fatal Error: Caught
Moderators: chulett, rschirm, roy
Error connecting to Oracle database"Fatal Error: Caught
Hi all,
I am getting an error when I am tring to fetch data or write data to Oracle database using a paralle job.
Here is the erro message that I got:
Error executing View Data command:
##F TFPM 000281 16:18:03(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
Output from job run:
##I TFCN 000001 16:17:57(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 16:17:57(001) <main_program> orchgeneral: loaded
##I TOSH 000002 16:17:57(002) <main_program> orchsort: loaded
##I TOSH 000002 16:17:58(000) <main_program> orchstats: loaded
##W TCOS 000049 16:17:58(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##F TFPM 000281 16:18:03(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
>
>
Could anyone please help me out with this. why am getting this error and how to resolve this.
Thanks in advance.
I am getting an error when I am tring to fetch data or write data to Oracle database using a paralle job.
Here is the erro message that I got:
Error executing View Data command:
##F TFPM 000281 16:18:03(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
Output from job run:
##I TFCN 000001 16:17:57(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 16:17:57(001) <main_program> orchgeneral: loaded
##I TOSH 000002 16:17:57(002) <main_program> orchsort: loaded
##I TOSH 000002 16:17:58(000) <main_program> orchstats: loaded
##W TCOS 000049 16:17:58(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##F TFPM 000281 16:18:03(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
>
>
Could anyone please help me out with this. why am getting this error and how to resolve this.
Thanks in advance.
Joji John
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Create another, really simple parallel job with one Integer column. SELECT COUNT(*) FROM DUAL; will do as the query; output can be to a Peek stage. Can you get this to work?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.