Phantom error

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
sagar deshmukh
Participant
Posts: 103
Joined: Fri Jan 18, 2008 12:55 am
Location: chennai

Phantom error

Post by sagar deshmukh »

Hi, I have a very simple job....

Oracle stage ---> trasformer --- > Seq. file stage...

I am getting below error...

This job is scheduled in a sequence....the sequence in terns calls many routines....

I am getting below error for this job....

Code: Select all

DataStage Job 604 Phantom 2104
Aborting after 1 Rows written to jbTableRecordCount.xmCheckRecordCount.lk_NoRecordsProcessed
Program "JOB.1985595053.DT.1472930916.TRANS1": Line 71, Abort.
Attempting to Cleanup after ABORT raised in stage jbTableRecordCount.jbTableRecordCount.xmCheckRecordCount
DataStage Phantom Aborting with @ABORT.CODE = 1
please help me out with this regards..

Thanks
SD

P.S. : i tried to search similar issue but couldnt find any firm solution/guidance.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

It looks as if you have put an output row limiter of 1 on that link from your transfrom stage.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

In other words, a Reject link with a 'Abort after X rows' setting of 1.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Indeed any link with an output row count limit of 1.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Of course, knew someone would come along and note that. :wink:
-craig

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