Error message when you try to generate a report in System Center Operations Manager 2007: Cannot initialize report

SYMPTOMS

When you run Microsoft System Center Operations Manager 2007, you experience the following symptoms:
When you try to generate a report by using a link in a view in the Operations Manager 2007 Operations Console, you receive the following error message:
Application: System Center Operations Manager 2007
Application Version: 6.0.5000.0
Severity: Error
Message: Cannot initialize report.

Microsoft.Reporting.WinForms.ReportServerException: The item
'/Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWar
ehouse.Report.Alert' cannot be found. (rsItemNotFound)
at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at
Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterB lock.Initialize(ServerReport serverReport) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Objec t sender, ConsoleJobEventArgs args)
When you try to view a report by using the Reporting node in the Operations Manager 2007 Operations Console, no unpublished reports appear.
The following events may be logged in the Operations Manager log on the management server.
Event Type: Warning
Event Source: HealthService
Event Category: None
Event ID: 2115
Date: date
Time: time
User: N/A
Computer: ComputerName
Description: A Bind Data Source in Management Group ManagementGroupName has posted items to the workflow, but has not received a response in NNNN seconds. This indicates a performance or functional problem with the workflow. Workflow Id : Microsoft.SystemCenter.DataWarehouse.CollectEntityHealthStateChange Instance : FQDN Instance Id : GUID

Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 11411
Date: date
Time: time
User: N/A
Computer: ComputerName
Description: Alert subscription data source module encountered alert subscriptions that were waiting for a long time to receive an acknowledgement. Alert subscription ruleid, Alert subscription query low watermark, Alert subscription query high watermark:

Note Event ID 11411 is logged every 10 minutes.

CAUSE
This problem occurs if the data warehouse database was created by using the DBCreateWizard tool. The DBCreateWizard tool is located on the Microsoft System Center Operations Manager 2007 media.

To determine whether you experience the problem that is described in the "Symptoms" section, follow these steps:
On the data warehouse database server, start the Microsoft SQL Server Management Studio program.
Click New Query, and then click OperationsManagerDW in the list that appears in the standard toolbar.

Note If the database that houses the data warehouse is not OperationsManagerDW, click the appropriate database.
Type the following query, and then press F5 to run the query:
Select * from MemberDatabase
Note This query is used to determine whether required information is missing from the database.
Examine the results that are returned.

If this query returns no rows in the query results, you are experiencing the problem that is described in this article. In this scenario, continue to the "Resolution" section.

If this query returns rows in the query results, and if the server name is returned in the query results, you are not experiencing the problem that is described in this article. Instead, you may be experiencing a SQL Server permissions-related issue. In this scenario, do not follow the steps in the "Resolution" section.

RESOLUTION
To resolve this problem, follow these steps:
On the data warehouse database server, start the Microsoft SQL Server Management Studio program.
Click New Query, and then click OperationsManagerDW in the list that appears in the standard toolbar.

Note If the database that houses the data warehouse is not OperationsManagerDW, click the appropriate database.
Type the following query, and then press F5 to run the query:
EXEC MemberDatabaseAttach 'dbserver\instanceName', 'datawarehouseDBname', 1, 1, 1


Note In this query, replace dbserver\instancename with one of the following:
If you do not use the default instance of SQL Server, replace dbserver\instancename with the NetBIOS name of the computer that is running SQL Server together with the name of the instance of SQL Server. For example, replace dbserver\instancename with DWServer\Instance-1.
If you use a default instance of SQL Server, replace dbserver\instancename with only the NetBIOS name of the computer. For example, replace dbserver\instancename with DWServer.
To verify that the table has been updated successfully, delete the contents of the query window, type the following query, and then press F5 to run the query:
Select * from MemberDatabase
If the table is updated successfully, one row is returned in the query results. For example, the query results may resemble the following.
Collapse this tableExpand this table
MemberDatabaseRowId ServerName DatabaseName MasterDatabaseInd DefaultDatabaseInd ComponentAutoDeploymentAllowedInd MasterDatabaseReferenceServerName MasterDatabaseReferenceDatabaseName
DWServer OperationsManagerDW 1 1 1 NULL NULL

Note After you follow these steps, several Event ID 31554 events may be logged in the Operations Manager log on the management server. These events have the following Description information:

Workflow succeeded storing data in the Data Warehouse.