SMS_COLL_EVAL problem after Site Restore

[Eduardo Santos]

Hi,

 

I've restored an SCCM 2007 sp2 R2 site for hardware migration in lab invironment without internet connectio. The old config was a 2k3 server with Sql 2005 and I've migrated to a Virtual ESXi 2k8 r2 server again with SQL 2005. We have a Central Site and a child site, both primary in diferent AD's.

 

I've restored the primary site only on the new machine, and all the process went smooth without errors. In the end I did the site reinicialization and again all without errors. I've rebooted the server and after I started checking for errors, and I found that the SMS_COLLECTION_EVALUATOR coldn't refresh collection as shown in the log below:

 

Checking collection: 0x1BD, EvaluationCRCChanged=FALSE, ScheduleCRCChanged=FALSE, AwaitingRefresh=FALSE SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Due date for collection S01001B1 is 06/28/11 17:10:00 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Preparing to refresh collection S01001B1 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

Refreshing results for collection S01001B1 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

CCollectionSource_SQL::RefreshResults - could not get collection SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

STATMSG: ID=2521 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=WINSCCM01 SITE=S01 PID=1340 TID=2652 GMTDATE=ven. juil. 08 09:39:05.893 2011 ISTR0="S01001B1" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Could not refresh collection S01001B1. Will retry later. SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

Checking collection: 0x1CF, EvaluationCRCChanged=FALSE, ScheduleCRCChanged=TRUE, AwaitingRefresh=FALSE SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Due date for collection S01001C3 is 07/07/11 15:48:00 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Preparing to refresh collection S01001C3 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

Refreshing results for collection S01001C3 SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Succeeded in refreshing collection S01001C3. SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Finished checking collections due for evaluation. SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

COLLEVALTHREAD- Succeeded in monitor collections. Will monitor again in 0 minutes SMS_COLLECTION_EVALUATOR 08/07/2011 11:39:05 2652 (0x0A5C)

I also have a problem with the Discovery Data Manager that says that it cannot refresh registry keys. I've added the machine account with full control to the registry.

 

Refreshing site settings..... SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 15, Discovery Data Manager SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 37, Discovery Data Manager (Trusted) SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 47, Discovery Data Manager (Registration) SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 14, Discovery Asst Rules SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 51, Discovery Data Manager (Notification) SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 9, Data Loader SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 10, Software Inventory Processor (Site) SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

Updated inbox def 21, Client Configuration Record (Incoming) SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

DDM is configured to synchronize the network config data (NCF) files at startup and every 15 minutes thereafter. SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

CDiscoverDataManager::GetSiteStatus - Registering SQL types, Server = WINSCCM01, Database = SCCM_S01, User = SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:06 2444 (0x098C)

CDiscoverDataManager::GetSiteInfo - Could not get subsites. SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:07 2444 (0x098C)

STATMSG: ID=679 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_DISCOVERY_DATA_MANAGER" SYS=WINSCCM01 SITE=S01 PID=1340 TID=2444 GMTDATE=ven. juil. 08 09:39:07.096 2011 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:07 2444 (0x098C)

CDiscoverDataManager::Process - Could not refresh registry values. Sleeping for 60 seconds SMS_DISCOVERY_DATA_MANAGER 08/07/2011 11:39:07 2444 (0x098C)

 

When I make a query it gives the results I request, but when I make a new collection it returns no results. The system collections all work fine, and all the costum collections are emptyç. It allows me to create new objects (new querys, new collections, etc..).

 

I'm really stuck and I would apreciate some help. Thank you in advance.

 

Best regards,

 

Eduardo

[Eduardo Santos]

Hi everybody,

 

I've not found the solution but I've found the workaround! At the end of the restore and site reinicialization, I've reinstalled the SP2 and everything became OK.

 

The SP2 reinstalled all the services and rebuild all the connections and the SCCM is now working at 100%.

 

Thanks for your help!

 

Eduardo