Page 1 of 1
Getting error in a job using Aggregator
Posted: Wed Apr 25, 2007 11:41 pm
by shaonli
Hi,
I am running a job in DS 7.5 with an aggregator.The volume of data is almost 14056919.The job is getting aborted when it is trying to aggregate the data after selecting from the source.
The error is "job1 Aggregator_9: |-100|"
The buffer memeory is 1024 kb.
Please suggest.
Thanks
Shaonli
Posted: Wed Apr 25, 2007 11:57 pm
by chulett
You need to presort your data to support your grouping keys and assert the sorted order in the Aggregator stage.
Posted: Thu Apr 26, 2007 12:16 am
by soumik
I feel you also need to change the INTER PROCESS BUFFER size for this job in order to make aggregation possible for huge data.
Posted: Thu Apr 26, 2007 12:19 am
by shaonli
Soumik,
Can you tell me the size of the Inter Process Buffer Memory?
Thanks
Shaonli
Posted: Thu Apr 26, 2007 12:44 am
by ray.wurlod
With presorted data you won't need big buffers.
Posted: Thu Apr 26, 2007 3:07 am
by shaonli
Hi,
Using sorter also the job is getting aborted with this error "Error in merging files
At row 1, link "INST_Cds1"
Call to output link returned numeric error code: -100"
Please suggest.
Posted: Thu Apr 26, 2007 3:28 am
by nick.bond
Can you provide your job design? What are all the stages you have?
Posted: Thu Apr 26, 2007 4:30 am
by shaonli
source->transformer->sorter->aggregrator->target.
it is getting aborted after transformer.
Posted: Thu Apr 26, 2007 5:18 am
by nick.bond
Make a few copies of your job and break it up to determine what is causing the error. have a version with just the tfm, one with tfm and sort.