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
Aggregate problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
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?
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?
Thanks,
Naveen
Naveen