This is one of feature everyone is going to love it. UR1 having a friction-less way of patching the SCOM management server. The improvised user interface will guide you through the installation steps which will patch the management server, update both the databases (Operations DB and Data Warehouse) and update the management packs.

Once I had got to know about this, one thing was come to my mind how it will update the SQL scripts without having any access to SQL databases.

Finally I am able to figure it out.

Please note, the tasks which are running might fails due to the following reasons.

 

  1. SQL broker service is disabled. 
  2. We are not able to connect to the SQL databases.

 

Before we will run the self-extracting executable, please make sure we have the following prerequisites met.

  1. SQL broker service is enable.
  2. We are able to connect to the SQL databases.

KBXXXXXX-AMD64-Server.exe is actually contains a management pack named “Microsoft.SystemCenter.DBUpdateTask” which got imported during the Simplified SCOM 2019 Management Server Patching experience.

Firstly it will connect to the management group and import the above management pack.

Now in this management pack, we have two tasks like below.

 

 <Task ID="DatawarehouseUpdateTask" Accessibility="Public" Enabled="true" Target="SC!Microsoft.SystemCenter.ManagementServer" Timeout="1800" Remotable="true">
<Category>Custom</Category>
<WriteAction ID="WA" RunAs="MSDL!Microsoft.SystemCenter.DataWarehouse.ActionAccount" TypeID="DBUpdateWA">
<Instance />
<dbName />
<version />
<dbFilePath />
<timeout />
</WriteAction>
</Task>
<Task ID="DatabaseUpdateTask" Accessibility="Public" Enabled="true" Target="SC!Microsoft.SystemCenter.ManagementServer" Timeout="1800" Remotable="true">
<Category>Custom</Category>
<WriteAction ID="WA" RunAs="SC!Microsoft.SystemCenter.DatabaseWriteActionAccount" TypeID="DBUpdateWA">
<Instance />
<dbName />
<version />
<dbFilePath />
<timeout />
</WriteAction>
</Task>

 

Now I will discuss how it works.

Both the tasks are targeted to “SC!Microsoft.SystemCenter.ManagementServer“.

For Operations Manager DB update, Task “DatabaseUpdateTask” will be running by run as profiles called “Operational Database Account” (it will use the associated run as account to run the task) which is defined and execute the script from the location we got for the variable “dbFilePath override value” (default location is C:\Program Files\System Center\Operations Manager\Server\SQL Script for Update Rollups\update_rollup_mom_db.sql)

 

For Operations Manager DW update, Task “DatawarehouseUpdateTask” will be running by run as profiles called “Data Warehouse Account” (it will use the associated run as account to run the task) and execute the script from the location we got for the variable “dbFilePath override value” (default location is C:\Program Files\System Center\Operations Manager\Server\SQL Script for Update Rollups\UR_Datawarehouse.sql)

 

Management pack import task is being called by a custom action called “CAManaged!Microsoft.MOMv3.Setup.MOMv3ManagedCAs.ImportManagementPacksFromPatch”

This task is actually present on the .exe which will create a temporary directory in C:\windows\Installer location.

Here, we have a config file called “CustomAction.config” which is having customActions defined. These are controlled by some of the dll files.

The custom action “CAManaged!Microsoft.MOMv3.Setup.MOMv3ManagedCAs.ImportManagementPacksFromPatch” connect to management group first and then started importing the management pack from the mpDirectory ((default location is C:\Program Files\System Center\Operations Manager\Server\Management Packs for Update Rollups).

45 thoughts on “How Simplified SCOM 2019 Management Server Patching Experience update SQL Scripts and Management packs”

  1. A person essentially help to make seriously posts I’d state.

    That is the very first time I frequented your web page
    and to this point? I amazed with the research you made to
    create this particular put up amazing. Wonderful activity!

  2. hello!,I really like your writing so a lot! percentage we
    communicate more about your article on AOL? I need an expert
    on this house to unravel my problem. Maybe that’s you! Taking
    a look ahead to peer you.

  3. I simply couldn’t go away your web site before suggesting that I actually loved the standard info a person provide on your guests?
    Is going to be again often to investigate cross-check
    new posts

  4. you’re in reality a good webmaster. The website loading speed is amazing.
    It seems that you are doing any distinctive trick.
    In addition, The contents are masterpiece.
    you’ve done a excellent task in this topic!

  5. Howdy! This post couldn’t be written any better! Reading through this post reminds me of
    my good old room mate! He always kept talking about this.
    I will forward this article to him. Pretty sure he will have a good
    read. Many thanks for sharing!

  6. I am not sure where you’re getting your information, but great topic.
    I needs to spend some time learning more or understanding more.
    Thanks for magnificent info I was looking for this info for my mission.

  7. Excellent pieces. Keep writing such kind of information on your page.
    Im really impressed by your site.
    Hey there, You’ve done a great job. I will definitely digg it and personally suggest to my friends.

    I’m sure they’ll be benefited from this web site.

  8. I do trust all the concepts you have offered on your post. They are very convincing and will definitely work. Still, the posts are very brief for beginners. May you please extend them a little from subsequent time? Thanks for the post.

  9. Hello there I am so grateful I found your website, I
    really found you by accident, while I was searching on Aol for something else, Regardless
    I am here now and would just like to say thanks a lot for a remarkable post
    and a all round entertaining blog (I also love the theme/design), I don’t have time to read through it
    all at the moment but I have bookmarked it and also added in your
    RSS feeds, so when I have time I will be back
    to read more, Please do keep up the awesome jo.

  10. Wow, awesome blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your
    web site is great, as well as the content!

  11. Wonderful article! That is the kind of information that are meant to be shared around the
    internet. Disgrace on Google for now not positioning this submit
    upper! Come on over and visit my site . Thank you =)

  12. My brother suggested I may like this web site.
    He used to be entirely right. This publish actually made my day.
    You cann’t consider simply how so much time
    I had spent for this info! Thank you!

  13. Nice post. I was checking constantly this blog and I’m impressed!
    Extremely useful information specifically the last part 🙂 I care for such information a lot.
    I was looking for this certain information for a very long time.

    Thank you and best of luck.

  14. I need to to thank you for this very good read!!
    I absolutely enjoyed every little bit of it. I have got you bookmarked to look at new
    things you post…

  15. Oh my goodness! Awesome article dude! Thank you so much, However I am having troubles with your RSS.
    I don’t understand the reason why I can’t subscribe to it.

    Is there anyone else having the same RSS issues?
    Anybody who knows the solution will you kindly
    respond? Thanx!!

  16. I don’t even understand how I finished up right here,
    however I thought this submit was once great.
    I do not understand who you are however definitely you
    are going to a well-known blogger when you are not already.

    Cheers!

  17. I’m really enjoying the design and layout of your website.
    It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a
    designer to create your theme? Excellent work!

  18. Hello! I simply want to give you a huge thumbs up for your excellent
    info you’ve got right here on this post. I will be coming back to your blog for more soon.

  19. Thanks for finally talking about > How Simplified SCOM 2019 Management
    Server Patching Experience update SQL Scripts and Management packs < Liked it!

Leave a Reply

Your email address will not be published. Required fields are marked *