Taiwan CSS Platform Team

Your Potential, Our Passion.

SCOM Reports are not showing up

SCOM Reports are not showing up

  • Comments 1
  • Likes

PROBLEM:
==========
SCOM Reports are not showing up

image

CAUSE:
=======
The above Event Error 31565 can come if the Column 'TopLevelHostManagedEntityRowId‘ is missing in the ManagedEntity table under OperationsManagerDW database.
This 'TopLevelHostManagedEntityRowId' column is available in Sp1 RTM version of  OperationsManagerDW database, if its lower than Sp1 version then the column will not be there.
Because OperationsManager database is at Sp1 version and OperationsManagerDW database is still at RTM version and not at Sp1 version, the Data transfer is failing and above error is generated.
In some cases if OperationsManagerDW database is created using DBCreateWizard of OpsMgr 2007 RTM Media source and not yet upgraded to OpsMgr 2007 Sp1, then above column will be missing.

SOLUTION:
==========
Upgrade the OperationsManagerDW (OpsMgr 2007 Reporting) database to Sp1 version using OpsMgr 2007 Upgrade wizard and select to upgrade OpsMgr 2007 Reporting component.
Restart all the SQL services on database server and all the 3 services for OpsMgr on RMS server.
After waiting for few minutes, all the reports will be started showing up in Reporting pane of Operations Console fine and also all the reports will start showing data fine.

More Information
============
The above Event Error 31565 can come if the Column 'TopLevelHostManagedEntityRowId‘ is
missing in the ManagedEntity table under OperationsManagerDW database.
This 'TopLevelHostManagedEntityRowId' column is available in Sp1 RTM version of OperationsManagerDW database, if its lower than Sp1 version then the column will not be there.

clip_image003

Comments
  • Windows Server 2003 introduces the ability to restore deleted ("tombstoned") objects. This simple command-line utility enumerates the deleted objects in a domain and gives you the option of restoring each one. Source code is

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment