Removing Pending Messages…

[Tom Gilbert]

How do you deleteing pending messages? and where are they stored?  You can see the number of pending messages in the status screen when looking at the status report for a specific thread…

Topic

[Kirby Knight]

I believe this is what you are looking for.

“hcidbdump -r -U userName -f sourceThread -D

Ex. hcidbdump -r -U max -f bni01ms4_in -D

“

https://usspvlclovertch2.infor.com/viewtopic.php?t=3389&highlight=pending+messages

[Tom Gilbert]

I tried this and it did not work…  Did not remove the pending message…

[Tom Gilbert]

i typed the following:

hcidbdump -r -U tgilbert -f fr_prm_orm -D

I got the following:

Done.  No messages found to delete.

There is one message in pending on this thread…

Thanks…

[David Barr]

Forget the “-U” parameter. Cloverleaf uses the same user for all messages in the recovery database.

[Tom Gilbert]

That did work…

Here is a screen shot…

[/img]

[Tom Gilbert]

Sorry meant to say that did not work…

[David Barr]

You probably have a message in state 14 (sent but not acknowledged). Try using “hcidbdump -r -s 14”.

[Calvin Palmer]

Hey guys,

Don’t forget you have to bounce the thread in question to get those messages out of memory after you’ve deleted them out of the database. I would keep the -U so that you don’t “tie up” the default database user.

[Michael Hertel]

You want to use destination, not source.

hcidbdump -r -U MIKE -d -D

Make sure the thread is down when you do this.

You can also use the ‘Database Administrator’ GUI.

[Author]

Replies