Error connecting to Oracle database"Fatal Error: Caught

jojipjohn · Post by **jojipjohn** » Fri Oct 06, 2006 4:53 am

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.

ambasta · Post by **ambasta** » Fri Oct 06, 2006 5:46 am

Are u parameterising the connection details or hardcoding???if parameterizing then try to hardcode and see wat u r getting.

jojipjohn · Post by **jojipjohn** » Fri Oct 06, 2006 6:25 am

I hardcoded the connection details. I tried connecting to an access DB in the same server its working but not for Oracle. I am able to connect to the same Oracle DB in a server job but not in a parallel job

ray.wurlod · Post by **ray.wurlod** » Fri Oct 06, 2006 6:33 am

Describe your job design. In particular, what stage type are you using to access Oracle, and what is your "write rule"? Can you View Data using this stage?

jojipjohn · Post by **jojipjohn** » Fri Oct 06, 2006 7:47 am

No I am able to view data either. This is not working both for source and targetr stages, No matter what write rule i give.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 06, 2006 2:36 pm

What stage type? Oracle Enterprise, OraOCI, Dynamic RDBMS, ODBC or something else?

jojipjohn · Post by **jojipjohn** » Fri Oct 06, 2006 10:48 pm

I tried with both Oracle enterprise and ODBC stage, Its not working

kumar_s · Post by **kumar_s** » Fri Oct 06, 2006 11:18 pm

Do you get any more errors if you expand the pop screen?
Check if odbc settings been configured properly.

jojipjohn · Post by **jojipjohn** » Fri Oct 06, 2006 11:28 pm

There are no more details available about the error. The same ODBC seting is working for server jobs.

kumar_s · Post by **kumar_s** » Fri Oct 06, 2006 11:39 pm

What is the version of DataStage that been used?
Try using tnsping to the Oracle server. Try to import metadata from using manager either by plugin or using Orchestrate.

jojipjohn · Post by **jojipjohn** » Sat Oct 07, 2006 12:20 am

tnsping is working. I am able to connect to the database with toad and this is working for server jobs also. In parallel job I am able to import the table definition but not able to view data or run the job to extract or write to the database

jojipjohn · Post by **jojipjohn** » Sat Oct 07, 2006 12:21 am

I am using datastage 7.5x2

ray.wurlod · Post by **ray.wurlod** » Sat Oct 07, 2006 12:24 am

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?

jojipjohn · Post by **jojipjohn** » Sat Oct 07, 2006 12:32 am

I tried this, even this job is not working giving the same error.

jojipjohn · Post by **jojipjohn** » Sun Oct 08, 2006 6:33 am

I am able to fire this SQL statements in toad and the same is working for server jobs. If it something to do with the DB privilages it should not work for Server job either right?