when I am running jobs in preprod, the jobs are failing with same type of errors
"Abnormal termination of stage jODS00104BaseMaterial..CTransformerStage2 detected",but these same failed jobs are running fine in prod.
Almost all jobs failing with error "Abnormal termination of stage ... detected". Any help greatly appreciated.
Thank you in advance .
jobs are failing with same type of error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am
please find the log from previous run after reset the failed job
DataStage Report - Detail Log for job: jODS00501ActionPlanStatusODS
Produced on: 5/16/2011 12:24:16 PM
Project: mars
Host system: 148.96.231.99
Item: 18
Item #: 18
Event ID: 17
Timestamp: 2011-05-13 09:28:48
Type: Info
User Name: dsadm
Message: Environment variable settings:
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_ENABLE_RESERVED_CHAR_CONVERT=0
FLAVOR=-1
BELL=^G
WHO=mars
DS_USERNO=-21753
UDTBIN=/vol01/dsadm/Ascential/DataStage/ud41/bin
UDTHOME=/vol01/dsadm/Ascential/DataStage/ud41
APT_ORCHHOME=
A__z=! EXINIT=#*TMOUT
CHAR=>
DSHOME=/vol01/dsadm/Ascential/DataStage/DSEngine
EDITOR=emacs
ENV=/home/dsadm/.kshrc
EXINIT=set noexrc
HOME=/home/dsadm
HOSTNAME=usplsmarvmias03
LC_COLLATE=en_US.ISO8859-15
LC_CTYPE=en_US.ISO8859-15
LC_MESSAGES=C
LC_MONETARY=en_US.ISO8859-15
LC_NUMERIC=en_US.ISO8859-15
LC_TIME=en_US.ISO8859-15
LD_LIBRARY_PATH=/vol01/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client<snip>
LOGNAME=dsadm
MAIL=/usr/mail/dsadm
MANPATH=/usr/share/man:/usr/local/man/:/usr/sfw/share/man
ODBCINI=/vol01/dsadm/Ascential/DataStage/DSEngine/.odbc.ini
ORACLE_HOME=/vol01/local/oracle/product/11.1.0/client_1
PATH=/usr/bin:/usr/sbin:/usr/ucb:/usr/ccs/bin:/usr/local/bin:<snip>
PS1=usplsmarvmias03(usplgmgpscas009):$PWD$CHAR]0;usplsmarvmias03^G
PWD=/vol01/dsadm/Ascential/DataStage/DSEngine
R_BASE=/opt/insight
SHELL=/bin/ksh
SSH_CLIENT=144.72.84.90 1487 22
SSH_CONNECTION=144.72.84.90 1487 148.96.231.99 22
SSH_TTY=/dev/pts/2
TERM=
TMOUT=1800
TNS_ADMIN=/vol01/dsadm/tnsentry
TZ=US/Eastern
USER=dsadm
_=/vol01/dsadm/Ascential/DataStage/DSEngine/bin/uv
End of report.
DataStage Report - Detail Log for job: jODS00501ActionPlanStatusODS
Produced on: 5/16/2011 12:24:16 PM
Project: mars
Host system: 148.96.231.99
Item: 18
Item #: 18
Event ID: 17
Timestamp: 2011-05-13 09:28:48
Type: Info
User Name: dsadm
Message: Environment variable settings:
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_ENABLE_RESERVED_CHAR_CONVERT=0
FLAVOR=-1
BELL=^G
WHO=mars
DS_USERNO=-21753
UDTBIN=/vol01/dsadm/Ascential/DataStage/ud41/bin
UDTHOME=/vol01/dsadm/Ascential/DataStage/ud41
APT_ORCHHOME=
A__z=! EXINIT=#*TMOUT
CHAR=>
DSHOME=/vol01/dsadm/Ascential/DataStage/DSEngine
EDITOR=emacs
ENV=/home/dsadm/.kshrc
EXINIT=set noexrc
HOME=/home/dsadm
HOSTNAME=usplsmarvmias03
LC_COLLATE=en_US.ISO8859-15
LC_CTYPE=en_US.ISO8859-15
LC_MESSAGES=C
LC_MONETARY=en_US.ISO8859-15
LC_NUMERIC=en_US.ISO8859-15
LC_TIME=en_US.ISO8859-15
LD_LIBRARY_PATH=/vol01/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client<snip>
LOGNAME=dsadm
MAIL=/usr/mail/dsadm
MANPATH=/usr/share/man:/usr/local/man/:/usr/sfw/share/man
ODBCINI=/vol01/dsadm/Ascential/DataStage/DSEngine/.odbc.ini
ORACLE_HOME=/vol01/local/oracle/product/11.1.0/client_1
PATH=/usr/bin:/usr/sbin:/usr/ucb:/usr/ccs/bin:/usr/local/bin:<snip>
PS1=usplsmarvmias03(usplgmgpscas009):$PWD$CHAR]0;usplsmarvmias03^G
PWD=/vol01/dsadm/Ascential/DataStage/DSEngine
R_BASE=/opt/insight
SHELL=/bin/ksh
SSH_CLIENT=144.72.84.90 1487 22
SSH_CONNECTION=144.72.84.90 1487 148.96.231.99 22
SSH_TTY=/dev/pts/2
TERM=
TMOUT=1800
TNS_ADMIN=/vol01/dsadm/tnsentry
TZ=US/Eastern
USER=dsadm
_=/vol01/dsadm/Ascential/DataStage/DSEngine/bin/uv
End of report.
Siva