I am using MQ Connector on DataStage 8.1 to read an xml message.
I am getting this error " WebSphere_MQ_Connector_0,0: Fatal Error: Virtual
data set.; output of "WebSphere_MQ_Connector_0": the record is too big to
fit in a block; the length requested is: 1646578, the max block length is:
131072."
Is there a parameter, I need to tweak to handle this error?
Please advise.
MQ Connector Payload size limit
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA
Here are some things to try....
Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector....
Try a Server Job. It may not be what you need, but it might offer clues as to the issue, as Server sometimes is less finicky about large columns.
Ernie
Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector....
Try a Server Job. It may not be what you need, but it might offer clues as to the issue, as Server sometimes is less finicky about large columns.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA
Changing the variable default to 2000000 and it worked.
Thanks a lot for your suggestion.
Thanks a lot for your suggestion.
eostic wrote:Here are some things to try....
Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector....
Try a Server Job. It may not be what you need, but it might offer clues as to the issue, as Server sometimes is less finicky about large columns.
Ernie