1 Reply Latest reply on Jan 24, 2008 3:14 PM by user613835

    Published message appears in OAI schema but does not move to hub queue

    474228
      We have a number of hub flows which no longer publish to the hub - the details appear in the OAI schema tables and the relevant adapters are up however they never move from the OAI tables into the hub queue and beyond. The details in these tables look OK, The applicationtype value in the messageobjecttable corresponds to the name of the adapter which should pick the message up. The only field which is not populated is sender name

      Can anyone advise how to resolve this?

      The trigger code to publish the message is:

      the table has one column - A VARCHAR2(10);

      DECLARE
      l_messageobjectid NUMBER;
      l_aoid NUMBER;

      BEGIN
      test.crmsg_my_new_test_oai_v1(l_messageobjectid,l_aoid,:new.a);
      test.pub_my_new_test_oai_v1(l_messageobjectid,'CORP');
      -- CORP is the name of the adapter
      END;

      Thanks,

      M