DSXchange

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.

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

Changing the variable default to 2000000 and it worked.
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