the record is too big to fit in a block;

vskumar08 · Post by **vskumar08** » Tue May 15, 2007 1:40 am

I am getting the error as FATAL ERROR: Virtual data Set;.....; the record is too big to fit in a block; the length requested is : 135012. when i am running the DataStage and trying to load data using Oracle enterprise.

Can anyone suggest me how to over come this

balajisr · Post by **balajisr** » Tue May 15, 2007 5:42 am

What is the length of the column defined in columns tab?

vskumar08 · Post by **vskumar08** » Tue May 15, 2007 5:57 am

balajisr wrote:What is the length of the column defined in columns tab?

each column is around 255 in length. Does this information matters????

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 9:04 pm

Is this the same question as the one in this post?

vskumar08 · Post by **vskumar08** » Thu May 24, 2007 2:20 am

ray.wurlod wrote:Is this the same question as the one in this post? ...

Yes, this is the same question

Error: ##F TFDR 000043 13:36:21(001) <Oracle_Enterprise_3,0> Fatal Error: Virtual data set.; output of "Oracle_Enterprise_3": the record is too big to fit in a block; the length requested is: 134048.

any suggestion???

JoshGeorge · Post by **JoshGeorge** » Thu May 24, 2007 2:30 am

APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected

vskumar08 · Post by **vskumar08** » Thu May 24, 2007 3:28 am

JoshGeorge wrote:APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected

Thanks, it is working perfectly fine.

veera24 · Post by **veera24** » Thu Mar 29, 2012 11:00 am

JoshGeorge wrote:APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected

Just curious...What could be the maximum value we can set for this variable?