SCOM 2019 UR2 Management Packs cannot be imported

Birdal 116 Reputation points
2020-08-20T08:05:51.373+00:00

Hi all,
we applied SCOM 2019 UR2 and in the next step we wanted to import the newest MPs from the path "C:\Program Files\Microsoft System Center\Operations Manager\Server\Management Packs for Update Rollups"

Unfortunately the import of all MPs are failed with the following error:
"Database error. MPInfra_p_ManagementPackInstall failed with exception:
[SQL Error Code: -2146232060][MP ID: 8d053a15-dd8a-be4e-6305-4c458725d58f][MP Version: 10.19.10407.0][MP PKT: 31bf3856ad364e35] Procedure or function p_MPImportXML has too many arguments specified."

19018-mp-ur2-import.png

Any help?
Best regards
Birdal

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,261 Reputation points MVP
    2020-08-20T08:12:34+00:00

    Hi @Birdal ,
    have you confirmed that UR2 has been applied successfully?
    Can you please also check the status of your SQL, restart the SDK service on your management servers and try again?
    Are there any Events on your management servers?

    Thanks and Regards

    ----------

    (If the reply was helpful please don't forget to accept as answer, thank you)
    Stoyan

    0 comments
  2. Birdal 116 Reputation points
    2020-08-20T09:20:40.373+00:00

    Hi Stoyan,
    the manually UR2 update process is run without any problem. Honestly, I must say that I did not check every file version after UR2. What I checked were all OK, newest.

    I see in the first SCOM Management Server many following errors event ID 26319:
    "An exception was thrown while processing GetUserRolesForOperationAndUser for session ID uuid:3858ddba-997e-4b54-bd4d-70bf0917f3e3;id=264.
    Exception message: Value does not fall within the expected range.
    Full Exception: System.ArgumentException: Value does not fall within the expected range.
    at Microsoft.EnterpriseManagement.Interop.Security.Auth.IAzApplication2.InitializeClientContextFromStringSid(String SidString, Int32 lOptions, Object varReserved)
    at Microsoft.EnterpriseManagement.Mom.Sdk.Authorization.AzManHelper.GetScopedRoleAssignmentsForUser(Int32 operationNumericId, String userName)
    at Microsoft.EnterpriseManagement.Mom.Sdk.Authorization.AuthManager.GetUserRolesForOperationAndUser(Guid operationId, String userName)
    at Microsoft.EnterpriseManagement.Mom.Sdk.Authorization.AuthorizationService.GetUserRolesForOperationAndUser(Guid operationId, String userName)
    at Microsoft.EnterpriseManagement.ServiceDataLayer.SecurityConfigurationService.GetUserRolesForOperationAndUser(Guid operationId, String userName)
    at Microsoft.EnterpriseManagement.Mom.ServiceDataLayer.SdkDataAccessBackCompatProxy.GetUserRolesForOperationAndUser(Guid operationId, String userName)"

    19094-evemtid-26319.png

    Is there any status check script for Management Server and/or SQL server?
    Best regards
    Birdal

    0 comments
  3. Leon Laude 85,651 Reputation points
    2020-08-20T10:15:27.303+00:00

    Hi @Birdal ,

    Since you encountered some issues while applying the Update Rollup 2 as per your other thread "SCOM 2019 UR2 installation issue", did you successfully apply all the updates, SQL scripts and management packs? Also did you ensure that everything was done in the correct order?

    ----------

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

    Best regards,
    Leon

  4. SChalakov 10,261 Reputation points MVP
    2020-08-20T11:51:00.887+00:00

    Hi @Birdal ,

    there was a similar issue with importing the MPs from UR1, but the error was different:

    MPInfra_p_ManagementPackInstall failed with exception: Database error. MPInfra_p_ManagementPackInstall failed with exception: Invalid column name ‘DisplayName’.

    I am not quite sure how to troubleshoot this exactly. If you want more information you will have to do some digging on your backend side, do a tracing, check the logs.
    If you have already done the standard stuff in SCOM (empty cache, restart services, etc..) then opening a case with MS would be also a good idea.

    Do you think this is possible?
    Regards,
    Stoyan

    0 comments
  5. Birdal 116 Reputation points
    2020-08-24T08:45:29.883+00:00

    Hi Stoyan,
    Hi Leon,

    we made rollback of SCOM 2019 UR2 to UR1, and will not deploy UR2 until Microsoft solve the update problems.

    Best regards
    Birdal