0 Replies Latest reply on Feb 11, 2005 7:38 PM by 277235

    AQ adapter not picking up message...

    277235
      I have a schema called AQAPP with one table based queue named: out_queue. Using a PL/SQL procedure, enqueued one message with data in XML format. I see the information in the table after executing the stored procedure.

      In iStudio created a business object based on the DTD file. Created one application called AQApp that publishes a createCustomer event. In the deploy screen, entered the name of the queue: out_queue.

      Started the AQ adapter. The messages displayed show that there are zero messages in the queue, when I can see in OEM that there is 1 message in READY state. Can someone tell me if I'm missing something?

      Here's the output from the adapter. As you can see, the correct queue name is displayed.

      This schema is in a 9.2.0.4.0 database on a W2K platform. I also applied the Patch 9 to this database.

      ============================================
      Fri Feb 11 12:56:30 CST 2005: The Adapter service is starting..
      Fri Feb 11 12:56:30 CST 2005: Registering your application (AQAPP)..
      Fri Feb 11 12:56:31 CST 2005: Messenger: Done initializing.
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : Initialization started.
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-1
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : No clean up necessary.
      Fri Feb 11 12:56:31 CST 2005: Persistence_DoneWithCleanup
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-1
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : Clean up started.
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-2
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-3
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-4
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-5
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : Finishing clean up (in final phase).
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-6
      Fri Feb 11 12:56:31 CST 2005: Persistence_DoneWithCleanup
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : No backed-up messages, so Queue Replenisher thread not needed.
      Fri Feb 11 12:56:31 CST 2005: AO Persistence: : Initialization complete.
      Fri Feb 11 12:56:31 CST 2005: CO Persistence: : Initialization started.
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-1
      Fri Feb 11 12:56:31 CST 2005: CO Persistence: : No clean up necessary.
      Fri Feb 11 12:56:31 CST 2005: Persistence_DoneWithCleanup
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-1
      Fri Feb 11 12:56:31 CST 2005: CO Persistence: : Clean up started.
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-2
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-3
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-4
      Fri Feb 11 12:56:31 CST 2005: Persistence_PerformingStep-5
      Fri Feb 11 12:56:31 CST 2005: CO Persistence: : Finishing clean up (in final phase).
      Fri Feb 11 12:56:32 CST 2005: Persistence_PerformingStep-6
      Fri Feb 11 12:56:32 CST 2005: Persistence_DoneWithCleanup
      Fri Feb 11 12:56:32 CST 2005: CO Persistence: : No backed-up messages, so Queue Replenisher thread not needed.
      Fri Feb 11 12:56:32 CST 2005: CO Persistence: : Initialization complete.
      Fri Feb 11 12:56:32 CST 2005: MessageResubmitter_readerCreated
      Fri Feb 11 12:56:32 CST 2005: MessageResubmitter_doneInitializing
      Fri Feb 11 12:56:32 CST 2005: AO Persistence: : Enable forwarding invoked.
      Fri Feb 11 12:56:32 CST 2005: AO Persistence: # of messages backed up: 0
      Fri Feb 11 12:56:32 CST 2005: AO Persistence: : No backed-up messages, so Queue Replenisher thread not needed.
      Fri Feb 11 12:56:32 CST 2005: AO Persistence: : Enable forwarding done.
      Fri Feb 11 12:56:32 CST 2005: Initializing the Bridge oracle.oai.agent.adapter.aq.XMLAQBridge..
      Fri Feb 11 12:56:33 CST 2005: Initializing connection to the Repository...
      Fri Feb 11 12:56:33 CST 2005: Connected to the Repository.
      Fri Feb 11 12:56:35 CST 2005: AQ Adapter: created a reader for queue OUT_QUEUE.
      Fri Feb 11 12:56:35 CST 2005: Starting the Bridge oracle.oai.agent.adapter.aq.XMLAQBridge..
      Fri Feb 11 12:56:35 CST 2005: CO Persistence: : Enable forwarding invoked.
      Fri Feb 11 12:56:35 CST 2005: CO Persistence: # of messages backed up: 0
      Fri Feb 11 12:56:35 CST 2005: CO Persistence: : No backed-up messages, so Queue Replenisher thread not needed.
      Fri Feb 11 12:56:35 CST 2005: CO Persistence: : Enable forwarding done.
      Fri Feb 11 12:56:35 CST 2005: Service started successfully.
      Fri Feb 11 12:57:32 CST 2005: Persistence_PerformingStep-1
      Fri Feb 11 12:57:32 CST 2005: AO Persistence: : No clean up necessary.
      Fri Feb 11 12:57:32 CST 2005: Persistence_DoneWithCleanup

      ==========================================

      Thanks in advance.

      Manoj