Hello, Collections dosen't show up, could not see any. I have full rights on SCCM. Server: Windows 2008 R2 / SCCM 2007 R3 / SQL 2008 R2 Database has restored from backup. Here are few rows from Colleval.log COLLEVALTHREAD- Due date for collection S0100056 is 11/24/10 14:58:00 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:55.965 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Preparing to refresh collection S0100056 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:55.965 2010 FLE Standard Time><thread=6588 (0x19BC)> Refreshing results for collection S0100056 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:55.965 2010 FLE Standard Time><thread=6588 (0x19BC)> *** exec sp_TransferMembership 'S0100056', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> *** [42000][8144][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function sp_TransferMembership has too many arguments specified. : sp_TransferMembership $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> CCollectionSource_SQL::RefreshResults - could not execute SQL cmd exec sp_TransferMembership 'S0100056', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=SFISMS1 SITE=S01 PID=5276 TID=6588 GMTDATE=pe marras 26 08:57:57.057 2010 ISTR0="exec sp_TransferMembership 'S0100056', 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Could not refresh collection S0100056. Will retry later. $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> Checking collection: 0x65, EvaluationCRCChanged=FALSE, ScheduleCRCChanged=FALSE, AwaitingRefresh=FALSE $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Due date for collection S0100057 is 11/24/10 14:50:00 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Preparing to refresh collection S0100057 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> Refreshing results for collection S0100057 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:57.057 2010 FLE Standard Time><thread=6588 (0x19BC)> *** exec sp_TransferMembership 'S0100057', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> *** [42000][8144][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function sp_TransferMembership has too many arguments specified. : sp_TransferMembership $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> CCollectionSource_SQL::RefreshResults - could not execute SQL cmd exec sp_TransferMembership 'S0100057', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=SFISMS1 SITE=S01 PID=5276 TID=6588 GMTDATE=pe marras 26 08:57:58.133 2010 ISTR0="exec sp_TransferMembership 'S0100057', 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Could not refresh collection S0100057. Will retry later. $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> Checking collection: 0x66, EvaluationCRCChanged=FALSE, ScheduleCRCChanged=FALSE, AwaitingRefresh=FALSE $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Due date for collection S0100058 is 11/24/10 14:58:00 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Preparing to refresh collection S0100058 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> Refreshing results for collection S0100058 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:58.133 2010 FLE Standard Time><thread=6588 (0x19BC)> *** exec sp_TransferMembership 'S0100058', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> *** [42000][8144][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function sp_TransferMembership has too many arguments specified. : sp_TransferMembership $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> CCollectionSource_SQL::RefreshResults - could not execute SQL cmd exec sp_TransferMembership 'S0100058', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=SFISMS1 SITE=S01 PID=5276 TID=6588 GMTDATE=pe marras 26 08:57:59.226 2010 ISTR0="exec sp_TransferMembership 'S0100058', 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Could not refresh collection S0100058. Will retry later. $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> Checking collection: 0x67, EvaluationCRCChanged=FALSE, ScheduleCRCChanged=FALSE, AwaitingRefresh=FALSE $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Due date for collection S0100059 is 11/25/10 11:21:00 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Preparing to refresh collection S0100059 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> Refreshing results for collection S0100059 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.226 2010 FLE Standard Time><thread=6588 (0x19BC)> *** exec sp_TransferMembership 'S0100059', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.304 2010 FLE Standard Time><thread=6588 (0x19BC)> *** [42000][8144][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function sp_TransferMembership has too many arguments specified. : sp_TransferMembership $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.304 2010 FLE Standard Time><thread=6588 (0x19BC)> CCollectionSource_SQL::RefreshResults - could not execute SQL cmd exec sp_TransferMembership 'S0100059', 0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.304 2010 FLE Standard Time><thread=6588 (0x19BC)> STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=SFISMS1 SITE=S01 PID=5276 TID=6588 GMTDATE=pe marras 26 08:57:59.304 2010 ISTR0="exec sp_TransferMembership 'S0100059', 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.304 2010 FLE Standard Time><thread=6588 (0x19BC)> COLLEVALTHREAD- Could not refresh collection S0100059. Will retry later. $$<SMS_COLLECTION_EVALUATOR><pe marras 26 10:57:59.304 2010 FLE Standard Time><thread=6588 (0x19BC)> Cheers, Mika

Database has restored from backup. Did you use ConfigMgr's restore mechanism or did you just restore a SQL backup? It would not be supported to just restore the SQL database. If you used the ConfigMgr restore: did you run a site reset after it?

Yes, restored with ConfigMgr repair wizard and after that I run site reset. All other seems to be ok, but only collection dosen't show up. I can read and write everywhere else. If I click Collections icon and run Export, I can see there all those collections. If I go forward with Export, it goes error and can not Export collections. I also try to create new collection, but can't. Mika

Hi, 1# That problem is also apprear on a remote console ? 2# Is the .Net 4.0 installed on the ConfigMgr server ? If so, try to remove it and reboot the server ? Otherwise if you use .Net 3.5, so make sure that all related last hotfixs are installed. 3# If 2# doesn't solve the problem, so reapply the SP2 of ConfigMgr, collections will get recreate with the right IDs. 4# Also, you can verify with your DBA that SQL DDL audit is not enabled. Bechir Gharbi | http://myitforum.com/cs2/blogs/bgharbi/default.aspx

Hi, I will reapply also R3 cause collection evaluation process change in R3 with dynamic collections updating, and the error message in log file seems related to. Julien

What was the reason for the restore? Could be related problem? Also re-applying a service pack sometimes helps as well.Follow me through my blog and Twitter!

Still working on it, but 'sp_TransferMembership' prosedure is different than new installation. So I try to change that on test environment and check if it help. Mika Mika

Bechir Gharbi: No, we don't have .net 4 installed Jannes Alink: We change server. We have renamed new one with old name + IP etc. Those all are ok. Everything else seems to be ok, but collections dosen't show up. If I try to export Collections, I can see those on grid, but when I go forward it gives error and export is halted.Mika

Re-apply the SP2 of ConfigMgr.Bechir Gharbi | http://myitforum.com/cs2/blogs/bgharbi/default.aspx

Forget to answer this - this help us out with this prob. Thanks!Mika