4 Replies Latest reply on Jul 4, 2007 9:36 AM by 452012

    Message can't be deleted using ICManager

    439096
      I am trying to remove a message from the hub-queue using ICManager. via Hub queue management menu I select delete-option.
      I am not getting the prompt back, message can;t be deleted.

      Log file of ICManager created in current directory is not giving clues...
        • 1. Re: Message can't be deleted using ICManager
          159563
          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.
          • 2. Re: Message can't be deleted using ICManager
            Babu George-Oracle
            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.)

            Babu
            • 3. Re: Message can't be deleted using ICManager
              34849
              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.

              Arjan

              Message was edited by:
              loermans
              • 4. Re: Message can't be deleted using ICManager
                452012
                Hello All,

                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.

                regards
                larry