OpsMgr 2007: No reports are listed under the Reporting pane in the Operations Console

  • Article

Here's a problem we run into every now and again that I thought you'd be interested in reading about.  It's not super common but just in case you see it, now you'll know how to fix it.

========

PROBLEM: After the installation of System Center Operations Manager 2007 Reporting, no reports are listed under the Reporting pane in the Operations Console.

In the Operations Manager Event log of the RMS you may also see the following event:

Event Type: Error
Event Source: Health Service Modules
Event Category: Data Warehouse
Event ID: 31565
Description: Failed to deploy Data Warehouse component. The operation will be retried.
Exception 'SqlScriptException': Batch ordinal: 45; Exception: Invalid column name 'TopLevelHostManagedEntityRowId'.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component
Instance name: Instance ID: {051D9268-58DA-7CB9-CBEA-D05B4A58EA11}
Management group:

For more information, see Help and Support Center at https://go.microsoft.com/fwlink/events.asp.

CAUSE: The above Event Error 31565 can occur if the OperationsManager database is at SP1 and the OperationsManagerDW database is still at the RTM version. If this happens, the column 'TopLevelHostManagedEntityRowId' is missing in the ManagedEntity table under OperationsManagerDW database. This 'TopLevelHostManagedEntityRowId' column is available in Service Pack 1 but previous versions will not have it. This causes the Data transfers to fail and the above error to be generated. In some cases if the OperationsManagerDW database is created using DBCreateWizard in OpsMgr 2007 RTM Media source and not upgraded to OpsMgr 2007 SP1 then the above column will be missing.

RESOLUTION: Upgrade the OperationsManagerDW (OpsMgr 2007 Reporting) database to SP1using the OpsMgr 2007 Upgrade wizard and select to upgrade the OpsMgr 2007 Reporting component. Once this is done, restart all the SQL services on the database server and all three services for OpsMgr on the RMS server. After a few minutes, all of the reports will begin showing up in the Reporting pane of the Operations Console.

========

Hope this helps,

Milan Jajal | Manageability Support Engineer