remove or delete queued in/outbound message

[Hongle Sun]

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

Topic

[John Hamilton]

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.

[Hongle Sun]

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…

[Jared Miller]

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.

[Robert Kersemakers]

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

[Richard Hart]

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