Thursday, November 20, 2008

SCOM R2 Beta & upgrading existing SCOM SP1 Reporting component

When one upgrades an existing SCOM SP1 installation to R2 and this installation already has the reportingfunctionality installed, this component must be seperately upgraded. Otherwise the eventlog of OpsMgr will show these two events:
Event Type: Error
Event Source: Health Service Modules
Event Category: Data Warehouse
Event ID: 31565
Date: 20-11-2008
Time: xx:xx:xx
User: N/A
Computer: blah
Description:
Failed to deploy Data Warehouse component. The operation will be retried.Exception 'SqlScriptException': Batch ordinal: 5; Exception: Invalid column name 'SchemaName'.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component
Instance name: xxxx.xxxx.local
Instance ID: {DB2FC0CC-CC92-834B-6C5A-387AB914C800}
Management group: xxxx
and
Event Type: Error
Event Source: HealthService
Event Category: Health Service
Event ID: 1108
Date: 20-11-2008
Time: xx:xx:xx
User: N/A
Computer: blah
Description:
Secure Reference Override with id:"{63B43DA7-B8B1-6BBB-7EC0-2DC564855F6E}" requesting credentials identified by SSID:"007341DBB34FB8216AFD79D1C51874024D79A41F4100000000000000000000000000000000000000" cannot be resolved while loading configuration for instance "tempdb" with id:"{F142C30D-F3FC-AA12-9DF4-A5010B5E6A80}" in management group "xxxx".
This issue is similar to the upgrade from SCOM RTM to SP1. For this upgrade the Datawarehouse database had to be upgraded seperately as well.

Just start the setup of SCOM R2 again and select now 'Install Operations Manager 2007 R2 Reporting'. This setup will start the Operations Manager 2007 R2 Reporting Setup Upgrade Wizard. Just follow the onscreen instructions and take a cup of coffee since - based on the size of the database - it can take a while. Afterwards (a succesful upgrade that is) the earlier mentioned events are gone and SCOM R2 will show the newly added reports in its reportingpane.

2 comments:

Marius said...

check my blog at http://blogs.msdn.com/mariussutara in near future for a tool that may help to resolve "Secure Reference Override" alert ...

Marnix Wolf said...

Hi Marius.

Thanks for your comment. I will certainly keep an eye on your blog since it contains valuable information. Even better, I will add your blog to the blogroll of my blog.

Best regards,
Marnix