DSXchange

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

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

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?

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?