SMS to ConfigMgr 2007 secondary child site upgrade & Mplist issue
Hi All,
During an SMS 2003 to System Center COnfiguration Manager 2007 upgrade recently I ran into the same issue described here:
http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/0d15a643-99e1-4b5f-9060-810fd89c68f4
After some investigation this seems to be “normal”. There seems to be an issue where the mplist procedure reports an error if the capabilities field for a site is empty in the database.
There are several things you can do to see whether this is the issue that is impacting you:
If you are seeing symptoms where the mplist url fails, whereas mplist1 and mpcert work fine, than this is a pretty strong indicator you are suffering from the above issue.
There are a several queries you can execute against the SMS database to confirm your suspicionn, if any of the below queries show an empty capabilities field for a ConfigMgr site than your suspicion is confirmed :
- exec mp_getmplistforsite 'sitecode'
- Select * from sites
- exec mp_getlistofmpsinsite 'sitecode','0'
Result of this issue is that the mpcontrol.log will start spewing out errors as the mp uses the mplist url for its health check. All other functions of the mp seem to be operations, so inventory, software distribution, etc… seem not to be impacted.
There seems to be one situation where this always occurs, namely during in-place upgrades of secondary child sites. From the minute you start the upgrade until the upgrade successfully finishes mplist for all mp’s attached to the same primary site will fail.
The reason I uncovered this error is that one of the secondary site upgrades failed because of lack of diskspace, and hence the period in which the mplist url was unavailable was severely increased. Once the secondary site upgrade issue was fixed, the mplist url returned back to full working order without any other intervention.
--
Enjoy.
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.scug.be/blogs/sccm/default.aspx
http://www.linkedin.com/in/kimoppalfens