Abnormal termination of DataStage

naren6876 · Post by **naren6876** » Wed Dec 27, 2006 3:59 pm

Hi,
I am getting the following error.

From previous run
DataStage Job 258 Phantom 20761
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 4d4.

what would be the reason and how i can fix it?.
any clues would be highly appreciated.

Thanks in advance.

narasimha · Post by **narasimha** » Wed Dec 27, 2006 4:07 pm

This has been dealt with many times
Check these posts

viewtopic.php?t=98737&highlight=Fault+type+is+11

viewtopic.php?t=91775&highlight=Fault+type+is+11

A search on Fault type is 11, gives more.

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 4:08 pm

Search is your friend. Do an exact search on "Layer type is BASIC run machine"

naren6876 · Post by **naren6876** » Wed Dec 27, 2006 8:46 pm

DSguru2B wrote:Search is your friend. Do an exact search on "Layer type is BASIC run machine" ...

I went through all the posts.

In my job ,i'm reading the BLOB object from oracle table and place that in a folder.

This is the forst time it got aborted in last 6 months.

Is this related with BLOB issue?. should i report it to IBM?.

any clues please.

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 9:33 pm

In one of the results roy got the same error. All he did was re-compile the job and that took care of it. Try that.

naren6876 · Post by **naren6876** » Thu Dec 28, 2006 5:53 am

DSguru2B wrote:In one of the results roy got the same error. All he did was re-compile the job and that took care of it. Try that. ...

If it is in production, how do you explain it to yoour boss?
I can't say like just need to re compile right.
we need to give the permanant solution.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 6:21 am

Officially, server jobs do not support BLOB data type.

You may have been lucky up to now in that your BLOBs have been small enough, and now you've encountered one that's too large.

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 8:25 am

ray.wurlod wrote:Officially, server jobs do not support BLOB data type.

You may have been lucky up to now in that your BLOBs have been small enough, and now you've encountered one that's too large.

Try explaining that to your 'Boss'.
That was just a suggestion as it fixed the problem. But guess Ray hit the bull's eye by picking up the BLOB point.