question

anthonypstrother-8017 avatar image
0 Votes"
anthonypstrother-8017 asked Crystal-MSFT answered

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.

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CyrAz avatar image
0 Votes"
CyrAz answered

Did you install latest SQL 2019 Update Rollup?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TonyStrother-2074 avatar image
0 Votes"
TonyStrother-2074 answered Crystal-MSFT commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@TonyStrother-2074 , Thanks for the update. It seems to be the cause. We will wait for your update. If there' s anything else we can help during this time, feel free to post back.

Have a nice day!

0 Votes 0 ·

@TonyStrother-2074, How's everything going? I am writing to see if we have the opportunity to update the SQL server. If there's any update, I appreciate your help sharing here.

Thanks and have a nice day!

0 Votes 0 ·
anthonypstrother-8017 avatar image
0 Votes"
anthonypstrother-8017 answered Crystal-MSFT converted comment to answer

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Crystal-MSFT avatar image
0 Votes"
Crystal-MSFT answered

@anthonypstrother-8017, 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!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.