This content has been marked as final. Show 4 replies
It can be in most cases...))
Simply stop adapters and repository, stop 2 queues in ICHUB schema
and delete messages by hand (delete from OAI_HUB_QUEUE).
Than start 2 queues back and start repository and adapters.
Deleting the messages using ICManager may not work sometimes. Conect to the hub using sql plus and delete the records from oai_hub_queue. Try the following steps.
1. sqlplus ichub/<<pasword>>
2. truncate table oai_hub_queue; (Try this command only if you want to remove all the messages from the hub , otherwise use DELETE .. command to delete records one by one.)
Simply do a truncate or 'delete from' a queue table can be very dangerous. It can get corrupted. I find the best way to delete 'stale' messages is to simply re-create the queues by running <AS_HOME>/integration/interconnect/repository/sql/create_queues.sql. I've done this even with running adapters and a continuing flow of messages coming in.
Be aware though that this deletes all messages.
Message was edited by:
I've got to agree with Arjan posting above - Pls refrain from deleting or truncating stale messages from the queue table but simply re-create the queues by running <AS_HOME>/integration/interconnect/repository/sql/create_queues.sql.