none
SCCM 2012 R2 SP1 After Upgrade Clients No Certificate SMS Provider Error RRS feed

  • Question

  • Just upgraded from 2012 r2 to 2012 r2sp1

    After the upgrade any new clients arent registering. They list client certificate as "none" instead of self assigned.

    Getting this error in StatusAgent.log

     

    Registration failed with error 0x80041010    StatusAgent    6/4/2015 9:20:52 AM    4092 (0x0FFC)

    Failed to add event forwarder for CCM_EVENTFORWARDER_CONFIGURATION.INSTANCEID="SMSBRANCHDP.INSTANCE0",NAME="SMSEVENTLOGFORWARDER"    StatusAgent    6/4/2015 9:20:52 AM    4092 (0x0FFC)

     

    Also this in CcmRepair.log

    Database verification failed with result: 0x80004005 but DB: C:\WINDOWS\CCM\InventoryStore.sdf could be opened, skipping DB repair.    CcmRepair    6/4/2015 9:20:51 AM    7204 (0x1C24)

     

    ClientIDManagerStartup.log

    [RegTask] - Client registration is pending. Sending confirmation request for GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2 ...    ClientIDManagerStartup    6/4/2015 9:26:56 AM    4092 (0x0FFC)

    Also getting this in SMS_discovery_data_manager

     

    Microsoft SQL Server reported SQL message 8169, severity 16: [42000][8169][Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting from a character string to uniqueidentifier. : SMSDBMON_ClientKeyData_PfxCertsClientKeyData_Chg_upd

    SMS_providers availabilty says - "unknown"

     

    I tried to restart service in config mgr service manager and it says Error Communicating with component

    Monday, June 8, 2015 6:50 PM

Answers

  • I was having the same error on our server.  It looks like Microsoft implemented a new trigger in R2 SP1 that is causing the issue.  Using SQL Server Management Studio, I disabled the trigger and now the clients appear to be registering successfully.

    Specifically, I went into CM_PSR (our site database) -> Tables -> dbo.ClientKeyData -> Triggers, then right clicked on SMSDBMON_ClientKeyData_PfxCertsClientKeyData_Chg_upd and chose Disable.

    If you choose to do this, make sure you reenable the trigger when Microsoft releases the inevitable hotfix that actually corrects the problem...

    • Proposed as answer by Kloostec Thursday, June 11, 2015 12:01 AM
    • Marked as answer by Second Edition Thursday, June 11, 2015 12:39 PM
    Wednesday, June 10, 2015 11:03 PM

All replies

  • You tried to restart what service?

    Also note that single out of context lines formless files are greenly meaningless. Log files are about context so knowing what happened before and after an error or line of interest is important. Thus, please post the entire, unedited and relevant snippets.

    What happens with a new client install?

    Have you reviewed MP_CliReg.log on the mp?

    Is your MP healthy?


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, June 9, 2015 12:23 AM
  • Here's ClientIDManagerStartup

    Failed to open to WMI namespace '\\.\root\ccmvdi' (8007045b)    ClientIDManagerStartup    6/8/2015 12:31:53 PM    2392 (0x0958)
    [----- SHUTDOWN -----]    ClientIDManagerStartup    6/8/2015 12:31:53 PM    2392 (0x0958)
    [----- STARTUP -----]    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    Machine: *********    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    OS Version: 10.0    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    SCCM Client Version: 5.00.8239.1000    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    'RDV' Identity store does not support backup.    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    CCM Identity is in sync with Identity stores    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    Client is set to use HTTPS when available. The current state is 192.    ClientIDManagerStartup    6/8/2015 12:34:16 PM    7216 (0x1C30)
    [RegTask] - Executing registration task synchronously.    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    Read SMBIOS (encoded): 52003900540057004B0058004100    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    Evaluated SMBIOS (encoded): 52003900540057004B0058004100    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    No SMBIOS Changed    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    SMBIOS unchanged    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    SID unchanged    ClientIDManagerStartup    6/8/2015 12:34:27 PM    2988 (0x0BAC)
    HWID unchanged    ClientIDManagerStartup    6/8/2015 12:34:29 PM    2988 (0x0BAC)
    GetSystemEnclosureChassisInfo: IsFixed=TRUE, IsLaptop=TRUE    ClientIDManagerStartup    6/8/2015 12:34:30 PM    2988 (0x0BAC)
    Computed HardwareID=2:CA7F5F39E9AE10A5B8C882F141BE171324FC1EA6
        Win32_SystemEnclosure.SerialNumber=R9TWKXA
        Win32_SystemEnclosure.SMBIOSAssetTag=No Asset Information
        Win32_BaseBoard.SerialNumber=1ZPAW2A5546
        Win32_BIOS.SerialNumber=R9TWKXA
        Win32_NetworkAdapterConfiguration.MACAddress=<Not used on laptop>    ClientIDManagerStartup    6/8/2015 12:34:30 PM    2988 (0x0BAC)
    [RegTask] - Client is not registered. Sending registration request for GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2 ...    ClientIDManagerStartup    6/8/2015 12:34:30 PM    2988 (0x0BAC)
    [RegTask] - Client registration is pending. Server assigned ClientID is GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2    ClientIDManagerStartup    6/8/2015 12:34:30 PM    2988 (0x0BAC)
    [RegTask] - Sleeping for 60 seconds ...    ClientIDManagerStartup    6/8/2015 12:34:30 PM    2988 (0x0BAC)
    [RegTask] - Client registration is pending. Sending confirmation request for GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2 ...    ClientIDManagerStartup    6/8/2015 12:35:30 PM    2988 (0x0BAC)
    [RegTask] - Sleeping for 60 seconds ...    ClientIDManagerStartup    6/8/2015 12:35:31 PM    2988 (0x0BAC)
    [RegTask] - Client registration is pending. Sending confirmation request for GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2 ...    ClientIDManagerStartup    6/8/2015 12:36:31 PM    2988 (0x0BAC)
    [RegTask] - Sleeping for 120 seconds ...    ClientIDManagerStartup    6/8/2015 12:36:31 PM    2988 (0x0BAC)
    [RegTask] - Client registration is pending. Sending confirmation request for GUID:7797D0CB-AB10-46E7-ACA7-A788E6EBC4D2 ...    ClientIDManagerStartup    6/8/2015 12:38:31 PM    2988 (0x0BAC)

    Tuesday, June 9, 2015 12:22 PM
  • MP_CLIREG

    Could not load logging configuration for component MP_RegistrationManager. Using default values.    MP_ClientRegistration    6/8/2015 2:01:40 PM    7128 (0x1BD8)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 2:31:32 PM    3960 (0x0F78)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 3:01:32 PM    5736 (0x1668)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 3:31:32 PM    4756 (0x1294)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 4:01:33 PM    9320 (0x2468)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 4:31:34 PM    10440 (0x28C8)
    SMS MP Registration Manager stopped.    MP_ClientRegistration    6/8/2015 4:56:33 PM    10380 (0x288C)
    SMS MP Registration Manager started.    MP_ClientRegistration    6/8/2015 5:01:35 PM    11132 (0x2B7C)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 5:01:35 PM    11132 (0x2B7C)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 5:31:35 PM    9664 (0x25C0)
    SMS MP Registration Manager stopped.    MP_ClientRegistration    6/8/2015 6:01:33 PM    8700 (0x21FC)
    SMS MP Registration Manager started.    MP_ClientRegistration    6/8/2015 6:01:36 PM    7132 (0x1BDC)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 6:01:36 PM    7132 (0x1BDC)
    SMS MP Registration Manager stopped.    MP_ClientRegistration    6/8/2015 6:26:33 PM    7224 (0x1C38)
    SMS MP Registration Manager started.    MP_ClientRegistration    6/8/2015 6:31:36 PM    11248 (0x2BF0)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 6:31:36 PM    11248 (0x2BF0)
    SMS MP Registration Manager stopped.    MP_ClientRegistration    6/8/2015 6:56:33 PM    10932 (0x2AB4)
    SMS MP Registration Manager started.    MP_ClientRegistration    6/8/2015 7:01:37 PM    11488 (0x2CE0)
    MP Reg: Received WMI instance modification notification    MP_ClientRegistration    6/8/2015 7:01:37 PM    11488 (0x2CE0)
    SMS MP Registration Manager stopped.    MP_ClientRegistration    6/8/2015 7:26:33 PM    12060 (0x2F1C)

    Tuesday, June 9, 2015 12:30 PM
  • WHen I try to querery SMS_Providers I get Error Comminicating with the component
    Tuesday, June 9, 2015 12:35 PM
  • MP_Location.log

    UID not found    MP_LocationManager    6/9/2015 9:40:50 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (BCS00002,13,BCS,SMSPACKAGE,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSPACKAGE" DistributeOnDemand="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" AllowHTTP="1" AllowSMB="0" AllowMulticast="0" UseInternetDP="0">
        <ADSite Name="ADMINBUILDING"/>
        <Forest Name="root.bedford"/>
        <Domain Name="bcsdny.org"/>
        <IPAddresses>
            <IPAddress SubnetAddress="10.100.0.0" Address="10.100.4.226"/>
        </IPAddresses>
    </ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:50 AM    11376 (0x2C70)
    UID not found    MP_LocationManager    6/9/2015 9:40:50 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:13a0a0e8-b40c-44b4-8181-6305d1f4a983,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:995be674-5f46-48f2-ae64-3ba49d353d3e,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:25f973f8-3f8b-4529-a01d-767de86b9442,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:09fccfbb-85d0-44f8-af75-6f9d6f628ae1,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:404c6967-0914-4e0f-8107-b15a75dd4688,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:0a5d46a8-82b4-46ff-ab8a-ee41379c5ab6,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:51 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:683de49d-e20b-47ad-8992-11f4bc58ef3c,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:1b09390f-4b7f-487e-9337-875635471c3b,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:a179e3c3-6b17-4ab1-bf73-802fc8cd7c21,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:ee25fa3d-cea6-4bac-a360-e854453829f3,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:b13873ad-205f-4cc3-aa0a-857a150ef7b7,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:f7ab93c1-5ed0-49fb-a6ce-6583e8bcbae0,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (UID:f314bbba-d724-4340-acb7-68bc09aa1faf,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="ADMINBUILDING"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.2.10"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:52 AM    11376 (0x2C70)
    UID not found    MP_LocationManager    6/9/2015 9:40:53 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (BCS00002,13,BCS,SMSPACKAGE,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSPACKAGE" DistributeOnDemand="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" AllowHTTP="1" AllowSMB="0" AllowMulticast="0" UseInternetDP="0">
        <ADSite Name="ADMINBUILDING"/>
        <Forest Name="root.bedford"/>
        <Domain Name="bcsdny.org"/>
        <IPAddresses>
            <IPAddress SubnetAddress="10.10.67.0" Address="10.10.67.210"/>
        </IPAddresses>
    </ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:40:53 AM    11376 (0x2C70)
    UID not found    MP_LocationManager    6/9/2015 9:40:53 AM    11376 (0x2C70)
    MP_GetAssignedMPListForSite  (root.bedford,bcsdny.org,BCS,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.253"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:00 AM    11376 (0x2C70)
    MP_GetInternetMPListForSite  (root.bedford,bcsdny.org)    MP_LocationManager    6/9/2015 9:41:01 AM    11376 (0x2C70)
    MP_GetAssignedMPListForSite  (root.bedford,bcsdny.org,BCS,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.4.226"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:01 AM    11376 (0x2C70)
    MP_GetInternetMPListForSite  (root.bedford,bcsdny.org)    MP_LocationManager    6/9/2015 9:41:01 AM    11376 (0x2C70)
    MP_GetProxyMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.4.226"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:01 AM    11376 (0x2C70)
    MP_GetLocalMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.4.226"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:02 AM    11376 (0x2C70)
    MP_GetProxyMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.253"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:02 AM    11376 (0x2C70)
    No package ID    MP_LocationManager    6/9/2015 9:41:02 AM    6660 (0x1A04)
    retreiving the certificates    MP_LocationManager    6/9/2015 9:41:02 AM    6660 (0x1A04)
    MP_GetLocalMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.253"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:02 AM    6660 (0x1A04)
    UID not found    MP_LocationManager    6/9/2015 9:41:04 AM    11376 (0x2C70)
    MP_GetContentDPInfoUnprotected (BCS00002,13,BCS,SMSPACKAGE,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSPACKAGE" DistributeOnDemand="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" AllowHTTP="1" AllowSMB="0" AllowMulticast="0" UseInternetDP="0">
        <ADSite Name="ADMINBUILDING"/>
        <Forest Name="root.bedford"/>
        <Domain Name="bcsdny.org"/>
        <IPAddresses>
            <IPAddress SubnetAddress="10.100.16.0" Address="10.100.16.109"/>
        </IPAddresses>
    </ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:04 AM    11376 (0x2C70)
    UID not found    MP_LocationManager    6/9/2015 9:41:04 AM    11376 (0x2C70)
    No package ID    MP_LocationManager    6/9/2015 9:41:05 AM    11376 (0x2C70)
    retreiving the certificates    MP_LocationManager    6/9/2015 9:41:05 AM    11376 (0x2C70)
    MP_GetAssignedMPListForSite  (root.bedford,bcsdny.org,BCS,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.7.50"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:09 AM    11376 (0x2C70)
    MP_GetInternetMPListForSite  (root.bedford,bcsdny.org)    MP_LocationManager    6/9/2015 9:41:09 AM    11376 (0x2C70)
    MP_GetProxyMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.7.50"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:09 AM    11376 (0x2C70)
    MP_GetLocalMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.7.50"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:09 AM    11376 (0x2C70)
    MP_GetAssignedMPListForSite  (root.bedford,bcsdny.org,BCS,<ClientLocationInfo OnInternet="0"><ADSite Name="MtKiscoElementary"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.70.62.0" Address="10.70.62.23"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    MP_GetInternetMPListForSite  (root.bedford,bcsdny.org)    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    MP_GetProxyMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="MtKiscoElementary"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.70.62.0" Address="10.70.62.23"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    MP_GetLocalMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="MtKiscoElementary"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.70.62.0" Address="10.70.62.23"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    No package ID    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    retreiving the certificates    MP_LocationManager    6/9/2015 9:41:13 AM    6660 (0x1A04)
    MP_GetAssignedMPListForSite  (root.bedford,bcsdny.org,BCS,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.239"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:16 AM    6660 (0x1A04)
    MP_GetInternetMPListForSite  (root.bedford,bcsdny.org)    MP_LocationManager    6/9/2015 9:41:17 AM    6660 (0x1A04)
    MP_GetProxyMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.239"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:17 AM    6660 (0x1A04)
    MP_GetLocalMPListForSite  (root.bedford,bcsdny.org,<ClientLocationInfo OnInternet="0"><ADSite Name="AdminBuilding"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddress="10.100.0.0" Address="10.100.1.239"/></IPAddresses></ClientLocationInfo>)    MP_LocationManager    6/9/2015 9:41:17 AM    6660 (0x1A04)
    UID not found    MP_LocationManager    6/9/2015 9:41:17 AM    6660 (0x1A04)
    UID not found    MP_LocationManager    6/9/2015 9:41:25 AM    6660 (0x1A04)
    MP_GetContentDPInfoUnprotected (UID:ee25fa3d-cea6-4bac-a360-e854453829f3,1,BCS,SMSUpdate,00000000,root.bedford,bcsdny.org,<ClientLocationInfo LocationType="SMSUpdate" DistributeOnDemand="0" UseAzure="0" AllowWUMU="0" UseProtected="0" AllowCaching="0" BranchDPFlags="0" UseInternetDP="0" AllowHTTP="1" AllowSMB="1" AllowMulticast="1"><ADSite Name="POUNDRIDGEES"/><Forest Name="root.bedford"/><Domain Name="bcsdny.org"/><IPAddresses><IPAddress SubnetAddres

    Tuesday, June 9, 2015 1:42 PM
  • Same problem here! SMS Providers are unknown in \Monitoring\Overview\System Status\Component Status after R2 SP1.
    Tuesday, June 9, 2015 8:26 PM
  • SMSDBMON.LOG keeps giving this error about not being able to create a file...

    RCV: UPDATE on Collections_L for PolicyTargetEvalNotify_iud [16777403  ][72057594161852537]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    RCV: UPDATE on Collections_L for PolicyTargetEvalNotify_iud [16777403  ][72057594161852538]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    RCV: UPDATE on Collections_L for PolicyTargetEvalNotify_iud [16777403  ][72057594161852539]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    RCV: UPDATE on Collections_L for PolicyTargetEvalNotify_iud [16777423  ][72057594161852540]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    RCV: UPDATE on Collections_L for PolicyTargetEvalNotify_iud [16777423  ][72057594161852541]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:02 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:04 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:06 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:08 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:10 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon SMSDIRECTORYLOOKUP=NOWINS.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:12 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon SMSDIRECTORYLOOKUP=NOWINS.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:14 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon SMSDIRECTORYLOOKUP=NOWINS.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:16 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon SMSDIRECTORYLOOKUP=NOWINS.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:18 PM    6796 (0x1A8C)
    Warning: Could not create file C:\Program Files\Microsoft Configuration Manager\inboxes\ccr.box\SMSSITECODE=BCS DISABLECACHEOPT=TRUE DNSSUFFIX=bcsdny.org MP:BCSD-SCCM /logon SMSDIRECTORYLOOKUP=NOWINS.CPC, Error=123.    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:20 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777351.CCN  [72057594161852429]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777351.CCN  [72057594161852430]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777351.CCN  [72057594161852431]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777596.CCN  [72057594161852432]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777596.CCN  [72057594161852433]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777596.CCN  [72057594161852434]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777596.CCN  [72057594161852435]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777596.CCN  [72057594161852436]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777638.CCN  [72057594161852437]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777638.CCN  [72057594161852438]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777638.CCN  [72057594161852439]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777638.CCN  [72057594161852440]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777638.CCN  [72057594161852441]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)
    SND: Dropped C:\Program Files\Microsoft Configuration Manager\inboxes\policypv.box\policytargeteval\16777297.CCN  [72057594161852442]    SMS_DATABASE_NOTIFICATION_MONITOR    6/10/2015 1:30:22 PM    6796 (0x1A8C)

    Wednesday, June 10, 2015 5:34 PM
  • I was having the same error on our server.  It looks like Microsoft implemented a new trigger in R2 SP1 that is causing the issue.  Using SQL Server Management Studio, I disabled the trigger and now the clients appear to be registering successfully.

    Specifically, I went into CM_PSR (our site database) -> Tables -> dbo.ClientKeyData -> Triggers, then right clicked on SMSDBMON_ClientKeyData_PfxCertsClientKeyData_Chg_upd and chose Disable.

    If you choose to do this, make sure you reenable the trigger when Microsoft releases the inevitable hotfix that actually corrects the problem...

    • Proposed as answer by Kloostec Thursday, June 11, 2015 12:01 AM
    • Marked as answer by Second Edition Thursday, June 11, 2015 12:39 PM
    Wednesday, June 10, 2015 11:03 PM
  • There is no inevitable hotfix unless someone opens a support case with Microsoft CSS.

    Also, simply disabling a trigger like this is not a good plan. How do you know it's a new trigger?

    Someone experiencing the problem really needs to open a case here is the bottom line.


    Jason | http://blog.configmgrftw.com | @jasonsandys

    Thursday, June 11, 2015 12:56 AM
  • > How do you know it's a new trigger?

    I compared against my pre-upgrade database backup.

    > Also, simply disabling a trigger like this is not a good plan

    I read the trigger code and made an educated guess that any symptoms we experience due to the trigger being disabled will be less severe than the issue we're all experiencing (all new builds not being able to fetch policies or communicate with MPs).

    Thursday, June 11, 2015 4:21 AM
  • Hi! As I mentioned earlier we have the same problems here. After 2012 R2 SP1 in \Monitoring\Overview\System Status\Component Status the SMS_Providers have Status OK but are of Typ eand Available unknown and the SMS_SITE_COMPONENT_MANAGER has Type "Component Not Installed by Site Component Manager" but Avail. Online and the service is running on site server.

    The installation of the SP1 runs fine without any errors. I think all the systems running fine because I am able to run the Management Console without any problems.

    Which logs are interesting to look into?

    Every help is appreciated.


    • Edited by -Dietmar- Thursday, June 11, 2015 10:10 AM
    Thursday, June 11, 2015 10:10 AM
  • I was having the same error on our server.  It looks like Microsoft implemented a new trigger in R2 SP1 that is causing the issue.  Using SQL Server Management Studio, I disabled the trigger and now the clients appear to be registering successfully.

    Specifically, I went into CM_PSR (our site database) -> Tables -> dbo.ClientKeyData -> Triggers, then right clicked on SMSDBMON_ClientKeyData_PfxCertsClientKeyData_Chg_upd and chose Disable.

    If you choose to do this, make sure you reenable the trigger when Microsoft releases the inevitable hotfix that actually corrects the problem...

    Yes! Thank you.. you really are "ftw" :)

    This solved my issue !!

    Thursday, June 11, 2015 12:38 PM
  • There is no inevitable hotfix unless someone opens a support case with Microsoft CSS.

    Also, simply disabling a trigger like this is not a good plan. How do you know it's a new trigger?

    Someone experiencing the problem really needs to open a case here is the bottom line.


    Jason | http://blog.configmgrftw.com | @jasonsandys


    I was  trying to avoid paying $500... For future reference, would the fee be waved for an issue like this or a bug caused by Microsoft?
    Thursday, June 11, 2015 12:44 PM
  • To my knowledge yes, fees associated with cases involving bugs are waived.

    Note that I have sent the link to this forum thread directly to the product group so it *may* get some visibility. The CSS path is always the best path to take though.


    Jason | http://blog.configmgrftw.com | @jasonsandys


    Thursday, June 11, 2015 1:03 PM
  • I have an open case and one other person I know does as well. My case has been escalated, no resolution to the issue as of yet.....its causing a lot of issues in our environment though....HELP MICROSOFT........


    Joshua Denzik

    Senior Systems Engineer 

     email: Denzik@musc.edu

    Thursday, June 11, 2015 2:06 PM
  • There are still some problems not solved with the SP1 for R2.

    On Windows 7 SP1 the first time we open the ConfigMgr-Client and execute some tasks we always get this compatibility question.

    In start menu are now two Software Centers, in Microsoft System Center and in Microsoft System Center 2012 R2.

    The roles above seems to display the wrong state.

    The client still goes down for 3600 seconds after a short while on a new deployed machine. There is a thread on this forum.

    No problems solved but some new! Very strange! I pull my hairs out.

    Thursday, June 11, 2015 3:32 PM
  • i have same case client can't register to site and no-certificate

    any update :(


    Mahmoud

    Wednesday, June 17, 2015 10:04 AM
  • Have a case open about this with MS and was told it is a known bug and they are working on a hotfix. Since many cases are open about this it is a high priority but no ETA.
    Thursday, June 18, 2015 3:54 PM
  • Any update on a hotfix?
    Monday, June 22, 2015 8:00 PM
  • Deleted
    Thursday, July 2, 2015 1:22 PM
  • This should solve the problem: https://support.microsoft.com/de-de/kb/3073015/en-us

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by D3nv3r Monday, July 13, 2015 1:38 PM
    Monday, July 13, 2015 10:05 AM
    Moderator
  • I can confirm that the hotfix Torsten posted solved our issue.  Kloostec, thanks for getting us through in the interim. 
    Monday, July 13, 2015 4:58 PM
  • Confirmed that this has solved the issue for me too.  I reenabled the trigger, then installed the hotfix, and reformatted machines are reenrolling properly.
    Monday, July 13, 2015 8:10 PM
  • I just upgraded our environment to R2 SP1, and I have not noticed any clients having problems registering "yet", but the SMS_DISCOVERY_DATA_MANAGER is showing RED\CRITICAL. The Status Message Viewer is reporting the following error:

    Microsoft SQL Server reported SQL message 8169, severity 16: [42000][8169][Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting from a character string to uniqueidentifier. : SMSDBMON_ClientKeyData_PfxCertsClientKeyData_Chg_upd

    Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

    -Tony


    Tuesday, July 28, 2015 2:19 PM
  • Have you applied the hotfix listed by Torsten above?

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, July 28, 2015 2:24 PM
  • Not yet Jason, I am betting I am going to have to apply it to get the SMS_DISCOVERY_DATA_MANAGER component healthy. I am in talks with leadership currently to get it on the docket for our Change Management meeting later this week.

    -Tony

    Tuesday, July 28, 2015 2:36 PM
  • Applying the Hotfix cleared up the component errors and removed the errors from the ddm.log.

    -Tony

    Thursday, July 30, 2015 1:11 PM
  • same problem where SMS_Provider is unknown ... Clients are communicating but I get a warning for  SMS_Notification server.

    This is something completely different compared to the initial posting (I did not re-read the entire thread again) which talks about client registration.

    SMS_Provider unknown should not cause any issues as it's by design.


    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, September 17, 2015 10:14 PM
    Moderator