Parallel job reports failure (code 256) with Oracle Ent Stg

artivaswani · Post by **artivaswani** » Thu Feb 26, 2015 4:01 am

Hi,
I have installed Datastage 11.3 on Solaris. All the tiers and Oracle DB are installed on same machine and this is for the development environment.
I have made the configuration in .odbc.ini and uvodbc.config and tested the connection successfully with command line.
Modified the dsenv file to point LD_LIBRARY_PATH to oracle libraries and
ORACLE_HOME=<oracle home directory>; export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

I can load the table definitions also using import ODBC Table definitions. However when I test a job extracting data from oracle database, the job fails with error:
"Parallel job reports failure (code 256)":
<
Event: Starting Job OracleTest.
Event: Environment variable settings: (...)
Event: Parallel job initiated
Event: Parallel job default NLS map UTF-8, default locale OFF
Event: main_program: IBM InfoSphere DataStage Enterprise Edition 11.3.0.7169 (...)
Event: main_program: The open files limit is 256; raising to 65536.
Event: main_program: conductor uname: -s=SunOS; -r=5.10; -v=Generic_147147-26; -n=SGJ-SUN-SOLARIS.GEO.CORP.HCL.IN; -m=sun4v
Event: main_program: orchgeneral: loaded (...)
Event: Parallel job reports failure (code 256)
Event: Job OracleTest aborted.>

Please suggest what am I missing?

chulett · Post by **chulett** » Thu Feb 26, 2015 8:43 am

Oracle doesn't use ODBC. Can you connect to Oracle (or at least tnsping your instance) from the ETL server? Is your tnsnames.ora file setup correctly? Suggest you verify your native sqlnet connectivity first.

artivaswani · Post by **artivaswani** » Tue Mar 03, 2015 4:37 am

Hi,
ORACLE_HOME environment parameter was pointing to wrong directory, hence encountered that error. After pointing it to correct ORACLE_HOME directory, the error did not occur.

However, now I have a different issue; The job throws this error:
<main_program: (aptoci.C:105). Message: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA>
I have checked TNSNAMES.ora and listener.ora and connected to database from client tool and Reporting tool. There is no issue in connection.

Since the oracle server is installed on the same machine, do I still need a client to be installed? If so, does it has to be Oracle 11g or 10g for Datastage 11.3?

Thanks,
Arti

ray.wurlod · Post by **ray.wurlod** » Tue Mar 03, 2015 5:05 am

Check which Oracle environment variables are set in $DSHOME/dsenv, and to which values.

artivaswani · Post by **artivaswani** » Tue Mar 03, 2015 5:34 am

Hi Ray,

The following environment variables are set in $DSHOME/dsenv:
ORACLE_HOME=<Oracle Server Home Directory>; export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
PATH=$PATH:$DSHOME:$ORACLE_HOME/bin; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
ORACLE_SID=<DB_SID>; export ORACLE_SID

Thanks,
Arti

artivaswani · Post by **artivaswani** » Tue Mar 03, 2015 5:41 am

Also, I can import data using Import --> PlugIn metadata definitions --> ORAOCI9.

I can see the enteries of databases defined in TNSNAMES.ORA in dropdown for Database Source Name.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 03, 2015 4:30 pm

What error entries are in the log of the parallel job itself when it fails? (You have shown us entries from the sequence's log.)

artivaswani · Post by **artivaswani** » Thu Mar 05, 2015 8:57 pm

The issue resolved when I gave Database name in RemoteServer property of Oracle Enterprise stage.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 05, 2015 10:24 pm

I recall reading a tech note about needing to do that, but I can't immediately recall where.