Device Collection Not Working

[nocode]

I'm trying to add devices to a new Device collection. I'm doing something simple like a Direct rule to a single machine. The Device Collection has an hour glass next to it and the Update Time is 1/1/1980 12:00 AM. When I look at the colleval.log, I see this

CCollectionSource_SQL::RefreshResults - could not get collection

The Colleval.box has 6 files but they're all 0 kb. The log shows that it's processing the files but the collection was "not found" (probably due to the 0 KB file)

I've tried restarting the sms_executive service, rebooted the SCCM server and also restarted the SQL service.

Any ideas?

[nocode]

Here's a sample of the log and this is happening before, in between, and after I removed my Device Collection

 

PF: [Express Evaluator] starts to evaluate collection [sMS00001] $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.492+240><thread=4724 (0x1274)>

PF: Incrementally refreshing collection SMS00001 $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.536+240><thread=4724 (0x1274)>

CCollectionSource_SQL::RefreshResults - could not get collection $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.556+240><thread=4724 (0x1274)>

STATMSG: ID=2521 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_EXPRESS_EVALUATOR" SYS=DOMAINSCCM01.DOMAIN.private SITE=DOMAIN PID=2408 TID=4724 GMTDATE=Thu Jun 05 21:10:06.557 2014 ISTR0="SMS00001" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.557+240><thread=4724 (0x1274)>

[Express Evaluator] Error refreshing collection, will retry momentarily [sMS00001, Error 0xa] $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.558+240><thread=4724 (0x1274)>

STATMSG: ID=2511 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_EXPRESS_EVALUATOR" SYS=DOMAINSCCM01.DOMAIN.private SITE=DOMAIN PID=2408 TID=4724 GMTDATE=Thu Jun 05 21:10:06.559 2014 ISTR0="SMS00001" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=402 AVAL0="SMS00001" $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.559+240><thread=4724 (0x1274)>

[Express Evaluator] Waiting for recovery [5 minutes] $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:10:06.560+240><thread=4724 (0x1274)>

Wait timed out after 5 minutes while waiting for at least one trigger event. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:39.987+240><thread=3920 (0xF50)>

PF: ***** Evaluation cycle starts ***** $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:44.987+240><thread=3920 (0xF50)>

PF: Triggered by WAIT_TIMEOUT $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:44.987+240><thread=3920 (0xF50)>

PF: Incremental cycle triggered $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:44.987+240><thread=3920 (0xF50)>

PF: Processing of file extensions starts $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.001+240><thread=3920 (0xF50)>

PF: 6 file extensions to process $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.046+240><thread=3920 (0xF50)>

Processing file DOMAIN0000A.ADC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.047+240><thread=3920 (0xF50)>

Collection DOMAIN0000A not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.051+240><thread=3920 (0xF50)>

Processing file DOMAIN0000A.UDC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.052+240><thread=3920 (0xF50)>

Collection DOMAIN0000A not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.056+240><thread=3920 (0xF50)>

Processing file DOMAIN0000B.ADC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.057+240><thread=3920 (0xF50)>

Collection DOMAIN0000B not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.061+240><thread=3920 (0xF50)>

Processing file DOMAIN0000B.UDC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.061+240><thread=3920 (0xF50)>

Collection DOMAIN0000B not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.065+240><thread=3920 (0xF50)>

Processing file DOMAIN0000C.ADC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.066+240><thread=3920 (0xF50)>

Collection DOMAIN0000C not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.070+240><thread=3920 (0xF50)>

Processing file DOMAIN0000C.UDC_ $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.070+240><thread=3920 (0xF50)>

Collection DOMAIN0000C not found. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.074+240><thread=3920 (0xF50)>

PF: 0 collections CRC modified $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.074+240><thread=3920 (0xF50)>

PF: 0 collections deleted $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.075+240><thread=3920 (0xF50)>

PF: Processing of file extensions ends $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.075+240><thread=3920 (0xF50)>

Failed to manage all files in inbox. Will retry on next processing cycle. $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.076+240><thread=3920 (0xF50)>

PF: Collection process starts $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.076+240><thread=3920 (0xF50)>

PF: Looking for candidates for incremental evaluation $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.078+240><thread=3920 (0xF50)>

PF: Incremental evaluation cycle skipped since not in IncrementalEvaluation_Waiting state $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.078+240><thread=3920 (0xF50)>

PF: Collection process exits since no change to process $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.078+240><thread=3920 (0xF50)>

PF: ***** Evaluation cycle ends ***** $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.079+240><thread=3920 (0xF50)>

Waiting for changes for 5 minutes $$<SMS_COLLECTION_EVALUATOR><06-05-2014 17:12:46.103+240><thread=3920 (0xF50)>