Did you install latest SQL 2019 Update Rollup?
SCOM 2019 install - cannot find System.Library.mp and Maximum stored procedure error,
Attempting to install SCOM 2019.
Environment: SQL 2019 on Windows Server 2019, Two Mgmt Servers, One web server - Windows Server 2019
Error:
[14:07:40]: Info: :Info:FirstManagementServer: Importing Management Pack: System Library
[14:07:40]: Always: :ImportManagementPack: Loading management pack D:\System Center Operations Manager 2019\Setup\AMD64....\ManagementPacks\System.Library.mp. 14:07:40
[14:07:49]: Error: :ImportManagementPack: Error: Unable to load management pack D:\System Center Operations Manager 2019\Setup\AMD64....\ManagementPacks\System.Library.mp
[14:07:49]: Error: :: Database error. MPInfra_p_ManagementPackInstall failed with exception:
<MP ID: 01c8b236-3bce-9dba-6f1c-c119bcdc2972><MP Version: 7.5.8501.0><MP PKT: 31bf3856ad364e35> Database error. MPInfra_p_ManagementPackInstall failed with exception:
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
[14:07:49]: Error: :ImportManagementPack: Unknown Error. System.ArgumentException : The requested management pack is not valid. See inner exception for details.
Parameter name: managementPack
[14:07:49]: Always: :FirstManagementServer: Failed to load MP D:\System Center Operations Manager 2019\Setup\AMD64....\ManagementPacks\System.Library.mp. We will retry.
[14:07:49]: Always: :ImportManagementPack: Loading management pack D:\System Center Operations Manager 2019\Setup\AMD64....\ManagementPacks\System.Library.mp. 14:07:49
[14:07:50]: Error: :ImportManagementPack: Error: Unable to load management pack D:\System Center Operations Manager 2019\Setup\AMD64....\ManagementPacks\System.Library.mp
[14:07:50]: Error: :: Database error. MPInfra_p_ManagementPackInstall failed with exception:
<MP ID: 01c8b236-3bce-9dba-6f1c-c119bcdc2972><MP Version: 7.5.8501.0><MP PKT: 31bf3856ad364e35> Database error. MPInfra_p_ManagementPackInstall failed with exception:
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
This is my third attempt today, all have failed.
Operations Manager
3 additional answers
Sort by: Most helpful
-
Tony Strother 171 Reputation points
2021-05-15T21:07:45.633+00:00 Afternoon, No, I misread the SQL requirements as being CU3 (need new glasses I think) when in fact it is CU8. I have contacted our SQL group to ask that it be updated. Then I will take another run at it.
Will let you know and thank you!
Tony -
anthony strother 581 Reputation points
2021-05-21T10:58:41.75+00:00 Morning,
It was indeed the update level of the SQL server install. The DBA's applied CU10 to the install. I was able to get SCOM 2019 installed without issue yesterday.
Thanks again for the time and assistance!
Tony -
Crystal-MSFT 53,971 Reputation points Microsoft External Staff
2021-05-24T02:24:37.65+00:00 @anthony strother , Thanks for letting us know the latest status. I am glad to hear that SCOM 2019 has been installed successfully after DBA's applied CU10. Congratulations! If there's anything else we can help in the future, feel free to post in our Q&A to discuss together.
Thanks for your time and have a nice day!