Forum Discussion
System Center 2019 Data Warehouse installation problem
MicrosoftJess_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
MicrosoftSolved 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
Ovidiu
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 markingHopefully somebody has more solutions for us to try!
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?
- OvidiuPismac
https://docs.microsoft.com/en-us/system-center/scsm/system-requirements?view=sc-sm-2019
For SQL 2017, SM doesn’t support SSAS mode Tabular. Select the SSAS mode as Multi-dimensional during the installation of SQL Server 2017.
SQL Analysys Service in Multi-Dimensional not Tabular.
- OvidiuPismac
Hi,
System Center Data Warehouse is supporting SQL Server Analysis Services in Multi-Dimensional option.
Default SQL Analysis Services is installed in Tabular Mode.
So uninstall SQL Server and repeat the installation of SQL Server Analysis Server and choose Multi-dimensional.
https://docs.microsoft.com/en-us/system-center/scsm/system-requirements?view=sc-sm-2019
Ovidiu Pismac
