Hi All,
My job abend with the error "Abnormal termination of stage EX_CreateSubXML..X_Src detected"
The job design is like this:
CFF -->> Transformer -->>Pivot -->> Transformer -->> XML O/P -->> HF
^
|
|
HF
|
|
DB
This error is related to the transformer after the CFF!
First time when the job abend with this error, after several other tries, I used a Int() function of the hashed file look-up key derivation and guess, it worked!!!
Now I'm getting this error again with the same job which was working fine. And the Phantom info I have is
"From previous run
DataStage Job 4134 Phantom 31273
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.724382708.DT.1555211235.TRANS6 at address 94e."
Any thoughts?
Abnormal Termination
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
Abnormal Termination
Arun
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In server jobs error messages are always from active stage types (in this case Transformer), because only these have associated processes. When you reset (not re-compile) the job are there any "from previous run" messages logged? If so, what's in them?
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.
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
"From previous run
DataStage Job 4134 Phantom 31273
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.724382708.DT.1555211235.TRANS6 at address 94e."
Above is the info I got after resetting the job. I have included it in original post...
DataStage Job 4134 Phantom 31273
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.724382708.DT.1555211235.TRANS6 at address 94e."
Above is the info I got after resetting the job. I have included it in original post...
Arun
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
Chulett,
From all that posts I came to know it was something related to do with the Oracle stage. I removed the oracle stage from my job and even then I'm getting this error.
I split the job and wrote my src file to a hashed file and in the next job I read that Hashed file. Its working fine now.
But still I'm not sure why it is giving a error if I have a CFF or a seq file.
From all that posts I came to know it was something related to do with the Oracle stage. I removed the oracle stage from my job and even then I'm getting this error.
I split the job and wrote my src file to a hashed file and in the next job I read that Hashed file. Its working fine now.
But still I'm not sure why it is giving a error if I have a CFF or a seq file.
Arun