JMSWMQ2008 Message Is Received When Using ODI To Read A IBM MQ Series 7 Queue Or Topic (Doc ID 2077688.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.

Symptoms

The following error message is observed when using Oracle Data Integrator (ODI), and version 7.1.0.5 of MQ driver to read a JMS message from IBM MQ 7.1.0.3 Queue (or Topic):

... com.ibm.msg.client.jms.DetailedJMSSecurityException: JMSWMQ2008: Failed to open MQ queue 'MYQUEUE'. JMS attempted to perform an MQOPEN, but WebSphere MQ reported an error. Use the linked exception to determine the cause of this error. Check that the specified queue and queue manager are defined correctly.
    at com.sunopsis.jdbc.driver.SnpsDriverStatement.executeQuery(SnpsDriverStatement.java:110)
    at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeQuery(SnpsDriverPreparedStatement.java:139)
    at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.loadJMS(JMSXMLPreparedStatement.java:758)
    at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.execute(JMSXMLPreparedStatement.java:154)
    at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
    ...

At same time, the following AMQ8077 message is reported in the MQ server log:

09/09/15 11:16:24 - Process(10397.51) User(mqmadm) Program(amqzlaa0)
                    Host(znilcx) Installation(Installation1)
                    VRMF(7.1.0.3) QMgr(QMVSOC01)

AMQ8077: Entity 'appsoci     ' has insufficient authority to access object
'MYQUEUE'.


EXPLANATION:
The specified entity is not authorized to access the required object. The
following requested permissions are unauthorized: get/inq
ACTION:
Ensure that the correct level of authority has been set for this entity against
the required object, or ensure that the entity is a member of a privileged
group. 

 

Note "MYQUEUE" is the Queue name, and "appsoci" - the application user.

 

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