DG4MQ DG4MQ Issues With Triggers When AUTHORIZATION_MODEL Is Not Set To COMMIT_CONFIRM
(Doc ID 1114054.1)
Last updated on OCTOBER 17, 2019
Applies to:
Oracle Database Gateway for WebSphere MQ - Version 10.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
While executing a trigger or some auto-commit PL/SQL code that references MQSeries objects via Database Gateway for Websphere MQ (DG4MQ) the following error is returned:
ORA-20001: MQ$INTERFACE.enqueue(basic):ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.MQ$INTERFACE", line 1154
ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.RUN_ENQUEUE", line 7
ORA-06512: at "SYSTEM.TEST_OPG_TRG", line 8
ORA-04088: error during execution of trigger 'SYSTEM.TEST_OPG_TRG'
ORA-06512: at "SH_PLSQL_OWNER.MQ$INTERFACE", line 1154
ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.RUN_ENQUEUE", line 7
ORA-06512: at "SYSTEM.TEST_OPG_TRG", line 8
ORA-04088: error during execution of trigger 'SYSTEM.TEST_OPG_TRG'
Changes
This is a new install of DG4MQ and the execution of trigger code that involves MQSeries via the gateway.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |