question

Birdal avatar image
0 Votes"
Birdal asked ·

SCOM 2019 UR2 installation issue

Hi,

I wanted to install on our first Management Server SCOM 2019 UR2.

Unfortunately it was not successful on the level of "Database Configuration".
18220-scom-ur2-1.png

we have 4 Management Server and our database servers for SCOM DBs are also on different servers.

I looked at the setup log. But it does not have any good information:

MSI (s) (24:E0) [13:09:19:012]: Product: System Center Operations Manager Server - Update 'System Center 2019 Operations Manager Update Rollup 2 Patch' could not be installed. Error code 1603. Additional information is available in the log file C:\Users\myUserID\AppData\Local\Temp\2\KB4558752-AMD64-Server.msp.0.log.

MSI (s) (24:E0) [13:09:19:013]: Windows Installer installed an update. Product Name: System Center Operations Manager Server. Product Version: 10.19.10050.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: System Center 2019 Operations Manager Update Rollup 2 Patch. Installation success or error status: 1603.

MSI (s) (24:E0) [13:09:19:014]: Note: 1: 1729
MSI (s) (24:E0) [13:09:19:014]: Product: System Center Operations Manager Server -- Configuration failed.

MSI (s) (24:E0) [13:09:19:014]: Windows Installer reconfigured the product. Product Name: System Center Operations Manager Server. Product Version: 10.19.10050.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 1603.

Any idea?

Best regards

Birdal


msc-operations-manager-deployment
scom-ur2-1.png (24.8 KiB)
10 |1000 characters needed characters left characters exceeded

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

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

Hi @Birdal,

I think I've encountered the same issue in one of my SCOM 2019 labs, what I did to resolve was to simply restart the SCOM server before attempting to install the Update Rollup 2 patch, normally it's good to restart before to avoid any pending restarts.

It's also important that you run the Update Rollup 2 installer with Run as administrator.


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


Best regards,
Leon

·
10 |1000 characters needed characters left characters exceeded

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

Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,
I started all Management Server and tried UR2 on one MS again.
It is unfortunately failed again.
Best regards
Birdal

· 1 ·
10 |1000 characters needed characters left characters exceeded

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

Which log file did you look at? Did you check the OpsMgrPatchWizard.log located under %LocalAppData%\SCOM\Logs?

0 Votes 0 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,

yes, I checked both OpsMgrPatchWizard.log and also KB4558752-AMD64-Server.msp.0.log.

OpsMgrPatchWizard.log is in the attachment.

Best regards
Birdal18337-opsmgrpatchwizard.txt



· 1 ·
10 |1000 characters needed characters left characters exceeded

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

Not much to go with, in this case I would suggest you to perform the update of the Update Rollup 2 manually, i.e. without the simplified patching (one-click-installer), and check the results.

You'll find the installation order over at the Update Rollup 2 KB article under the Installation instructions for Operations Manager 2019 UR2 section:
https://support.microsoft.com/en-us/help/4558752/update-rollup-2-for-system-center-operations-manager-2019

0 Votes 0 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,
i started / tried UR2 only manually, not one-click. This error occured in this manual process.
As I checked all SCOM Servers on Concole it shows they are not monitored. Interesting is that SCOM Management Server on which I tried to update has now another version than other SCOM servers.
18339-scom-ur2-2.png



Best regards
Birdal


scom-ur2-2.png (17.9 KiB)
· 1 ·
10 |1000 characters needed characters left characters exceeded

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

To make things clear, the error in your first post occurred when attempting to install Update Rollup 2 with the one-click-installer on a SCOM 2019 with Update Rollup 1 environment?

This is the supported installation order:

  1. Management server or servers can be updated by using either the .msp or simplified management server patching user interface (one-click-installer).

  2. Audit Collection Services

  3. Web console server role computers

  4. Gateway

  5. Operations console role computers

  6. Reporting

Since the update failed on the "Database Configuration" step, could you verify if there's an SQL log located here:

  • <SCOM install directory>\Server\SQL Script for Update Rollups\SqlExceptions_{version}.log

0 Votes 0 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Good morning @LeonLaude ,

I understood what you mean with one-click now. I thought if we use the WSUS process which provided SCOM Upgrades also in this month.

Unfortunately there are no .log files under this directory. There are only two sql scripts named update_rollup_mom_db.sql (modified date: 13.07.2020), and UR_Datawarehouse.sql (modified date: 13.07.2020).

Please consider that SCOM DB roles are on different machines, not on Management Server machines.

Best regards
Birdal

· 1 ·
10 |1000 characters needed characters left characters exceeded

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

To really know if an update was successful, navigate to Administration > Operations Manager Products in the SCOM console and check the ‘Version’, ‘Update Installed’ and ‘KB Number’ fields.

