Strange behaviour in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Mar 18, 2008 6:01 pm
Strange behaviour in Transformer
I have a job which reads from a sequential file and loads into a Oracle database through a tranformer. The job gets aborted saying "Abnormal termination of stage load..t1XfrmFilterRows detected" . There are no error messages only two warnings. No conversion done in transformer. Number of records are over 10 million.
-
- Participant
- Posts: 9
- Joined: Tue Mar 18, 2008 6:01 pm
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 9
- Joined: Tue Mar 18, 2008 6:01 pm
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 9
- Joined: Tue Mar 18, 2008 6:01 pm
Yes I did get another warning. "DMDayLoad..DWFDay.inDWDay: DSD.BCIOpenW results of SQLColAttributes(PARENT_ROW_SEQ_NUM) gave MetaData mismatch
COLUMN.TYPE Expected = BigInt Actual = Numeric".
But this warning we get often and job doesn't get aborted.Only sometimes we get the job aborted.
What are phantom errors and any way to look at the error message.
COLUMN.TYPE Expected = BigInt Actual = Numeric".
But this warning we get often and job doesn't get aborted.Only sometimes we get the job aborted.
What are phantom errors and any way to look at the error message.
If you will look in the directory that holds your project, there will be a sub directory called &PH& - it will contain very small files that are used to hold output from the DataStage jobs that run in the background. Run your job again and let it abort, then go look at the very last file in that directory, it should contain additional errors related to your job.
Three notes:
1) The &PH& directory should be emptied periodically (manually) when nothing is running. IF you don't, it can cause system problems.
2) In UNIX the & is a special character - you'll need to quote the directory name to avoid problems, ie: cd "&PH&"
3) The projects are kept under the InformationServer/Server/Projects directory.
Three notes:
1) The &PH& directory should be emptied periodically (manually) when nothing is running. IF you don't, it can cause system problems.
2) In UNIX the & is a special character - you'll need to quote the directory name to avoid problems, ie: cd "&PH&"
3) The projects are kept under the InformationServer/Server/Projects directory.
-
- Participant
- Posts: 9
- Joined: Tue Mar 18, 2008 6:01 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No idea. It's your server, not ours. You can use the Administrator client to find out - even if you are not the administrator; when you have a project selected the pathname of that project directory is displayed at the bottom of the window.
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.