Hello everybody,
i'm actually facing a strange issue in SCCM with the component SMS_HIERARCHY_MANAGER. I got thousand of SQL Errors.
Let me explain how it happen :
Last week i add a secondary DP to my hierarchy, installation was going well except that the DP installation status was stuck "in progress" because the task "SMS Client" said "May need a reboot". I decided to manuallly install the SMS client on the DP and i rebooted the server. The installation of the new DP was clearly a success for me because i tried deploying new content on this DP and it worked well.
After that i try to put the DP in maintenance mode to force SCCM to update his installation status. It doesn't work at all and i started getting undreds of messages with the same error in SMS_HIERARCHY_MANAGER :
"The Hierarchy Manager successfully processed "D: \ Microsoft Configuration Manager \ inboxes \ hman.box \ ACY.SCU", which represented the site control file for the site "Primary Site Annecy" (ACY). "
"Microsoft SQL Server reported SQL message 241, severity 16: [22007] [241] [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Failed to convert date and / or time from 'a character string. "
(sorry for the traduction, everything is in french language in my company)
I checked the haman.log and i saw it was stuck in a loop trying to update DP status :
*** update DistributionPoints set IsPullDP = 0, IsPeerDP = 0, SMSSiteCode = 'ACY', IsBITS = 0, PreStagingAllowed = 0, IsMulticast = 0, AnonymousEnabled = 1, TokenAuthEnabled = 0, IsDoincEnabled = 0, SslState = 0, DPType = 0, Priority = 200, DPFlags = 0, MaintenanceModeLastStartTime = (CASE WHEN 'févr 21 2020 12:31PM' = '' THEN NULL ELSE 'févr 21 2020 12:31PM' END), MaintenanceMode = 1, IsProtected = 0, MinFreeSpace = 1024, Flags = 0, DPDrive = N'', IsPXE = 0, SccmPXE = 0, IsActive = 0, ResponseDelay = 0, UdaSetting = 0, BindPolicy = 0, SupportUnknownMachines = 0, CertificateType = 0, IdentityGUID = N'daa7ce70-8abd-4217-a1ab-b0c616784a0c', BindExcept = N'', PXEPassword = N'', Account = N'', Description = N'DP Only - DP secondaire - Site : Annecy', DPCRC = N'D4AB69DC', Action = 0 where NALPath = N'["Display=\\SERV-SCCMDP01.ch-annecy.local\"]MSWNET:["SMS_SITE=ACY"]\\SERV-SCCMDP01.ch-annecy.local\' SMS_HIERARCHY_MANAGER 21/02/2020 13:41:10 9488 (0x2510)
*** [22007][241][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de la conversion de la date et/ou de l'heure à partir d'une chaîne de caractères. SMS_HIERARCHY_MANAGER 21/02/2020 13:41:10 9488 (0x2510)
The only solution i found to stop the messages was going to the directory hman.box ("\\server\disk$\Microsoft Configuration Manager\inboxes\hman.box\" and rename the file called "SiteCODE.SCU" in .old and the loop stopped, but it start again while sccm ask for an update. Actually i got 5600 errors messages in SMS_HIERARCHY_MANAGER.
In the "smsdbmon" file i saw that SCCM was trying to evaluate maintenances tasks and commands in a loop.
I dont understand the problem because thing we did was installating new DP, the DP server version is the same as the site server. Site server account is local administrator of both servers and i follow the prerequisites requirement before installing the new DP.
I also opened a case at Microsoft support but i know by experience that it's pretty hard to obtained an answer from them if the issue is not already documented...
I attached the smsdbmon.log and hman.log files to this thread. The problem started at 11.38am the 21 of february.
Hope someone could help me.
Thanks you.
i'm actually facing a strange issue in SCCM with the component SMS_HIERARCHY_MANAGER. I got thousand of SQL Errors.
Let me explain how it happen :
Last week i add a secondary DP to my hierarchy, installation was going well except that the DP installation status was stuck "in progress" because the task "SMS Client" said "May need a reboot". I decided to manuallly install the SMS client on the DP and i rebooted the server. The installation of the new DP was clearly a success for me because i tried deploying new content on this DP and it worked well.
After that i try to put the DP in maintenance mode to force SCCM to update his installation status. It doesn't work at all and i started getting undreds of messages with the same error in SMS_HIERARCHY_MANAGER :
"The Hierarchy Manager successfully processed "D: \ Microsoft Configuration Manager \ inboxes \ hman.box \ ACY.SCU", which represented the site control file for the site "Primary Site Annecy" (ACY). "
"Microsoft SQL Server reported SQL message 241, severity 16: [22007] [241] [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Failed to convert date and / or time from 'a character string. "
(sorry for the traduction, everything is in french language in my company)
I checked the haman.log and i saw it was stuck in a loop trying to update DP status :
*** update DistributionPoints set IsPullDP = 0, IsPeerDP = 0, SMSSiteCode = 'ACY', IsBITS = 0, PreStagingAllowed = 0, IsMulticast = 0, AnonymousEnabled = 1, TokenAuthEnabled = 0, IsDoincEnabled = 0, SslState = 0, DPType = 0, Priority = 200, DPFlags = 0, MaintenanceModeLastStartTime = (CASE WHEN 'févr 21 2020 12:31PM' = '' THEN NULL ELSE 'févr 21 2020 12:31PM' END), MaintenanceMode = 1, IsProtected = 0, MinFreeSpace = 1024, Flags = 0, DPDrive = N'', IsPXE = 0, SccmPXE = 0, IsActive = 0, ResponseDelay = 0, UdaSetting = 0, BindPolicy = 0, SupportUnknownMachines = 0, CertificateType = 0, IdentityGUID = N'daa7ce70-8abd-4217-a1ab-b0c616784a0c', BindExcept = N'', PXEPassword = N'', Account = N'', Description = N'DP Only - DP secondaire - Site : Annecy', DPCRC = N'D4AB69DC', Action = 0 where NALPath = N'["Display=\\SERV-SCCMDP01.ch-annecy.local\"]MSWNET:["SMS_SITE=ACY"]\\SERV-SCCMDP01.ch-annecy.local\' SMS_HIERARCHY_MANAGER 21/02/2020 13:41:10 9488 (0x2510)
*** [22007][241][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de la conversion de la date et/ou de l'heure à partir d'une chaîne de caractères. SMS_HIERARCHY_MANAGER 21/02/2020 13:41:10 9488 (0x2510)
The only solution i found to stop the messages was going to the directory hman.box ("\\server\disk$\Microsoft Configuration Manager\inboxes\hman.box\" and rename the file called "SiteCODE.SCU" in .old and the loop stopped, but it start again while sccm ask for an update. Actually i got 5600 errors messages in SMS_HIERARCHY_MANAGER.
In the "smsdbmon" file i saw that SCCM was trying to evaluate maintenances tasks and commands in a loop.
I dont understand the problem because thing we did was installating new DP, the DP server version is the same as the site server. Site server account is local administrator of both servers and i follow the prerequisites requirement before installing the new DP.
I also opened a case at Microsoft support but i know by experience that it's pretty hard to obtained an answer from them if the issue is not already documented...
I attached the smsdbmon.log and hman.log files to this thread. The problem started at 11.38am the 21 of february.
Hope someone could help me.
Thanks you.
