Aggregate problem

yiminghu · Post by **yiminghu** » Tue Aug 09, 2005 2:32 pm

Hi,

I have a job that has following design

Oracle Stage --- Tranform -- Aggregate -- Oracle Stage

When I running the job, I encountered following error:

ToAggr: ds_intput() - row too big for inter stage rowbuffer

What does that mean?

Anything I could do to prevent this happening?

Thanks,

Carol

logic · Post by **logic** » Tue Aug 09, 2005 4:48 pm

Hi,
Did you try enabling or disabling the row buffer?

yiminghu · Post by **yiminghu** » Wed Aug 10, 2005 6:38 am

I enabled the 'In process' row buffer, the buffer size is 1024 K. Is that the problem?

logic wrote:Hi,
Did you try enabling or disabling the row buffer?

pnchowdary · Post by **pnchowdary** » Wed Aug 10, 2005 8:51 am

Hi,

If your datastage server is a Single Processor System, then you can use "In Process" row buffering and If your datastage server is a Multi Processor System, its advisable to use "Inter Process" row buffering.

That being said, from your error "row too big for inter stage rowbuffer". It seems like the 1024K that you have allocated for the buffer size is not enough. Try increasing the buffer size and see if it helps.

Could you please let me know the size of the input row you are trying to pass to the aggregator?