1 Reply Latest reply on Dec 7, 2004 1:48 PM by 433992

    ORA-01422 when using FTP adapter

    433992
      Hello,
      I am trying to implement the Implicit Length Arrays, on page B-24 of the Interconnect users guide. I copied the sample D3L, configured the publishing FTP adapter and subscribing DB Adapter using i-Studio, and when I fired up my adapters, I got this error(snippet of my adapter log):

      ...
      Thu Dec 02 20:27:42 EST 2004: Transport logs:
      [IPT_TaskCompleted] Reading contents of orders_test.dat is completed for FileAgent.
      Thu Dec 02 20:27:42 EST 2004: Transport logs:
      [IPT_FileRecMonitorPutMessage] Put one message 1102037262144 in the list.
      Thu Dec 02 20:27:42 EST 2004: Transport logs:
      Transferring of ftp file orders_test.dat to TechBridge is completed.
      Thu Dec 02 20:27:42 EST 2004: Messenger: subscribe topic session created for: oai_hub_queue
      Thu Dec 02 20:27:42 EST 2004: Messenger: queue connection started.
      Thu Dec 02 20:27:42 EST 2004: Messenger_subscribeQueueSessionCreated
      Thu Dec 02 20:27:43 EST 2004: There was an error subscribing to Topic or Queue oai_hub_queue. The Adapter will automatically subscribe to oai_hub_queue when the error has been corrected.
      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 1

           at 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)

      Any ideas why this was encountered?

      Thanks,
      Clint