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);
-- CORP is the name of the adapter
What type of adapter is defined for publisher and subscriber? When you raise debugging level to 2 then you can monitor both process from the log file. If subscriber is AQ then you might want to stop the wf service. This will remain the message in the queue. If subscriber(AQ) is defined properly and is dequeued the message then you should see the process via adapter's log.