Phantom 24790

halpavan2 · Post by **halpavan2** » Mon Jun 30, 2008 7:56 am

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.

ArndW · Post by **ArndW** » Mon Jun 30, 2008 8:01 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 4:33 pm

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.

veera24 · Post by **veera24** » Mon Jun 30, 2008 9:27 pm

halpavan2 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.

hi

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 11:01 pm

vi may not work so well on a Windows platform!

ArndW · Post by **ArndW** » Mon Jun 30, 2008 11:51 pm

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.

veera24 · Post by **veera24** » Tue Jul 01, 2008 9:19 pm

ray.wurlod wrote:vi may not work so well on a Windows platform! ...

Yes ray. Just now i've noticed that its for windows not for unix. But it will work out for unix right? Or is there any other way to solve this? Let me know your valuable inputs.

ArndW · Post by **ArndW** » Wed Jul 02, 2008 12:15 am

If you don't want to use "vi" on Windows, try Notepad.exe or Wordpad.exe or even WinWord.

DSXchange

Phantom 24790

Phantom 24790

Re: Phantom 24790