none
SCСM: проблемы с доступом к SQL и реестру RRS feed

  • Вопрос

  • В один момент времени, скорее всего после получения обновлений на сервер, на SCCM появились ошибки, связанные с доступом к SQL и реестру.

    SCCM верия 4.00.6487.2000, Windows Server 2008 R2 SP1, MS SQL 2008 R2

     

    Ошибки:

    ID 2521 SMS_COLLECTION_EVALUATOR SMS Collection Evaluator failed to retrieve collection "xxxxxxxxx" from the collection source.

    ID: 679 SMS_DISCOVERY_DATA_MANAGER This component failed to retrieve the list of SMS sites from the site database.

    ID: 3304 SMS_HIERARCHY_MANAGER  SMS Hierarchy Manager cannot save site information to the SMS site database for site "xxx"

    ID: 5600 SMS Software Metering Processor failed to read and configure the registry keys necessary for this component.

     

    Подскажите, как лечить? Reset site делал, не помогло.


    • Изменено Vitaly68 14 декабря 2011 г. 7:06
    14 декабря 2011 г. 6:56

Ответы

Все ответы

  • Переустановить SP2.
    14 декабря 2011 г. 7:22
  • Не ставится.

    На стадии проверки ругается на Site control file processing backlog (To ensure that data is not lost during the upgrade process, site control file changes should be being processed in a timely fashion. If this test does not pass, it could indicate that a component has stopped, has stopped processing data, or is unable to keep up with incoming traffic).

    Здесь http://social.technet.microsoft.com/Forums/ru-RU/smsru/thread/2dfa1aa4-db0b-4eb9-884b-51076549fb5b человек решил траблу отключением сервера от сети. Мне не помогло.

    Плюс два предупреждения: Client Duplicate IDs и Software distribution package hash.

     

    14 декабря 2011 г. 9:06
  • Если использовать параметр /noprereq при установке, то инсталляция завершается ошибкой на стадии "Создание и инициализация базы данных сайта".
    14 декабря 2011 г. 9:16
  • Руками базу через Management Studio не трогали?

    14 декабря 2011 г. 9:17
    Отвечающий
  • Не трогали.
    14 декабря 2011 г. 9:53
  • а лог установки SP2 что пишет?

    14 декабря 2011 г. 11:09
    Отвечающий
  • Путь и название лога не подскажите?
    14 декабря 2011 г. 11:54
  • C:\ConfigMgrSetup.log
    14 декабря 2011 г. 12:02
    Отвечающий
  • После скачивания и проверки файлов обновления в логах только это:

    <12-14-2011 13:26:11> Processing file group "ConfigMgr Client Manifest"
    <12-14-2011 13:26:11> Processing file "ccmsetup.cab"
    <12-14-2011 13:26:11> File will be downloaded from http://download.microsoft.com/download/E/9/D/E9D843B7-8F1C-4C27-9328-6205B557730F/ccmsetup.cab.
    <12-14-2011 13:26:11> File for ccmsetup.cab [ConfigMgr Client Manifest] will be copied with file name: ccmsetup.cab.
    <12-14-2011 13:26:11> Prerequisite checking will run as part of the setup.
    <12-14-2011 13:26:11> Running test query.
    <12-14-2011 13:26:11> Sql version is 10.50, 10.50.2500.0.
    <12-14-2011 13:26:11> The size of the existing ConfigMgr or SMS database is 6.8 gigabytes. Setup may take some time to upgrade the database.
    <12-14-2011 13:26:13> Starting evaluation process.
    <12-14-2011 13:26:13> Entry: KillUserApps()
    <12-14-2011 13:26:13> Exiting Kill User apps
    <12-14-2011 13:26:13> This is not cluster SQL.
    <12-14-2011 13:26:13> The prereq rules for primary site upgrade are being run.
    <12-14-2011 13:26:13> Verifying SMS Active Directory Schema Extensions.
    <12-14-2011 13:26:13> DS Root:CN=Schema,CN=Configuration,DC=polynet
    <12-14-2011 13:26:13> NtfsDisable8dot3NameCreation is set to 0.
    <12-14-2011 13:26:13> Success in GetMMCVersion. Version is 3.0.
    <12-14-2011 13:26:13> .NET Framework Version: 50727
    <12-14-2011 13:26:16> IsValidFQDN validation of 'SRV-SCCM.POLYNET' succeeded
    <12-14-2011 13:26:26> NtfsDisable8dot3NameCreation is set to 0.
    <12-14-2011 13:26:26> Sql version is 10.50, 10.50.2500.0.
    <12-14-2011 13:26:26> NtfsDisable8dot3NameCreation is set to 0.

    14 декабря 2011 г. 12:27
  • После неудачной попытки установки SP2, консоль не подключается к сайту.

    14 декабря 2011 г. 12:37
  • а в prerequisitechecker?
    14 декабря 2011 г. 12:37
    Отвечающий
  • После неудачной попытки установки SP2, консоль не подключается к сайту.

    Не в тему, НО  Вы перед обновлением бэкап то сделали?

    А по теме проверьте  sitectrl.log есть ли там какие-нибудь ошибки?

     

    14 декабря 2011 г. 12:46
    Отвечающий
  • <12-14-2011 13:25:39> ******* Start Prerequisite checking. *******
    <12-14-2011 13:25:39> ********************************************
    <12-14-2011 13:26:13> Executing prereq functions...
    <12-14-2011 13:26:13> <<<RuleCategory: Access Permissions>>>
    <12-14-2011 13:26:13> <<<CategoryDesc: Checking access permissions...>>>
    <12-14-2011 13:26:13> SRV-SCCM;    Administrative rights on site system;    Passed
    <12-14-2011 13:26:13> <<<RuleCategory: System Requirements>>>
    <12-14-2011 13:26:13> <<<CategoryDesc: Checking system requirements for ConfigMgr...>>>
    <12-14-2011 13:26:13> SRV-SCCM;    Unsupported site server operating system version for setup;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Domain membership;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Schema extensions;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB911897;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB912818;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB913538;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB914389;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB925903;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Software updates KB932303;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    FAT Drive on Site Server;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Short File Name (8.3) Support (Site system);    Passed
    <12-14-2011 13:26:13> <<<RuleCategory: Dependent Components>>>
    <12-14-2011 13:26:13> <<<CategoryDesc: Checking dependent components for ConfigMgr...>>>
    <12-14-2011 13:26:13> SRV-SCCM;    Microsoft Management Console (MMC) version;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Minimum .NET Framework version;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Microsoft XML Core Services 6.0 (MSXML60);    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    WSUS SDK on site server;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    WSUS 3.0 SP1 is required on site server;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Windows Server 2003-based schannel hotfix;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Windows Remote Management (WinRM) v1.1;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    Microsoft Remote Differential Compression (RDC) library registered;    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    MMC updates for Configuration Manager (Software Updates);    Passed
    <12-14-2011 13:26:13> SRV-SCCM;    .NET update for Configuration Manager (Software Updates);    Passed
    <12-14-2011 13:26:13> <<<RuleCategory: Site Upgrade Requirements>>>
    <12-14-2011 13:26:13> <<<CategoryDesc: Checking if the target ConfigMgr site is ready to upgrade...>>>
    <12-14-2011 13:26:14> SRV-SCCM;    Unsupported client operating system version;    Passed
    <12-14-2011 13:26:15> SRV-SCCM;    Pre-SMS 2003 SP2 direct child sites;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    Pre-SMS 2003 SP2 indirect child sites;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    Secure key exchange;    Passed
    <12-14-2011 13:26:16> Connecting to registry on site system [\\SRV-SCCM], site code [077]
    <12-14-2011 13:26:16> Connected to registry on site system [\\SRV-SCCM], site code [077]
    <12-14-2011 13:26:16> ---> System OS version string "6.1" converted to 6.10
    <12-14-2011 13:26:16> Warning: Could not open registry value CSDVersion on site system [\\SRV-SCCM], site code [077]
    <12-14-2011 13:26:16> SRV-SCCM;    Unsupported site server operating system version for upgrade;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    FQDN specified for site systems;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    Site security mode;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    Management Point NLB Configuration;    Passed
    <12-14-2011 13:26:16> SRV-SCCM;    Backlogged inboxes;    Passed
    <12-14-2011 13:26:16> There are 12 unprocessed site control files.
    <12-14-2011 13:26:16> SRV-SCCM;    Site control file processing backlog;    Error;    To ensure that data is not lost during the upgrade process, site control file changes should be being processed in a timely fashion. If this test does not pass, it could indicate that a component has stopped, has stopped processing data, or is unable to keep up with incoming traffic.
    <12-14-2011 13:26:17> SRV-SCCM;    Distribution point package version;    Passed
    <12-14-2011 13:26:18> SRV-SCCM;    Client activity;    Passed
    <12-14-2011 13:26:19> SRV-SCCM;    Client version;    Passed
    <12-14-2011 13:26:20> Query SELECT GSYS.Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name',  GSYS.SMSID0 AS SMS_Unique_Identifier0 FROM System_DATA GSYS JOIN System_HIST GHSYS ON GSYS.MachineID = GHSYS.MachineID JOIN System_SMS_Instal_ARR site ON GSYS.MachineID=site.ItemKey WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT RSYS.Resource_Domain_OR_Workgr0 as Domain0, RSYS.Name0, site.SMS_Installed_Sites0, GSYS.Domain0 AS 'Previous Domain', GSYS.Name0 AS 'Previous Name', RSYS.SMS_Unique_Identifier0 FROM System_DISC RSYS JOIN System_DATA GSYS ON RSYS.ItemKey = GSYS.MachineID JOIN System_SMS_Instal_ARR site ON RSYS.ItemKey=site.ItemKey WHERE RSYS.Name0!=GSYS.Name0  UNION SELECT RSYS.Resource_Domain_OR_Workgr0 as Domain0, RSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', RSYS.SMS_Unique_Identifier0 FROM System_DISC RSYS JOIN System_HIST GHSYS ON RSYS.ItemKey = GHSYS.MachineID JOIN System_SMS_Instal_ARR site ON RSYS.ItemKey=site.ItemKey WHERE RSYS.Name0!=GHSYS.Name0  returned one or more rows.
    <12-14-2011 13:26:20> SRV-SCCM;    Client Duplicate IDs;    Warning;    Duplicate client IDs can cause unexpected results in collection evaluation and software distribution to clients. Duplicate client IDs should be resolved before continuing the upgrade process.
    <12-14-2011 13:26:20> SRV-SCCM;    SQL Server database collation;    Passed
    <12-14-2011 13:26:21> SRV-SCCM;    Hardware inventory group map;    Passed
    <12-14-2011 13:26:22> SRV-SCCM;    Client GUID consistency;    Passed
    <12-14-2011 13:26:23> SRV-SCCM;    Class Security Rights;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    Instance Security Rights;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    Inventory Tool for Custom Updates Feature Pack;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    Inventory Tool for Dell Updates Feature Pack;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    SMS Inventory Tool for HP ProLiant and Integrity;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    IBM Systems Update Tool for Microsoft SMS;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    Operating System Deployment Feature Pack;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    SMS Device Management Feature Pack;    Passed
    <12-14-2011 13:26:24> SRV-SCCM;    SQL Server replication objects;    Passed
    <12-14-2011 13:26:24> The following packages are not properly signed:
    <12-14-2011 13:26:24> 07700042
    <12-14-2011 13:26:24> 07700043
    <12-14-2011 13:26:24> 07700044
    <12-14-2011 13:26:24> 07700045
    <12-14-2011 13:26:24> 07700046
    <12-14-2011 13:26:24> 07700047
    <12-14-2011 13:26:24> 07700048
    <12-14-2011 13:26:24> 07700049
    <12-14-2011 13:26:24> 0770004A
    <12-14-2011 13:26:24> 0770004B
    <12-14-2011 13:26:24> 0770004C
    <12-14-2011 13:26:24> 0770004D
    <12-14-2011 13:26:24> 0770004E
    <12-14-2011 13:26:24> 0770004F
    <12-14-2011 13:26:24> SRV-SCCM;    Software distribution package hash;    Warning;    Configuration Manager clients will not download and run package files that are not properly signed. If this rule does not pass, you should update distribution points that host affected package source files to create or update the package .
    <12-14-2011 13:26:25> SRV-SCCM;    Share Name in Package;    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    Share Name in Distribution Point;    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: Access Permissions>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking access permissions...>>>
    <12-14-2011 13:26:26> SRV-SCCM;    SQL Server sysadmin rights;    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    Site server computer account administrative rights;    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    SQL Server security mode;    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: System Requirements>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking system requirements for ConfigMgr...>>>
    <12-14-2011 13:26:26> SRV-SCCM;    Domain membership;    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    Short File Name (8.3) Support (Site system);    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: Dependent Components>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking dependent components for ConfigMgr...>>>
    <12-14-2011 13:26:26> SRV-SCCM;    SQL Server version;    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: Site Upgrade Requirements>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking if the target ConfigMgr site is ready to upgrade...>>>
    <12-14-2011 13:26:26> <<<RuleCategory: Access Permissions>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking access permissions...>>>
    <12-14-2011 13:26:26> SRV-SCCM;    SMS Provider Communication;    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: System Requirements>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking system requirements for ConfigMgr...>>>
    <12-14-2011 13:26:26> SRV-SCCM;    Domain membership;    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    Short File Name (8.3) Support (Site system);    Passed
    <12-14-2011 13:26:26> SRV-SCCM;    Installed version of WAIK (SMS Provider);    Passed
    <12-14-2011 13:26:26> <<<RuleCategory: Dependent Components>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking dependent components for ConfigMgr...>>>
    <12-14-2011 13:26:26> <<<RuleCategory: Site Upgrade Requirements>>>
    <12-14-2011 13:26:26> <<<CategoryDesc: Checking if the target ConfigMgr site is ready to upgrade...>>>
    <12-14-2011 13:26:26> ***************************************************
    <12-14-2011 13:26:26> ******* Prerequisite checking is completed. *******
    <12-14-2011 13:26:26> ***************************************************
    <12-14-2011 13:26:26> Updating Prerequisite checking result
    <12-14-2011 13:26:26> Connecting to SRV-SCCM registry
    <12-14-2011 13:26:26> Setting registry values
    14 декабря 2011 г. 12:47
  • http://technet.microsoft.com/ru-ru/library/bb680951.aspx
    14 декабря 2011 г. 15:27
  • Выложите sitectrl.log  давайте посмотрим на него.

    14 декабря 2011 г. 20:19
    Отвечающий
  • http://technet.microsoft.com/en-us/library/cc181241.aspx
    И, кстати, вы запускаете с привелегированными правами setup.exe?
    15 декабря 2011 г. 6:19
    Отвечающий
  • Восстановил сервер из более раннего бэкапа, еще до появления траблы.

    Спасибо всем за помощь.

    • Помечено в качестве ответа error008MVP, Editor 16 декабря 2011 г. 8:46
    16 декабря 2011 г. 8:23