Abnormal termination

[SPA_BI]

Hi,

One of the my job aborted and the there was only one warning message: Abnormal termination of stage <Jobname>..Transform detected

and here's the From previous run message generated when I reset the job:

From previous run
DataStage Job 892 Phantom 7929
kgefec: fatal error Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1077009604.DT.1386139145.TRANS10 at address 10

Any idea what might cause the error?

[DSguru2B]

Is the error reproducable? Anyways, search on keywords "Layer type is BASIC run machine"

[ray.wurlod]

Can you please execute the following command in the Administrator client command window?

Code: Select all

VLIST RT_BP869 JOB.1077009604.DT.1386139145.TRANS10 

The second column contains hex addresses. Find address 0x10, and post a few statements either side of it.
From that, you will be able to discern the statement that generated the problem.

[SPA_BI]

The output was:

"RT_BP869" is not a file name.

Anyway I have this intuition that this error was caused by the server running out of memory and swap space. It was trying to write 15-18 million rows to a bulk loader.

[DSguru2B]

I highly doubt thats the problem. That amount is peanuts for the bulk loader. I believe it was a typo from Ray's end. Its RT_BP892 and not RT_BP869. So run the following and post the result

Code: Select all

VLIST RT_BP892 JOB.1077009604.DT.1386139145.TRANS10

Also, can you explain what your design is and what stages you are using.

[ray.wurlod]

Its true! Males can't multitask!

[I_Server_Whale]

Its true! Males can't multitask!

That is why there are more male Nobel prize winners than females.

[DSguru2B]

That is why there are more male Nobel prize winners than females.

Now now, your going to start a war here. ThankGod we dont have many females here or you would have gotton it, good

[ray.wurlod]

Now, now, you're going start a war here. Not everyone has a religious belief that involves a single god, or even a religious belief at all.

Though I've heard it claimed that atheism is the strongest form of faith.

[I_Server_Whale]

One God, Many Gods, No God.......

I'd be happy to be in the abysses of oblivion. :D

[chulett]

Ok... since this thread has gone totally off track, I don't feel too bad about continuing its downhill slide. And since this ties in (somewhat) with the subject of the post, I thought I would pass along this interesting website, which was the recent cause of a very long and LOUD 'discussion' in the office next to my digs earlier in the week. Enjoy!

[DSguru2B]

The OP is going to be very happy when he/she sees what happen to his post

[narasimha]

Has the post been Abnormally Terminated

[ray.wurlod]

When the result of the (correct) VLIST command is posted, then we'll be able to offer more cogent advice.

[SPA_BI]

Here's the output. I hope I type out the right section

Code: Select all

...

00159: $INCLUDE DSINCLUDE DSD_STAGE.H
00159 00000 : 058 dimcom            STAGECOM.PIN 1024 => 1
00159 00008 : 058 dimcom            STAGECOM.NUM.ROWS 1024 => 1
00159 00010 : 058 dimcom            STAGECOM.ARR 8192 => 1

00160: $INCLUDE DSINCLUDE DSD_BCI.H
...

anyway how can I copy and paste the output from ds administrator command output.

Also the above command doesn't work with uv:

Code: Select all

rwvapp505:/x02/dsdata/DataStage/Projects/TST01\}uv
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
TST01 logged on: Mon Feb  5 14:07:47 2007

>vlist rt_bp892 job.1077009604.dt.1386139145.trans10    
"rt_bp892" is not a file name.
>vlist rt_bp892 job.1077009604.dt.1386139145.trans10
"rt_bp892" is not a file name.
>