XML generation

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
go4it
Participant
Posts: 34
Joined: Wed Apr 23, 2008 5:49 am
Location: UK

XML generation

Post by go4it »

I have created the XML chunks (about 5) and when I tried to embed the XML chunks (nested loops) into the Main XML document either using a Look up or Join stage I get the following error:

Fatal Error: Virtual data set.; output of "APT_JoinSubOperatorNC in Join_256": the record is too big to fit in a block; the length requested is: 131902, the max block length is: 131072.

I went through the Advanced EE guide and found that APT_PHYSICAL_DATASET_BLOCK_SIZE size could be increased. The default size is 128k

I increased it to 256K for that Project and recompiled the jobs(restated the engine) but still get the above error.

Please let me know if I have missed anything.

With Regards
C
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Do an exact search here for "the record is too big to fit in a block".
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply