Forum Discussion

Ovidiu_Pismac1's avatar
Ovidiu_Pismac1
Copper Contributor
Mar 25, 2019

System Center 2019 Data Warehouse installation problem

Hi,   Installation of System Center 2019 Data Warehouse fails with domain admin (the same user that installed SQL 2017 database and reporting). Error is in the picture below _CreateSRSFolder_SC S...
Jess_Klamath's avatar
Jess_Klamath
Copper Contributor
Apr 03, 2019

I found that the service for the SQL Reporting Services is stopping at the beginning of the install.  If you restart that service, the product will continue to install.OvidiuPismac 

OvidiuPismac's avatar
OvidiuPismac
Icon for Microsoft rankMicrosoft
Apr 14, 2019

Jess_Klamath  Started SQL Server Reporting Servcie service during System Center Service Manager 2019 DataWarehouse setup and installer ran but stops in  few minutes after with _ConfigureAnalysisServer error. Picture attached

  • OvidiuPismac's avatar
    OvidiuPismac
    Icon for Microsoft rankMicrosoft
    Apr 15, 2019

    Solved with setting the SQL Server 2017 Analysis Service on DataWarehouse.and Management server from tabular (default installation with SQL 2017) to multidimensional and worked.

     

    Pay attention to SQL 2017 Default Installation of Analysis Service comes with Tabular mode.

    Service Manager 2019 does not support Tabular mode of Analysis Service. 

    https://docs.microsoft.com/en-us/system-center/scsm/release-notes-sm?view=sc-sm-2019 

     

    You can change the Analysis Service mode after installation based on this link 

    https://www.sqlservercentral.com/articles/how-to-change-an-analysis-services-instance-to-tabular-mode 

     

    Ovidiu

    • Primoo357's avatar
      Primoo357
      Copper Contributor
      May 03, 2019

      OvidiuPismac I tried this and all the suggestions posted on the thread. But still not working.

       

      Here are the errors that I am receiving from the SCSMInstall.log:

      InstallHSPerfCounters: Custom Action Data. C:\Program Files\Microsoft System Center\Service Manager\
      InstallHSPerfCounters: Installing agent perf counters.
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. MOMConnector
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. MOMConnector
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. MOMConnector
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. MOMConnector
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\HealthServiceCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. HealthService
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070057. momv3 "C:\Program Files\Microsoft System Center\Service Manager\MOMConnectorCounters.ini"
      InstallPerfCountersHelper: pcCounterInstaller->InstallCounters() for the default counters failed. Error Code: 0x80070057. MOMConnector
      InstallPerfCountersLib: InstallHealthServicePerfCounters() failed . Error Code: 0x80070057.
      InstallPerfCountersLib: Retry Count : .
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. HealthService
      UninstallCounters: UnloadPerfCounterTextStrings() failed . Error Code: 0x800703F2.
      UninstallPerfCountersHelper: pcCounterInstaller->UninstallCounters() for the default counters failed. Error Code: 0x800703F2. MOMConnector
      InstallHSPerfCounters: Failed to install agent perf counters. Error Code: 0x80070057.
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 512 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 2456 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 5708 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 4956 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 8500 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 8276 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 7252 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 7684 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 8796 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 1804 could not be cancelled. Error: 1168
      MSI (s) (9C:EC) [11:43:12:079]: I/O on thread 5100 could not be cancelled. Error: 1168
      MSI (s) (9C!40) [11:43:12:080]: Product: Microsoft System Center Service Manager -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 25211. The arguments are: -2147024809, The parameter is incorrect.,
      The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 25211. The arguments are: -2147024809, The parameter is incorrect.,
      CustomAction _RollBack_UninstallHealthServicePerfCountersForUpgrade.80B659D9_F758_4E7D_B4FA_E53FC737DCC9 returned actual error code 1603 but will be translated to success due to continue marking

       

      Hopefully somebody has more solutions for us to try!

      • Roberto Castaneda's avatar
        Roberto Castaneda
        Copper Contributor
        Mar 30, 2020

        Primoo357 

         

        If you find a solution to this I'd appreciate if you can share. I am setting up a test environment and have tried at least 4-5 setting changes and get nothing. I have uninstalled SQL 3 times now(4th time today).

         

        Are there steps anywhere to properly install SQL 2019 with SCSM 2019?

Resources