System Center 2019 Data Warehouse installation problem

[Ovidiu_Pismac1]

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

SQL 2017 Reporting Services links  /ReportServer and /Reports are working.  

I have made setting ServicesPipeTimeout 600.000 in the registry (first link below), added domain admin in Reporting Services Configuration Manager with full rights on SRS Folders (second link below) and verified SRS files rsssrvpolicy.config files as in the last TechNet link below.

Nothing it’s working …please help me with your advice

https://vlacticcloud.wordpress.com/2017/04/21/error-when-installing-service-manager-datawarehouse-an...

https://social.technet.microsoft.com/Forums/Azure/en-US/73abd465-7500-471c-9edd-9686c49db401/an-erro...

https://social.technet.microsoft.com/Forums/systemcenter/en-US/06412c75-6a66-4fe1-885a-2fd087e42fc1/...

http://technet.microsoft.com/en-us/library/hh519664.aspx

Thank you,

Ovidiu

[#2]

Anybody can help with an update?@Ovidiu_Pismac1 

[#3]

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.@Ovidiu Pismac 

[#4]

Thank you. I will try and ley you know.

[#5]

@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

[#6]

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-mod... 

Ovidiu

[#7]

@Ovidiu Pismac 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!

[#8]

@Primoo357 

I have the same problem.

Any help?

[#9]

@josemanlopes 

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

[#10]

@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?

[#11]

@Roberto Castaneda 

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.

[#12]

@Ovidiu Pismac  I have the same issue, and my SSAS is in multidimesional mode

[#13]

If none of those solutions above seems to work, enable Server Named Pipes on SQL configuration manager

[#14]

@GerhardR 

In my case multi-dimensional mode was the answer. I never checked Named Pipes in SQL configuration

Ovidiu Pismac

[#15]

Multi-dimensional mode was the answer for me also actually

[#16]

@Ovidiu_Pismac1 

I also encountered this problem in my installation, but even the multi-dimensional SAS, still had the error.
It was then that I realized that as soon as the System center started to install the files, it ends up stopping the SSRS service. So as soon as it enters the step of installing files, just open the SSRS configuration and start the service again and let the installation continue.

[#17]

Hi Israel, Please check the prerequisites...possible you have forgot to configure something https://docs.microsoft.com/en-us/system-center/scsm/system-requirements?view=sc-sm-2019 For me it was only the multi-dimentional SAS...if you have virtual machine - please make a snapshot before installing data warehouse to be able to return to a clean state before trying another installation.

[#18]

Just completed SCSM DW server installation. I've resolved the same _CreateSrsFolder_SC error with local intranet setting. Write a blog with resolution. https://bscexp.blogspot.com/2021/07/scsm-error-occurred-while-executing.html