AQ Messaging Gateway - MQSeries. Help me

From: Shepotyev Nickolay <nick_at_fistech.ru>
Date: Tue, 10 Jun 2003 14:29:30 +0300
Message-ID: <bc4bu4$3br$1@gavrilo.mtu.ru>

Does anybody use this feature?
I try to execute sample ($ORACLE_HOME/mgw/samples) and get this error: What's wrong?

>>2003-06-10 11:17:03 MGW C-Bootstrap 0 LOG process-id=1872
Bootstrap program starting
>>2003-06-10 11:17:03 MGW C-Bootstrap 0 LOG process-id=1872
before CreateJavaVM
>>2003-06-10 11:17:03 MGW C-Bootstrap 0 LOG process-id=1872
JVM created -- heapsize = 64
>>2003-06-10 11:17:04 MGW C-Bootstrap 1 TRACE process-id=1872
Starting agent
>>2003-06-10 08:17:04 MGW AdminMgr 0 LOG
Connecting to database using connect string = jdbc:oracle:oci8:@
>>2003-06-10 08:17:06 MGW AdminMgr 1 TRACE main
AdminMgr: connection internal set/reset
>>2003-06-10 08:17:06 MGW AdminMgr 1 TRACE main
AdminMgr: entering getConfig
>>2003-06-10 08:17:17 MGW AdminMgr 1 TRACE main
AdminMgr: leaving getConfig
>>2003-06-10 08:17:17 MGW Engine 0 1
Agent is initializing...
>>2003-06-10 08:17:17 MGW MQD 0 LOG

Creating MQSeries messaging link:

  link          : MQLINK
  queue manager : QM_nick
  channel       : S_nick
  host          : nick
  port          : 1414
  user          :
  connections   : 1
  inbound logQ  :
  outbound logQ : default

>>2003-06-10 08:17:17 MGW AQD 0 LOG

Creating AQ messaging link:

  link          : oracleMgwAq
  database      :
  user          : MGWAGENT
  connections   : 3
  inbound logQ  : sys.mgw_recv_log
  outbound logQ : sys.mgw_send_log

>>2003-06-10 08:17:17 MGW Engine 0 7
Queue DESTQ_at_MQLINK has been registered.
>>2003-06-10 08:17:17 MGW Engine 0 9
Propagation Schedule SCH_AQ2MQ has been added.
>>2003-06-10 08:17:17 MGW Engine 0 13
MGW subscriber SUB_AQ2MQ has been created.
>>2003-06-10 08:17:17 MGW Engine 0 18
MGW subscriber SUB_AQ2MQ has been activated.
>>2003-06-10 08:17:17 MGW Engine 0 13
MGW subscriber SUB_AQ2MQ(MGWUSER.SRCQ --> DESTQ_at_MQLINK) has been created.
>>2003-06-10 08:17:17 MGW PNotifier 1 TRACE PipeNotifier
PipeNotifier: Creating/Resetting connection
>>2003-06-10 08:17:17 MGW Engine 0 2
Agent is up and running.
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker0
looking for a job
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker1
looking for a job
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker2
looking for a job
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker0
entering recoverJob for job SUB_AQ2MQ
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker1
busy job SUB_AQ2MQ 80
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker1
busy job SUB_AQ2MQ 80
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker2
busy job SUB_AQ2MQ 80
>>2003-06-10 08:17:17 MGW Engine 1 TRACE worker2
busy job SUB_AQ2MQ 80
>>2003-06-10 08:17:17 MGW AQD 1 TRACE worker0
creating database connection
>>2003-06-10 08:17:18 MGW MQD 1 TRACE worker0
MQOPHandle -- creating: oracle.mgw.drivers.mq.MQOPHandle_at_c46894
>>2003-06-10 08:17:26 MGW Engine 0 434
Bad native queue DESTQ_at_MQLINK
oracle.mgw.common.GatewayException: [800] MQSeries queue manager, QM_nick, creation failed

 at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:424)
 at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:60)
 at oracle.mgw.drivers.mq.MQLink.checkAdminConn(MQLink.java:312)
 at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:372)
 at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:49)
 at oracle.mgw.engine.JobData.init(JobData.java:163)
 at oracle.mgw.engine.Worker.recoverJob(Worker.java:708)
 at oracle.mgw.engine.Worker.myRun(Worker.java:89)
 at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

[Linked-exception]
com.ibm.mq.MQException: MQJE001: Completion Code 2, Reason 2195 at
com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java:172) at
com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnection(MQCl ientManagedConnectionFactoryJ11.java:270) at
com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnection(MQCli entManagedConnectionFactoryJ11.java:290) at
com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.java:80) at
com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConnectionMa nager.java:150)
at

com.ibm.mq.MQQueueManager.obtainBaseMQQueueManager(MQQueueManager.java:682)
 at com.ibm.mq.MQQueueManager.construct(MQQueueManager.java:620)
 at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:437)
 at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:56)
 at oracle.mgw.drivers.mq.MQLink.checkAdminConn(MQLink.java:312)
 at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:372)
 at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:49)
 at oracle.mgw.engine.JobData.init(JobData.java:163)
 at oracle.mgw.engine.Worker.recoverJob(Worker.java:708)

at oracle.mgw.engine.Worker.myRun(Worker.java:89) at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

>>2003-06-10 08:17:26 MGW Engine 0 434
Bad native queue DESTQ_at_MQLINK
>>2003-06-10 08:17:26 MGW Engine 0 LOG
Initialization failures for SUB_AQ2MQ
>>2003-06-10 08:17:26 MGW Engine 0 422
Errors occured during recovering subscriber SUB_AQ2MQ oracle.mgw.common.GatewayException: [435] Initialization failures for SUB_AQ2MQ

 at oracle.mgw.engine.Worker.recoverJob(Worker.java:709)
 at oracle.mgw.engine.Worker.myRun(Worker.java:89)
 at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

>>2003-06-10 08:17:26 MGW Engine 1 TRACE worker0
leaving recoverJob for job SUB_AQ2MQ
>>2003-06-10 08:17:26 MGW Engine 1 TRACE worker0
looking for a job Received on Tue Jun 10 2003 - 06:29:30 CDT