Oracle Table Error

kashif007 · Post by **kashif007** » Mon Mar 09, 2009 3:56 pm

Hi All

I am trying to extract data from an Oracle table. I can see the data when I put the connection credentials of the database and view the data from the Oracle Enterprise stage. I also see the database connection parameters present in the TNSNAMES.ORA file on the unix server. But when I try to run the job I get the following error.

ITEM_MASTER,0: Fatal Error: Fatal: ORA-12154: TNS:could not resolve the connect identifier specified

Can anyone please help me find the solution to the problem.
Thanks

girija · Post by **girija** » Tue Mar 10, 2009 7:24 am

Try to connect oracle from your unix box using that connect string. If failed, talk to DBA otherwise talk to your DS admin.

kashif007 · Post by **kashif007** » Tue Mar 10, 2009 2:58 pm

Actually when I hardcode the DB, ID and PWD values in the stage the job runs fine but when I put the DB, ID and PWD as a parameterized value then the stage fails with the following error.

Failure due to illogical operator

Is this IBM tools issue ?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 10, 2009 4:08 pm

Maybe, maybe not. Verify (in the job log, "job starting" event) that the correct parameter values are being passed to the job.

kashif007 · Post by **kashif007** » Tue Mar 10, 2009 4:30 pm

They look identical as below

Using Parameterization:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp

With Parameterization job aborts.
====================================
Using Hardcoded Values:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp

With Hardcoded credentials job runs successfully.

kashif007 · Post by **kashif007** » Wed Mar 11, 2009 1:07 pm

The Job works even with Job level parameters apart from hardcoded values, only the Project Level parameters are not being accepted. I am still not able to identify the problem ?

vinothkumar · Post by **vinothkumar** » Wed Mar 11, 2009 2:08 pm

Can you check whether the Environment variables are having correct values through Administrator.

kashif007 · Post by **kashif007** » Wed Mar 11, 2009 2:19 pm

Values in the environment variable are the correct, my Client has opened a ticket with IBM.

chulett · Post by **chulett** » Wed Mar 11, 2009 3:12 pm

I believe you'll find there's a patch for that. What 8.x version are you running? If you're not on 8.1 have you loaded the 'fixpack'?

kashif007 · Post by **kashif007** » Thu Mar 12, 2009 2:25 pm

Sorry for replying late. I am V 8.0.1

When I installed the Datastage Client, I had installed the following two fix patches.

patch_e119863 : Run-time error 5 when attempting to save an OCI stage table definition to the repository

patch_e124328 : Information Server Parallel job with FTP EE stage receives the error: Fatal Error: This index is out of range: 0

And none of these patches would fix my problem.[/b]