DataStage Job 73 Phantom 24790
Program "JOB.1872841101.DT.1479270838.TRANS2": Line 247, Improper data type.
Attempting to Cleanup after ABORT raised in stage MF_FUM_test..TRNS_LKUP
DataStage Phantom Aborting with @ABORT.CODE = 3
Could any body help regarding this.
Phantom 24790
Moderators: chulett, rschirm, roy
Phantom 24790
pavan
Look at your transform stage. Perhaps you are performing some mathematical operation on a column containing non-numeric data. Does the transform have many derivations that are not 1:1?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Look at RT_BP73/JOB.1872841101.DT.1479270838.TRANS2 on your server (in the project directory) around line #247, to see what might be causing this error.
Look at RT_BP73/JOB.1872841101.DT.1479270838.TRANS2 on your server (in the project directory) around line #247, to see what might be causing this error.
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.
Re: Phantom 24790
hihalpavan2 wrote:DataStage Job 73 Phantom 24790
Program "JOB.1872841101.DT.1479270838.TRANS2": Line 247, Improper data type.
Attempting to Cleanup after ABORT raised in stage MF_FUM_test..TRNS_LKUP
DataStage Phantom Aborting with @ABORT.CODE = 3
Could any body help regarding this.
this is the problem with the transformer. So better you can do the following.....
1: cd $DSHOME
2: cd ../Projects/<YourProjectName>/RT_BPnnn
3: Then do 'ls' command to view the file name.
4: Use 'vi' command.
(For this case: vi JOB.1872841101.DT.1479270838.TRANS2- this thing you can get it from director itself)
5: Now you can look into the source code. (Line number mentioned at the director--Line 247 ) and do the appropriate needful.
Thanks in advance...
veera...
veera...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You will also need to use an internal command to locate the RT_BPnnn file, but from the project you can always use "find" to locate the file. If you only have a few derivations it might be faster just to look into your TRANS2 transformer stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If you don't want to use "vi" on Windows, try Notepad.exe or Wordpad.exe or even WinWord.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>