Page 1 of 1
the record is too big to fit in a block;
Posted: Tue May 15, 2007 1:40 am
by vskumar08
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
Posted: Tue May 15, 2007 5:42 am
by balajisr
What is the length of the column defined in columns tab?
Posted: Tue May 15, 2007 5:57 am
by vskumar08
balajisr wrote:What is the length of the column defined in columns tab?
each column is around 255 in length. Does this information matters????
Posted: Tue May 15, 2007 9:04 pm
by ray.wurlod
Is this the same question as the one in
this post?
Posted: Thu May 24, 2007 2:20 am
by vskumar08
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???
Posted: Thu May 24, 2007 2:30 am
by JoshGeorge
APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected
Posted: Thu May 24, 2007 3:28 am
by vskumar08
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.
Posted: Thu Mar 29, 2012 11:00 am
by veera24
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?