Hi ...
I searched the forum but could not find any solution...
We have a master seq. job which invokes 35 different child DS job in DS v8.1 FixPack1 environment (OS - Red Hat Linux v5.5).
master seq. and all child job (both) are multi-instance. master seq has to run 25 times with different parameter to complete full data load.
One of the datastage job failed twice yesterday with below error (same job run fine without any modification in second attempt)
Job control process (pid 406) has failed
job code::
ODBC connector -- > transformer --> Oracle connector stage
ODBC connector stage used to fetch data from DB2 running on AS400
and this is what I got in director after reset the job
From previous run
DataStage Job 228 Phantom 406
The variable "APT_PERFORMANCE_DATA" is not in the environment.
terminate called after throwing an instance of 'LoggingAgentConnectionException*'
Abnormal termination of DataStage.
Fault type is 6. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.WriteLog at address a3c.
What is meaning of "Fault type is 6"?
Thanks in advance.
Abnormal termination of DataStage -- Fault type is 6
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
This is what I got response back from support,
The abnormal termination of stage message indicates the writing of the log failed causing the termination.
Please refer to the following technote to change the logging, as described:
https://www-304.ibm.com/support/docview ... wg21370048
Change to
RTLogging=1
ORLogging=0
Is this make sense to you? not to me
This is what I got response back from support,
The abnormal termination of stage message indicates the writing of the log failed causing the termination.
Please refer to the following technote to change the logging, as described:
https://www-304.ibm.com/support/docview ... wg21370048
Change to
RTLogging=1
ORLogging=0
Is this make sense to you? not to me
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, it makes sense to me.
You had logging set to perform logging into the metadata repository. Something went wrong with that - it seems to have been being accessed via (an internal) Connector.
The change that Support recommended switches job logging to the engine tier, using the old style of logging into hashed files.
You had logging set to perform logging into the metadata repository. Something went wrong with that - it seems to have been being accessed via (an internal) Connector.
The change that Support recommended switches job logging to the engine tier, using the old style of logging into hashed files.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.