IM&P 9.1 Watchers CSCup37413

[kmdurrett]

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCup37413 (IM&P doesn't remove AD/CUCM deleted users from Rosters)

Following the work around with the following query

run sql select contact_jid from rosters r where NOT EXISTS (select * from users u where u.jid = r.contact_jid)

results in 30000+ results. 

running the next query in the work around

run sql delete from rosters where contact_jid NOT IN (select jid from users)

and IM&P returns the following error:  "Memory allocation failed during query processing."

I performed this same work around an another cluster but there was a significant difference in the results (<100) with no problem.  Is there another query I can perform to select a smaller subset from the results in the initial query.  Keep in mind, these watchers are no longer in IM&P and they have no jid.  Thanks.

Kurtis

[kmdurrett]

with 30000+ results and 1200+ unique entries I was able to delete some of the unique entries using

run sql delete from rosters where contact_jid = 'yourcontact@yourdomain.org'

once the number of entries was below 23000, I was able to successfully delete the remaining entries with no errors using:

run sql delete from rosters where contact_jid NOT IN (select jid from users)