Error using Aggregator stage with more records

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
rajiivnb
Participant
Posts: 77
Joined: Fri Sep 10, 2004 8:38 am
Location: India

Error using Aggregator stage with more records

Post by rajiivnb »

Hi,

I get an error as the below, after loading 3153072 records.


PstnRlns..CalMaxId: At row 3153074, link "PassThr_Agg"
Call to input link returned numeric error code: 19
.

I use a Aggregator stage and IPC stage. But I hope the error is with the Aggregator. Its not reaching upto IPC stage, as I could not see the IPC name in the error messages.

Can any one help me in finding the error?
Where I can get the details of the errors numbers ?

Thanks in advance.

Raji
paddu
Premium Member
Premium Member
Posts: 232
Joined: Tue Feb 22, 2005 11:14 am
Location: California

Post by paddu »

Raji ,

Let us know more about your source & targets

Can you tell us what exactly are you doing using aggregate stage ?

did you try running this job with small dataset ?




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

Post by chulett »

Try the job without the IPC stage and see if the error persists. Also, I hope you are processing sorted data and have asserted same in the Aggregator stage or it may not be able to handle your volume.
-craig

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