Parallel job reports failure (code 256) with Oracle Ent Stg
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Mon Sep 14, 2009 11:50 pm
- Location: India
Parallel job reports failure (code 256) with Oracle Ent Stg
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?
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?
-
- Participant
- Posts: 17
- Joined: Mon Sep 14, 2009 11:50 pm
- Location: India
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 17
- Joined: Mon Sep 14, 2009 11:50 pm
- Location: India
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
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
-
- Participant
- Posts: 17
- Joined: Mon Sep 14, 2009 11:50 pm
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 17
- Joined: Mon Sep 14, 2009 11:50 pm
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: