Tips deleting mail from MCR_UCS (Mail loop incident)

[tovare]

Hi,

I accidentally created an autoreply mail-loop, which was undetected over night causing the MCR_UCS and interaction queues to be[b] filled with tens of thousands of emails [/b](With the same title + email).

I tried using the supervisor desktop, but it fails, so i think maybe i need a more powerfull approach.

I am also unable to use the pruning tool supplied, because I need to keep all other interactions intact.

I also tried looking at the databasestructure, but I don't understand it well enough to delete there without quite specific advice first.

MCR_UniversalContactServer version 7.2.000.12 on Microsoft SQL.

Please advice.

Thank you!

Tov Are Jacobsen

[René]

Hi,

GDesktop isn't very helpful in situation when you need to process several thousands of interactions. The easiest way how to get rid of duplicated interactions will be modification of the strategy attached to particular interaction queue. Add these steps to your strategy:

1. Read subject and from address - these are stored as AttachedData, keys 'From' And 'Subject'
2. If the values match to values of duplicated email then delete the interaction using "Stop Interaction" object (check the object's option 'Delete').
3. If the values doesn't match then continues with your standard strategy

Be aware that deleting so many interactions will increase load of SQL Server. I do recommend you to run that "action" during non-peak hours.

René