2 Replies Latest reply on Aug 24, 2006 2:01 PM by 416900

    WE ARE HAVING PROBLEMS SUBSCRIBING EVENTS IN INTERCONNECT.

    517450
      Hi all,

      We have installed the Oracle DB Adapter and Oracle Applications Adapter to test publishing and subscribing events with different adapters. We have designed two new test. One publishing a message with the Oracle Applications Adapter and subscribing it with the DB Adapter. The other publish the message with the DB Adapter and subscribe it with the Oracle Applications Adapter.

      None of the subscribing procedures have worked. The two publishing events have
      sended the messages correctly to the hub and there are still stucked there. The message is never subscribed by the event we have defined
      on the iStudio. It is left on the hub message list forever and is no able
      to push it out.

      Questions:
      - Is there any procedure to push the messages through the InterConnect Hub?
      - Does customer has to create any recurring application procedure to pool the InterConnect Hub to push the messages left there?

      Can everyone help us with this?

      Regards,

      Francisco Javier Guzmán
        • 1. Re: WE ARE HAVING PROBLEMS SUBSCRIBING EVENTS IN INTERCONNECT.
          511304
          Hi,

          If you using InterConect 10.1.2 or above, you can use ICManager utility to push the messages from the Hub to the Subscribing Adapters.

          Also, you dont have to pool for the messages to be pushed to the Subscribing adapters, But in your case, make sure you have the correct application name in the Publishing procedure. The messages are sent to the recipent applications listed in the publishing Procedures.

          Thanks,
          Harish
          • 2. Re: WE ARE HAVING PROBLEMS SUBSCRIBING EVENTS IN INTERCONNECT.
            416900
            What does the subscribing adapter log file say?

            Are there any issues reported on the OAI_AGENT_ERROR table in the hub?

            Have you created the subscribe packaged procedures on your target database?

            •     In iStudio, click on 'File', 'Export PL/SQL'.
            •     Expand 'Applications', '{YOUR_SUBSCRIBING_ADAPTER}' and 'Subscribed Events'.
            •     Highlight the 'Subscribe' Event.
            •     In 'File Prefix', browse or enter the output directory, plus a prefix if required
            •     Press 'OK'
            •     You will see 'Operation Complete Successfully'
            •     Use Windows Explorer, and go to the directory you selected. You will see a file called "[PREFIX]_YOUR_SUBSCRIBING_ADAPTER}_[Sub_Event_Name].sql"

            Run this sql script on the subscribing system, under the user you are using to connect in the Subscribing adapters adapter.ini file. This will create the subscribe procedure.

            Stop your adapters. Clear out any metadata. Start your adapters.

            Try again.

            Also, the name of the Application in iStudio must be the same as the application name configured in the adapter.ini file.

            HTH

            Yan

            P.S. send me a email to ian_scorrer@yahoo.com with the subject of "Simple", and I'll send you a worked example of a simple DB to DB publish and subscribe.