Hi,
I am getting following Phantom error
how to look at line # 220 and from where
DataStage Job 330 Phantom 20630
Program "JOB.403394601.DT.1369463998.TRANS2": Line 220, Improper data type.
Attempting to Cleanup after ABORT raised in stage JobNameABC..Transformer_32
DataStage Phantom Aborting with @ABORT.CODE = 3
Any help!!!
Thanks
Phantom 20630
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Although it is possible to track down the approximate source line where this is occuring, it is usually much faster to look at your job, and in every transform look at the columns where you perform data manipulation, especially mathematical operations. As Sainath stated, most likely you are performing a mathematical operation on a variable or column that contains string data that cannot be converted.
Even though a column in Server might be declared as "Integer", if the values from from a non-typed source (like a text file) chances are that it can contain text somewhere, this is a frequent case of a job suddenly giving an error of the type you are seeing.
Even though a column in Server might be declared as "Integer", if the values from from a non-typed source (like a text file) chances are that it can contain text somewhere, this is a frequent case of a job suddenly giving an error of the type you are seeing.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your job number is 330 (from the error message).
In the project directory on the server is a subdirectory called RT_BP330 which contains the code generated by compiling Transformer stages and job control routine for this job.
Within that directory is a file called JOB.403394601.DT.1369463998.TRANS2 which is the source code referred to in the error message.
You can view this with any text viewer. One that can add line numbers is to be preferred (for obvious reasons).
In the project directory on the server is a subdirectory called RT_BP330 which contains the code generated by compiling Transformer stages and job control routine for this job.
Within that directory is a file called JOB.403394601.DT.1369463998.TRANS2 which is the source code referred to in the error message.
You can view this with any text viewer. One that can add line numbers is to be preferred (for obvious reasons).
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.