The one-click-installer is basically divided into three steps:

  1. Management Server

  2. SQL scripts (Database Configuration)

  3. Management Packs (import management pack updates)

18687-one-click-installer.png

In your case you have successfully updated the management server (please double check the versions first to confirm), this means that the SQL scripts and management pack updates didn't get done successfully.

What I would do is to install the rest manually, follow the update order here:

  1. MS (done)

  2. ACS

  3. Web Console

  4. Gateway

  5. Operations Console

  6. Reporting Server

  7. Apply SQL scripts

  8. Manually import the management packs

  9. Apply Agent Updates

  10. Update Unix/Linux MP’s and Agents

1 Vote 1 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,

Ok, I can go on with updates if Management Server is upgedated successful.
But, how can the databases be updated in this case? In the above list (in MS article) there is no defined update process in operations and datawarehouse databases.

Best regards
Birdal

· 1 ·
10 |1000 characters needed characters left characters exceeded

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

The databases basically get updated with the SQL scripts that you always had to run in the end of installing an Update Rollup (as mentioned in step 7 in the list above).

So if you are familiar with how Update Rollups were previously installed, i.e. manually in the specific order mentioned above, then you can basically continue with that.

0 Votes 0 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,

but where can I download these SQL scripts?
In the MS article, SQL process is not defined: https://support.microsoft.com/en-us/help/4558752/update-rollup-2-for-system-center-operations-manager-2019



Best regards
Birdal

· 1 ·
10 |1000 characters needed characters left characters exceeded

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

In the SCOM installation path on your management servers, there are two (2) SQL script files, one for the Operations Database, and one for the Warehouse Database.
They can be located for example here:

  • %SystemDrive%\Program Files\Microsoft System Center\Operations Manager\Server\SQL Script for Update Rollups

These scripts will only show up once you have applied the management server update, which was the only update that was successful so far in your case.

18792-sql-scripts.png


0 Votes 0 ·
sql-scripts.png (18.9 KiB)
Harry-9614 avatar image
0 Votes"
Harry-9614 answered ·

its a broken update as expected from MS
best no details error wht so ever, digging all the logs.
1st time doing this and yet come w this surprise.

so whts next, step 1 done
step 2, run the db scripts manually. no errors... strange

next step 3, how ...

is this UR2 even passed QA test ??? very doubtful.
nowadays MS quality really drop A LOT!

how can I even automated this installation, too fragile.

· 1 ·
10 |1000 characters needed characters left characters exceeded

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

Hi Harry,
in which MS article is defined that SQL script should be run manually?
Did I missed something?
After UR2 we cannot import any MP into SCOM.
Best regards
Birdal

0 Votes 0 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi @LeonLaude ,
the one-click process of SCOM 2019 UR2 is unfortunately not suitable for SCOM infrastructure which use dedicated SCOM database servers.
After I run all UR2 update process manually it worked well. Thank you for your support.

Now there are two additional steps:
- import new Management Packs of UR2
- update agents

Where can I download the newest MPs for SCOM 2019 UR2? Any download link?
Best regards
Birdal



· 1 ·
10 |1000 characters needed characters left characters exceeded

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

The management packs also renewed once you apply the management server update, you should find the updated management packs which you need to import from the SCOM installation folder, for example::

  • %SystemDrive%\Program Files\Microsoft System Center\Operations Manager\Server\Management Packs for Update Rollups


For the agents, they should be updated on the management servers once the management server patch is applied, you can also download it from here:

1 Vote 1 ·
Birdal avatar image
0 Votes"
Birdal answered ·

Hi Leon,

one important question:
Must be both scripts update_rollup_mom_db.sql and UR_Datawarehouse.sql run on SQL databases related to UR2?

Best regards
Birdal

· 5 ·
10 |1000 characters needed characters left characters exceeded

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

There are two (2) SQL script files, one for the Operations Database (update_rollup_mom_db.sql) and one for the Warehouse Database (UR_ Datawarehouse.sql). Both needs to be run.

0 Votes 0 ·

Hi Leon,
I mean, must I do run manually / explicitly these scripts on SQL servers?
Best regards
Birdal

0 Votes 0 ·

You only need to run the scripts manually once but they need to be run against the Operations Database & Operations Data Warehouse.

0 Votes 0 ·
Show more comments

Hi @Birdal,

if the automatic update did not succeed, then you cannot tell for sure if the scripts have been executed, so running them manually is good idea.
If they have been already run, running them again will not harm your system, so you have noting to lose - just run each script on the DB it is intended for and complete the process.

Regards,
Stoyan

0 Votes 0 ·