Variable length key is too large (32981) ,limit is 32767

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
basu.ds
Participant
Posts: 118
Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore

Variable length key is too large (32981) ,limit is 32767

Post by basu.ds »

Hi ,
I am trying to write data from xml output column data into single field(longvarchar) in sequential file but I am getting this error "Variable length key is too large (32981) ,limit is 32767" I tried with increasing APT_DEFAULT_BLOCK_SIZE but didn't work , please help me to get this issue resolve.

Thanks.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If you replace the sequential file stage with a PEEK stage does the error still persist?
My guess is that it is related to your XML stage rather than the sequential file stage. Does the XML contain strings that are larger than 32Kb?
basu.ds
Participant
Posts: 118
Joined: Tue Feb 06, 2007 12:59 am
Location: Bangalore

Post by basu.ds »

yes,xml string contains larger than 32k
Post Reply