oracle.jms.AQjmsException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4337 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS_INTERNAL", line 110 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS", line 101 ORA-06512: at line 1at oracle.jms.AQjmsSession.addDurableSubscriber(AQjmsSession.java:3684)

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • ORA-01422 when using FTP adapter
    via by 433992,
  • AQJMS Exception In B2B
    via by 622858,
  • Messages increasing in event_qtab
    via by 684431,
  • JMS/AQ: Running out of memory ORA-04031
    via by 198189,
  • oracle interconnect sdk adapters
    via by 395785,
    • oracle.jms.AQjmsException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4337 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS_INTERNAL", line 110 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_AQJMS", line 101 ORA-06512: at line 1at oracle.jms.AQjmsSession.addDurableSubscriber(AQjmsSession.java:3684) at oracle.jms.AQjmsSession.createSubInOldMode(AQjmsSession.java:2805) at oracle.jms.AQjmsSession.createDurableSubscriber(AQjmsSession.java:2519) at oracle.jms.AQjmsSession.createDurableSubscriber(AQjmsSession.java:2451) at oracle.jms.AQjmsSession.createDurableSubscriber(AQjmsSession.java:2351) at oracle.oai.agent.common.jms.Subscriber.<init>(Subscriber.java:70) at oracle.oai.agent.common.jms.JMSManager.subscribeTopic(JMSManager.java:714) at oracle.oai.agent.common.jms.JMSManager.subscribe(JMSManager.java:647) at oracle.oai.agent.server.messenger.mercury.MercuryMessenger.subscribe(MercuryMessenger.java:534) at oracle.oai.agent.server.ServerManager.subscribe(ServerManager.java:582) at oracle.oai.agent.proxy.AgentProxy.subscribe(AgentProxy.java:577) at oracle.oai.agent.client.AgentImpl.registerMessageReceiver(AgentImpl.java:644) at oracle.oai.agent.client.AgentImpl.registerMessageReceiver(AgentImpl.java:574) at oracle.oai.agent.adapter.technology.TechBridge.init(TechBridge.java:499) at oracle.oai.agent.proxy.AgentProxy.go(AgentProxy.java:661) at oracle.oai.agent.proxy.AgentProxy.start(AgentProxy.java:700) at oracle.oai.agent.proxy.AgentProxy.<init>(AgentProxy.java:413) at oracle.oai.agent.service.AgentService.run(AgentService.java:41) at java.lang.Thread.run(Thread.java:534)
    No Bugmate found.