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 and later
Information in this document applies to any platform.


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

... 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(
    at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeQuery(
    at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.loadJMS(
    at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.execute(
    at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(
    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(

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( QMgr(QMVSOC01)

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

The specified entity is not authorized to access the required object. The
following requested permissions are unauthorized: get/inq
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


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



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