Suspended Messages

[Steve Roselius]

Due to testing, I have literally tens of thousands of suspended
messages that I would like to delete.

It appears from the EMP I can only delete 100 at a time.

I thought that if I could find out the name of the database where
these messages are being stored, I could just delete them there and it
would be faster. I.e. DELETE * FROM Ens.SuspendedMsgs or whatever.

Does anybody know where these messages are? Thanks in advance

Steve

[James MacKeith]

Hi Steve

Using SQL you can mark them all as discarded using the logical values:

Update Ens.MessageHeader Set Status=4 where Status=5

See Ens.DataType.MessageStatus for Display/Logical value pairs

Now since a test system you can avoid changing their status by purging with Keep data integrity off and this will delete the suspended messages.

Regards

James

Steve

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com
To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en