Case, old collections do not refresh when adding or removing objects to the collection. New collections are updated, it just takes a long time. Looking in the colleval.log file there was a lot of errors like this:

*** exec dbo.sp_TransferMembership ‘PS100014’, 0    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)
*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "ClientOfferStatus_ItemKey_Partition_CK". The conflict occurred in database "CM_PS1", table "dbo.ClientOfferStatus", column ‘ItemKey’. : CollectionMembers_ins_upd_del    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)
CCollectionSource_SQL::RefreshResults – could not execute SQL cmd exec dbo.sp_TransferMembership ‘PS100014’, 0    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)
STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR" SYS=Alkapcm001NEW.alkait.net SITE=PS1 PID=5644 TID=7392 GMTDATE=ma jun 02 21:14:36.129 2014 ISTR0="exec dbo.sp_TransferMembership ‘PS100014’, 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)
[Auxiliary Evaluator] Error refreshing collection, will retry momentarily [PS100014, Error 0xb]    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)
STATMSG: ID=2511 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR" SYS=Alkapcm001NEW.alkait.net SITE=PS1 PID=5644 TID=7392 GMTDATE=ma jun 02 21:14:36.136 2014 ISTR0="PS100014" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=402 AVAL0="PS100014"    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0)

Looking at the error message, you will see useful information like the collection id and a conflict. It turned out that “someone” added a reference to the x64 Unknown computer account and that rule was the causing all the issues.

image

After removing the object from the collection, the collection evaluator begun processing all the other collection changes that had been queuing up for weeks,

image