SCOM 2019 UR2 Error DB Scripts not installed

Сергей Колыбин 1 Reputation point
2020-10-30T23:09:28.65+00:00

After the COM 2019 update, many errors appeared on the management server. Initially, the update went through Windows update. Then I tried to update the database scripts manually. DW storage was updated without problems. But the main database in SCOM is not updated manually, writes "Time" p_MP import XML module "has a dependency on the missing "DBO. p_ManagementPackFinishInstall" object. The module will be created, but it will not be able to work properly while this object does not exist."

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,417 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,666 Reputation points
    2020-10-31T09:04:13.927+00:00

    Hi @Сергей Колыбин ,

    I would try and run the simplified patching (one-click-installer) for Update Rollup 2 and run it on your SCOM management server, it will update the management server role, update the databases with SQL scripts, and then import any Management Pack updates.

    I would not recommend updating via Windows Update, as there has been many issues by doing that.

    Some helpful links:

    ----------

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

    Best regards,
    Leon

  2. SChalakov 10,261 Reputation points MVP
    2020-11-03T10:14:16.52+00:00

    Hi,

    from what I see, the UpdateSQLScripts custom action is failoing, because:

    UpdateSQLScripts|DB updation failed|Database updater management pack is not updated

    So maybe the MP Import has failed. Can you please try to Install .NET 3.5 on the management server, and re-run the Update Rollup?

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

  3. SChalakov 10,261 Reputation points MVP
    2020-11-03T10:37:21.33+00:00

    Hi @Сергей Колыбин ,

    It looks like the DB is a big mess. I would definitely recommend you to open a support case with Microsoft, so that they can take a look at what exactly went wrong.
    Just keep in mind that only MS can make changes directly in the DB, otheriwse you are in an "unsupported" scenario.

    Regards,
    Stoyan