ORA-29400 Retrieving a Message With Greater Than 4MB in Size from Database Gateway forWebSphere MQ

(Doc ID 2399434.1)

Last updated on MAY 23, 2018

Applies to:

Oracle Database Gateway for WebSphere MQ - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

You are unable to receive messages from WebSphere MQ with a size greater than 4MB using Database Gateway forWebSphere MQ (DG4MQ).

Smaller sized messages are received without problems (for example with length 4194300).


The following error is encountered:


 declare
*
ERROR at line 1:
ORA-29400: data cartridge error
MQI MQGET failed. completion code=2, reason code=2010
ORA-06512: at line 127
ORA-06512: at "SYS.PGM", line 396
ORA-06512: at "SYS.PGM_MQGET_STR_ARRAY", line 1
ORA-06512: at "SYS.PGM", line 367
ORA-06512: at "SYS.PGM", line 855
ORA-06512: at line 55
ORA-06512: at line 121

Changes

 Target MQ queue having default size for queue  is 4MB

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms