Clovertech

remove or delete queued in/outbound message

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › remove or delete queued in/outbound message

  • Creator
    Topic
  • June 25, 2007 at 2:04 pm #49366
    Hongle Sun
    Participant

      Is there any way to get rid of those queued inbound or outbound message in engine, we dont want those messages to be sent in or out? Thanks

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • June 25, 2007 at 5:24 pm #61660
        John Hamilton
        Participant

          That depends on a lot of things.  

          But I would try hcidbdump -r -D include the selection criteria.  But again depending on what is running and if you are running the recovery DB will all determine the best way to remove those messages.

          Plus if this is a one time thing or something you want to run continuously.

          We need more details to give you the proper answer.

        • June 29, 2007 at 1:46 pm #61661
          Hongle Sun
          Participant

            Thanks john

            The reason that I was asking is, we come across suituations, like, while  doing test for one sub system which require adt or oder hl7 messages, those message will queue in outbound threads which are in off status, so we would like to get rid of those queued msg before those threads turn on…

          • July 2, 2007 at 2:40 pm #61662
            Jared Miller
            Participant

              In our test system I have the recovery DB turned off so if I simply stop and restart the thread all the queued up messages are removed.

            • July 3, 2007 at 9:04 am #61663
              Robert Kersemakers
              Participant

                When these accumulated recovery messages really start to annoy me, I put an ‘hcitpsmsgkill’ in the TPS Outbound of these threads. The messages will be killed and won’t show up in the recovery database.

                Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

              • July 4, 2007 at 2:31 am #61664
                Richard Hart
                Participant

                  When deleteing messages from the database, its best to stop the threads linked to the message.

                  Useful switches for selecting the correct message are:

                   -d dest      = select messages with specified destination

                   -f source    = select messages with specified source

                  Note that a resend on an outbound thread will have that thread as the source!

                  When we were on a less poweful server (Unix) I ran a script once a week in test that deleted queued messages older than one week. This was about 6 years ago and I can’t find the script now (we’ve upgraded hardware twice!)

                  A useful trick (on Unix) for getting dates for a few days ago is to use the timezone

                  eg

                  [5.4] he00387> echo “Now ” `TZ=0; date`      

                  Now  Wed Jul 4 03:32:16 2007

                  [5.4] he00387> echo “and then ” `TZ=+48;date`

                  and then  Mon Jul 2 03:32:22 2007

              • Author
                Replies
              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.