Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Please advise with exception

685128Feb 14 2009 — edited Feb 15 2009

Hi All.

Do you have quick ideas about exception?

Thanks.

Errors occurred during processing of subscriber SUBSCRIBER_1
oracle.mgw.common.GatewayException: [705] Dequeue failed for OUT_PUB1_AQ; SQL error: 25226
at oracle.mgw.common.MgwUtil.GatewayException(MgwUtil.java:747)
at oracle.mgw.drivers.aq.AQMsgConsumer$Dequeuer.dequeueOp_SQLError(AQMsgConsumer.java:1221)
at oracle.mgw.drivers.aq.AQMsgConsumer$FlatMgwBasicMsg_Dequeuer.dequeueOp(AQMsgConsumer.java:1839)
at oracle.mgw.drivers.aq.AQMsgConsumer$Dequeuer.dequeueMessage(AQMsgConsumer.java:931)
at oracle.mgw.drivers.aq.AQMsgConsumer.doDequeue(AQMsgConsumer.java:679)
at oracle.mgw.drivers.aq.AQMsgConsumer.dequeue(AQMsgConsumer.java:536)
at oracle.mgw.drivers.aq.AQLink.receive(AQLink.java:1807)
at oracle.mgw.engine.Worker.deqMessages(Worker.java:341)
at oracle.mgw.engine.Worker.processJob(Worker.java:1907)
at oracle.mgw.engine.Worker.myRun(Worker.java:96)
at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

[Linked-exception]
java.sql.SQLException: ORA-25226: dequeue failed, queue OUT_PUB1_AQ is not enabled for dequeue
ORA-06512: at "SYS.DBMS_AQ", line 335
ORA-06512: at "SYS.MGW_AQDRIVER", line 305
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:572)
at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:765)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
at oracle.mgw.drivers.aq.AQMsgConsumer$FlatMgwBasicMsg_Dequeuer.dequeueOp(AQMsgConsumer.java:1785)
at oracle.mgw.drivers.aq.AQMsgConsumer$Dequeuer.dequeueMessage(AQMsgConsumer.java:931)
at oracle.mgw.drivers.aq.AQMsgConsumer.doDequeue(AQMsgConsumer.java:679)
at oracle.mgw.drivers.aq.AQMsgConsumer.dequeue(AQMsgConsumer.java:536)
at oracle.mgw.drivers.aq.AQLink.receive(AQLink.java:1807)
at oracle.mgw.engine.Worker.deqMessages(Worker.java:341)
at oracle.mgw.engine.Worker.processJob(Worker.java:1907)
at oracle.mgw.engine.Worker.myRun(Worker.java:96)
at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:58)

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2009

Added on Feb 14 2009

#advanced-queueing, #database-key-features

2 comments

3,150 views