Array Size error while compiling

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
logic
Participant
Posts: 115
Joined: Thu Feb 24, 2005 10:48 am

Array Size error while compiling

Post by logic »

Hi All,
I am getting an error as follows while compiling...
"Internal Column Storage exceeded, limit is 8192 items ,reduce specified array size(Transformer name)"
I am using DRS stage.
I had a LongVarchar column of length 1200 I reduced it to 250 also I made array size=1...error persists. What else should I look into?
Thanks
Ash.
logic
Participant
Posts: 115
Joined: Thu Feb 24, 2005 10:48 am

Re: Array Size error while compiling

Post by logic »

Hi,
I got it..Thanks anyways..I was writing to an ODBc stage and dint check the array size over there..
Ash.


logic wrote:Hi All,
I am getting an error as follows while compiling...
"Internal Column Storage exceeded, limit is 8192 items ,reduce specified array size(Transformer name)"
I am using DRS stage.
I had a LongVarchar column of length 1200 I reduced it to 250 also I made array size=1...error persists. What else should I look into?
Thanks
Ash.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
the max value you can use for array size in cases like this is 8192/number of columns.
some times you still need to reduce 1 or 2 from the result and your fine.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply