Software update point errors

[jr19]

I am having an issue with one of the device collections I created. This error has been popping up in the status messages for the software update point every 5 minutes. HK10001C doesn't even exist anymore. I deleted it a while ago (not sure exactly when). Everything seems to be running fine otherwise, but I am wondering if this is affecting other collection updates since they seem to be a little sluggish at times. Does anyone have any ideas on how to resolve this?

Severity Type Site code Date / Time System Component Message ID Description

Error Milestone HK1 11/15/2013 2:22:46 PM SCCM01.abc.int SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR 2511 Collection Evaluator failed to update the membership of collection "HK10001C". Possible cause: SQL Server problem. Solution: 1. Review the immediately preceding status messages from this component about SQL Server errors. 2. Verify that this computer can reach the SQL Server computer. 3. Verify that SQL Server services are running. 4. Verify that the site can access the site database. 5. Verify that the site database, transaction log, and tempdb are not full. If the problem persists, check the SQL Server error logs.

Error Milestone HK1 11/15/2013 2:22:45 PM SCCM01.abc.int SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR 601 Failed to execute SQL command: "exec dbo.sp_TransferMembership 'HK10001C', 0". Check messages from SQL Server.

Error Milestone HK1 11/15/2013 2:22:45 PM SCCM01.abc.int SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR 620 Microsoft SQL Server reported SQL message 547, severity 16: [23000][547][Microsoft]

[sql Server]The INSERT statement conflicted with the CHECK constraint "ClientOfferStatus_ItemKey_Partition_CK". The conflict occurred in database "CM_HK1", table "dbo.ClientOfferStatus", column 'ItemK    Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

There is also an error that shows up in colleval.log:

[Auxiliary Evaluator] Error refreshing collection, will retry momentarily [HK10001C, Error 0xb] SMS_COLLECTION_EVALUATOR 11/15/2013 2:02:45 PM 5408 (0x1520)

[jr19]

Sorry to bump but does anyone know anything about this? It seems to really be affecting the updating of my other collections.