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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 433992, 1 year ago
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)
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.(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.(AgentProxy.java:413)
at oracle.oai.agent.service.AgentService.run(AgentService.java:41)
at java.lang.Thread.run(Thread.java:534)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.