Abnormal Termination of Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Tue Nov 23, 2004 2:16 pm
- Location: New Zealand
Abnormal Termination of Stage
G'day Guys,
Ive run a job which aborted and informed me of an abnormal terminate in stage xyz.
I reset the job and got the following information in the log
From previous run
DataStage Job 8751 Phantom 21938
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.Update at address 1c8
Any ideas on this one would be greatly appreciated
cheers
Aaron
Ive run a job which aborted and informed me of an abnormal terminate in stage xyz.
I reset the job and got the following information in the log
From previous run
DataStage Job 8751 Phantom 21938
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.Update at address 1c8
Any ideas on this one would be greatly appreciated
cheers
Aaron
Please describe what your job is trying to do. Include stage types, databases involved, etc. If you have any before/after job/stage routine calls, or use any user-written functions.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 4
- Joined: Tue Nov 23, 2004 2:16 pm
- Location: New Zealand
The job is taking a sequential file running it a pair of transforms, the first being used as a constraint record filter, the second to insert into a oracle 9 database table.
There is 1 user-written function involved which places values into a key relationship table. This function is used in a multitude of other jobs without error.
Immeditely prior to the abnormal termination error we had an attempt to insert a null into the destination table, but that was expected.
There is 1 user-written function involved which places values into a key relationship table. This function is used in a multitude of other jobs without error.
Immeditely prior to the abnormal termination error we had an attempt to insert a null into the destination table, but that was expected.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 4
- Joined: Tue Nov 23, 2004 2:16 pm
- Location: New Zealand
Based on your error message I'm going to guess that your issue is within your user written subroutine. This error might occur for many different reasons and without seeing the actual code it would be too hard to tell you where to look.
Regards,
Regards,
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can't agree; the fault was reported from DSD.Update, which is one of "theirs".
Are you trying to stuff too many characters into an output column (for example 14 characters into a CHAR(12), or more than 10 digits into an INTEGER)? Are you trying to update a not null column with NULL ?
Are you trying to stuff too many characters into an output column (for example 14 characters into a CHAR(12), or more than 10 digits into an INTEGER)? Are you trying to update a not null column with NULL ?
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.
Hello,
I have here this same problem in DataStage version 7.0.1.
In my job, I removed all my OCI stages. This means, that now I just read and write sequential files (one of 2282660 lines for input and another one for ouput) with no transformer in the middle (my input file has 1,7 GB).
Well, I am also suspecting about the construction of the input file. It was created by 3 transformers (appending one after the other). I just modified the job to execute a UNIX "cat" command in the Before-Stage.
I'm running now this job.
Best regards,
Rui Moito
I have here this same problem in DataStage version 7.0.1.
In my job, I removed all my OCI stages. This means, that now I just read and write sequential files (one of 2282660 lines for input and another one for ouput) with no transformer in the middle (my input file has 1,7 GB).
Well, I am also suspecting about the construction of the input file. It was created by 3 transformers (appending one after the other). I just modified the job to execute a UNIX "cat" command in the Before-Stage.
I'm running now this job.
Best regards,
Rui Moito
-
- Participant
- Posts: 4
- Joined: Tue Nov 23, 2004 2:16 pm
- Location: New Zealand
Thanks for all your suggestions guys.
We found that the transform stage in the middle of the job was tripping up over some of the data records and suspect that when cloning the job something internal happened to the transform stage in question.
We have subsequently changed the process by pre-loading our key lookups into a hash file, this flows through to the transform which we re-built and the whole thing seems to work fine now.
Regards
Aaron
We found that the transform stage in the middle of the job was tripping up over some of the data records and suspect that when cloning the job something internal happened to the transform stage in question.
We have subsequently changed the process by pre-loading our key lookups into a hash file, this flows through to the transform which we re-built and the whole thing seems to work fine now.
Regards
Aaron
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your previous description of your job made no mention of three sequential files. If it had, we could probably have resolved the issue more quickly.
[To everyone] It is vital that you describe accurately and as completely as possible any error messages and job designs when asked. Otherwise diagnosis is very difficult indeed.
[To everyone] It is vital that you describe accurately and as completely as possible any error messages and job designs when asked. Otherwise diagnosis is very difficult indeed.
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.