Share via

SCOM 2019 UR2 Error DB Scripts not installed

Сергей Колыбин 1 Reputation point
Oct 30, 2020, 11:09 PM

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,521 questions
0 comments No comments
{count} votes

3 answers

Sort by: Newest
  1. SChalakov 10,571 Reputation points MVP
    Nov 3, 2020, 10:37 AM

    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


  2. SChalakov 10,571 Reputation points MVP
    Nov 3, 2020, 10:14 AM

    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. Leon Laude 85,861 Reputation points
    Oct 31, 2020, 9:04 AM

    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.