Device Collections Not Updating

[Orzel]

Hi,

 

I have noticed the recently my All Systems Collection has has the hour glass on it for days and does not seem to update. I then created a new collection and that also has the hour glass and does not update. It has been this way for a few days..

 

What can I check to fix this?

 

 

Thanks,

 

[Orzel]

Looked at the colleval.log. Is this part of the Device Collections not updating problem or is this something new?? Currently I am just trying to get the deployment of Win7 setup in SCCM 2012

 

CSiteSettings::GetCurrentSiteCode: Failed to get SQL connection $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:08:05.512-660><thread=3000 (0xBB8)>
GetComponent: Failed to get current site code $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:08:05.512-660><thread=3000 (0xBB8)>
CCollectionEvaluator::ReadIncrementalSettingFromSCF - Failed to get Site Control component data $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:08:05.512-660><thread=3000 (0xBB8)>
Waiting for changes for 1 minutes $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:08:05.513-660><thread=3000 (0xBB8)>
Wait timed out after 1 minutes while waiting for at least one trigger event. $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:09:05.510-660><thread=3000 (0xBB8)>
Component Cycle triggered $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:09:10.510-660><thread=3000 (0xBB8)>
Incremental Cycle triggered $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:09:10.510-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft]

TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:14:10.651-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:14:10.651-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:14:10.651-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:14:10.652-660><thread=3000 (0xBB8)>
Unable to sync collections.  Will retry on next processing cycle.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:14:10.652-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:19:11.635-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:19:11.635-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:19:11.636-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:19:11.636-660><thread=3000 (0xBB8)>
~Could not get a SQL connection in ManageFile.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:19:11.636-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.612-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.612-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.612-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.613-660><thread=3000 (0xBB8)>
CEP-ErrorCode=-1  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.614-660><thread=3000 (0xBB8)>
~CEP-Failed to process Collection Extended Properties changes, Status = SQL ERROR, changes will be retried on next processing cycle.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:24:12.614-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:29:13.612-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:29:13.612-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:29:13.612-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:29:13.613-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.590-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.590-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.590-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.591-660><thread=3000 (0xBB8)>
Info: Currently Site HCF is initializing Site Control Data. Can't get Master SCF from database at this time. Will try later.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.591-660><thread=3000 (0xBB8)>
STATMSG: ID=2548 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=FERRARI.hcf.local SITE=HCF PID=5380 TID=3000 GMTDATE=Sat Jan 26 10:24:12.614 2013 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:34:14.591-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it.~~  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:39:14.738-660><thread=3000 (0xBB8)>
*** [HYT00][0][Microsoft][sql Server Native Client 10.0]Login timeout expired  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:39:14.738-660><thread=3000 (0xBB8)>
*** [08001][10061][Microsoft][sql Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:39:14.738-660><thread=3000 (0xBB8)>
*** Failed to connect to the SQL Server.  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:39:14.739-660><thread=3000 (0xBB8)>
CCollectionScheduler::ProcessIncremental - Error retrieving SQL connection  $$<SMS_COLLECTION_EVALUATOR><01-26-2013 21:39:14.739-660><thread=3000 (0xBB8)>

[GarthMJ]

So it clear from the logs that you are having a SQL issue.

[Orzel]

So the SQL issue would be related to Devices Collection not loading? I am pretty sure that I have had these errors since I first started cause I didnt complete the Software Distribution or something like that. I want to focus on one thing at the moment and its getting the Windows Deployment. Also as per the logs there has been no new entries since the 26th Jan. Today it is the 7th Feb..

 

What is the standard troubleshooting process for Device Collections not populating and just sitting stuck with the hourglass for days?

[GarthMJ]

That is not normal.

I'm working on a new site tonight. Here is what a normal Colleval.log should look like. I have looked a 3 CM12 sites that I currently have access to none of them have the SQL errors listed it the log.

 

Wait timed out after 5 minutes while waiting for at least one trigger event. SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:47 PM 2192 (0x0890)
PF: ***** Evaluation cycle starts ***** SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:52 PM 2192 (0x0890)
PF: Triggered by WAIT_TIMEOUT SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:52 PM 2192 (0x0890)
PF: Incremental cycle triggered SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:52 PM 2192 (0x0890)
PF: Processing of file extensions starts SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: 0 file extensions to process SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: 0 collections CRC modified SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: 0 collections deleted SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: Processing of file extensions ends SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: Collection process starts SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: Looking for candidates for incremental evaluation SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
Querying for incremental changes SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: Found 0 candidate collection for incremental evaluation SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
Checking for collections needing their extended user membership updated. SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
0 collections need their extended user membership updated. SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: Collection process exits since no change to process SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
PF: ***** Evaluation cycle ends ***** SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)
Waiting for changes for 5 minutes SMS_COLLECTION_EVALUATOR 2/6/2013 10:32:53 PM 2192 (0x0890)

[Orzel]

That is not normal.

You were right. I eventually found the issue regarding SQL here. Issue occurred cause I moved the SQL Server from its VLAN part way through my SCCM configurations and to another VLAN. This then broke it.

 

I have put it back now and the logs are populating and working! Thanks Garth!

 

The whole served seemed to freeze up and ALL the Device Collections have populated too! FINALLY! :)