Upgrade SCOM 2019 to 2022, SQL timetout

Question

question

MarekG-1989 asked Apr 7, '22 MarekG-1989 answered Apr 13, '22

Upgrade SCOM 2019 to 2022, SQL timetout

Hi all,
pls I try upgrading scom 2019 to 2022, but every end with error :
0:49:45]: Error: :Error:FirstManagementServer: Failed to load MP C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp on retry number 2
[10:49:45]: Always: :ImportManagementPack: Loading management pack C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp. 10:49:45
[11:49:58]: Error: :ImportManagementPack: Error: Unable to load management pack C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp
[11:49:58]: Error: :: Database error. MPInfra_p_ManagementPackInstall failed with exception:
<MP ID: 01c8b236-3bce-9dba-6f1c-c119bcdc2972><MP Version: 7.5.8501.1><MP PKT: 31bf3856ad364e35> Database error. MPInfra_p_ManagementPackInstall failed with exception:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

[11:49:58]: Error: :ImportManagementPack: Unknown Error. System.ArgumentException : The requested management pack is not valid. See inner exception for details.

Parameter name: managementPack
[11:49:58]: Error: :Error:FirstManagementServer: Failed to load MP C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp on retry number 3
[11:49:58]: Error: :Error:FirstManagementServer: Gave up trying to load the MP C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp
[11:49:58]: Error: :Error:failed to import Server management packs. This is a fatal error
[11:49:58]: Error: :FATAL ACTION: ImportManagementPacks
[11:49:58]: Error: :FATAL ACTION: DatabaseActions

any idea ?

msc-operations-manager

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2022-04-08T06:17:59.363Z

SimonRenMSFT-3639 answered Apr 8, '22 SimonRenMSFT-3639 commented Apr 12, '22

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

1,May we know what version of SQL you are using? Operations Manager 2022 supports SQL 2019 with CU8 or later. Refer to the official article:
SQL Server Design Considerations

2,Also as @StoyanChalakov mentioned, please check the Event log to see if there is any useful information.

Best regards,
Simon

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1

5 |1600 characters needed characters left characters exceeded

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

SimonRenMSFT-3639 · Apr 12 at 09:06 AM

Hi,

Hope everything goes well. May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.

Best regards,
Simon

0 ·

Answer 2 · 2022-04-07T12:34:41.12Z

StoyanChalakov answered Apr 7, '22

Hi @MarekG-1989,

I know a couple of possible causes for that:

Your SQL DB does not have enough space
You are not an SCOM Admin or local Admin on the SCOM Servers
You don't have SQL permissions or your are not local Admin on the SQL nodes (something, which is important during a clean install or an upgrade)
Your ports are being blocked.

Can you please verify those and also post some more information about the SQL Version you are using?

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Stoyan Chalakov

5 |1600 characters needed characters left characters exceeded

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

Answer 3 · 2022-04-07T14:46:58.557Z

MarekG-1989 answered Apr 7, '22

thank you for answer
1) free about 250gb
2) I am administrator in all scom servers and try set access account also admin all server, the table updatestatus is create
4) firewall rules open for all...
still trouble:
[16:12:02]: Error: :ImportManagementPack: Error: Unable to load management pack C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp
[16:12:02]: Error: :: Database error. MPInfra_p_ManagementPackInstall failed with exception:
<MP ID: 01c8b236-3bce-9dba-6f1c-c119bcdc2972><MP Version: 7.5.8501.1><MP PKT: 31bf3856ad364e35> Database error. MPInfra_p_ManagementPackInstall failed with exception:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

[16:12:02]: Error: :ImportManagementPack: Unknown Error. System.ArgumentException : The requested management pack is not valid. See inner exception for details.

Parameter name: managementPack
[16:12:02]: Always: :FirstManagementServer: Failed to load MP C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp. We will retry.
[16:12:02]: Always: :ImportManagementPack: Loading management pack C:\System Center Operations Manager 2022\Setup\AMD64....\ManagementPacks\System.Library.mp. 16:12:02

5 |1600 characters needed characters left characters exceeded

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

Answer 4 · 2022-04-07T20:01:06.36Z

StoyanChalakov answered Apr 7, '22

Hi Marek,

please appologize, but just to be sure: You are also admin on the SQL Server, right?
Another thing: When you say that you have 250GB, yiou mean the dribve, where the DB is located. What about the DB itself? It shouldn't autogrow normally and if it has hit its end size than the error looks liek this.
Can you please go to the OperationsManager DB in SQL, right click it, select "Reports", then "Standard Reports" -> "Disk Usage"
Looks like this:

What do you see on the report?

Can you please also check your existing management Servers, filter their event logs for errors and warnings and check for soemthing unusual?

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Stoyan Chalakov

image.png (40.6 KiB)

5 |1600 characters needed characters left characters exceeded

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

Answer 5 · 2022-04-13T17:47:50.317Z

MarekG-1989 answered Apr 13, '22

Hi all, I finally reinstalled the SCOM farm cell. As it turned out, the problem was really in the version of SQL 2019 without CU8. Thanx

5 |1600 characters needed characters left characters exceeded

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

question