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.
Array Size error while compiling
Moderators: chulett, rschirm, roy
Re: Array Size error while compiling
Hi,
I got it..Thanks anyways..I was writing to an ODBc stage and dint check the array size over there..
Ash.
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.
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,
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
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