Page 1 of 1

Phantom error

Posted: Tue Jun 08, 2010 6:35 am
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.

Posted: Tue Jun 08, 2010 6:40 am
by ArndW
It looks as if you have put an output row limiter of 1 on that link from your transfrom stage.

Posted: Tue Jun 08, 2010 6:41 am
by chulett
In other words, a Reject link with a 'Abort after X rows' setting of 1.

Posted: Tue Jun 08, 2010 4:49 pm
by ray.wurlod
Indeed any link with an output row count limit of 1.

Posted: Tue Jun 08, 2010 8:11 pm
by chulett
Of course, knew someone would come along and note that. :wink: