Issue with Server Job validation

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dxk9
Participant
Posts: 105
Joined: Wed Aug 19, 2009 12:46 am
Location: Chennai, Tamil Nadu

Issue with Server Job validation

Post by dxk9 »

Hi,

A server job threw "Abnormal termination of stage transformer_name detected" error in Dev.

We migrated this Server Job from Datastage V7.5.2 to new Datastage v8.5.

Job design is DB2 stage(source) --> Transformer --> DB2 Stage(target) & DB2 Stage (rejects)

It is a direct pass through the Transformer and the rejects from DB2 target are sent to DB2 Rejects.

The job compiles fine, but when I validate, I get the following error without much info:

"Abnormal termination of stage Job001_PROD_CVT_CODS_TO_STG_Modified..LoadSTGTransformer detected"

When I reset the job, I get the following message in log:

From previous run
DataStage Job 7 Phantom 792
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 528.

can you plz help me with this ?

Regards,
Divya
kamtammystuff
Participant
Posts: 26
Joined: Fri Feb 19, 2010 2:08 am

Re: Issue with Server Job validation

Post by kamtammystuff »

Server Jobs always have this disadvange , it will never point out to a specific error. Try deleting the transformer and introduce a new transformer.
dxk9
Participant
Posts: 105
Joined: Wed Aug 19, 2009 12:46 am
Location: Chennai, Tamil Nadu

Post by dxk9 »

Tried with a new transformer, but it didn't help :(

Regards,
Divya
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Try to re-create the job from scratch and validate it to check whether job validation in 8.5 is working fine or not.

Do this first and post the outcome.
Arvind
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Issue with Server Job validation

Post by chulett »

kamtammystuff wrote:Server Jobs always have this disadvange , it will never point out to a specific error. Try deleting the transformer and introduce a new transformer.
I beg to differ on general principal, never mind the fact that they posted a very specific error. If you search the forum for "Fault type is 4" you'll find that it is a SIGILL (illegal instruction signal) and that you should contact your official support provider for help.

Please make sure you return and let us know what the resolution is!
-craig

"You can never have too many knives" -- Logan Nine Fingers
kamtammystuff
Participant
Posts: 26
Joined: Fri Feb 19, 2010 2:08 am

Re: Issue with Server Job validation

Post by kamtammystuff »

Is this resolved?
dxk9
Participant
Posts: 105
Joined: Wed Aug 19, 2009 12:46 am
Location: Chennai, Tamil Nadu

Post by dxk9 »

No. The problem still exists while Validating :(

But the confusing part is, the job RUNS fine if we skip VALIDATING part.

Regards,
Divya
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What did your official support provider have to say?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply