Microsoft KB Archive/942865

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

Article ID: 942865

Article Last Modified on 10/10/2007

-

APPLIES TO


 * Microsoft System Center Operations Manager 2007

-



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:

Time:

User: N/A

Computer:

Description: A Bind Data Source in Management Group  has posted items to the workflow, but has not received a response in   seconds. This indicates a performance or functional problem with the workflow. Workflow Id : Microsoft.SystemCenter.DataWarehouse.CollectEntityHealthStateChange Instance :  Instance Id : Event Type: Warning

Event Source: Health Service Modules

Event Category: None

Event ID: 11411

Date:

Time:

User: N/A

Computer:

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 &quot;Symptoms&quot; 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.</li> 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 &quot;Resolution&quot; 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 &quot;Resolution&quot; section.</li></ol>

<div class="resolution_section">

RESOLUTION
To resolve this problem, follow these steps: <ol> On the data warehouse database server, start the Microsoft SQL Server Management Studio program.</li> 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.</li> Type the following query, and then press F5 to run the query:

EXEC MemberDatabaseAttach ' \ ', ' ', 1, 1, 1

Note In this query, replace \  with one of the following:  If you do not use the default instance of SQL Server, replace \  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 \  with DWServer\Instance-1.</li> If you use a default instance of SQL Server, replace \  with only the NetBIOS name of the computer. For example, replace \  with DWServer.</li></ul> </li> 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

</li></ol>

If the table is updated successfully, one row is returned in the query results. For example, the query results may resemble the following.

Note After you follow these steps, several Event ID 31544 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.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kberrmsg kbtshoot kbprb KB942865

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.