IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3

Tivoli Common Reporting troubleshooting

Problems can occur with the Tivoli Common Reporting predefined reports for the Microsoft Cluster Server agent.

Table 1 contains problems and solutions that can occur with the Tivoli Common Reporting predefined reports for IBM Tivoli Composite Application Manager for Microsoft Applications: Microsoft Cluster Server Agent. See the Tivoli Common Reporting Information Center (http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc/tcr_welcome.html) for more information about troubleshooting for the Tivoli Common Reporting tool.

Table 1. Tivoli Common Reporting for Microsoft Cluster Server agent problems and solutions
Problem	Solution
When you simultaneously query two tables in the Query Studio interface, no data is displayed. However, when you query the two tables separately, data is displayed.	This problem occurs when a relationship between the tables is not defined. To resolve this problem, ensure that all the ad hoc queries have at least one identifier.
When you create an ad hoc query by dragging some columns in the Query Studio interface, the following error message is displayed: `RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-232'.`	This is an SQL error related to arithmetic flow. This error is generated because the average or the sum for certain columns is more than the threshold size that is defined in the database. To resolve this error, use the limited columns and add a standard timestamp while creating an ad hoc query.
If a view or a table for the selected summarization type does not exist in the database for a report, the report does not open and the following error message is displayed: `RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'.`	To resolve this problem, complete the following tasks: Verify that the summarization and pruning agent is working correctly. Generate data for all the summarization types. Verify that the warehouse is collecting historical data.
When you run a report, the report is not displayed in the correct format and the following error message is displayed: `RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.`	This problem occurs due to incorrect data source. To resolve this problem, complete the following tasks: Verify that the datasource configuration parameters are configured correctly. Verify that the specified values for the parameters of the summarization and pruning agent such as database URL, driver user, and password match with the values of these parameters on the database.
If data is not available in the database for the selected parameters, the following error message is displayed after querying these parameters: `Empty data set No data returned by query. Try another set of parameters.`	To resolve this error, complete the following tasks: Configure the summarization and pruning agent and verify that it is working correctly. Generate data for all the summarization types in the database.
Reports are not generated correctly in the Microsoft Excel format.	There are some limitations to generate reports in the Microsoft Excel format. To view these limitations, see the IBM Cognos Business Intelligence Information Center (http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/topic/com.ibm.swg.im.cognos.ug_cr_rptstd.10.1.0.doc/ug_cr_rptstd_id32474excel_limitations.html).
When you view a report spanning multiple pages in the PDF format, the report parameters section is displayed at the top of each page.	No solution is available for this problem at this time.
Charts are not displayed correctly in Microsoft Excel 2007.	No solution is available for this problem at this time.
Labels for some charts are displayed in the HTML output, but are not displayed in the PDF output.	The font size is rendered differently in the HTML and the PDF output. In the PDF output, some fonts are not displayed because of the large font size. To resolve this issue, reduce the font size by completing the following steps: Open the report in Report Studio. Click the chart. In the chart properties, select Font. Modify the font properties, such as family, size, weight, and style. Save the settings, and run the report in the PDF format.
If you drag some columns to the report area during an ad hoc query, the following error message is displayed:`UDA-SQL-0115 Inappropriate SQL request.UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Deferred prepare could not be completed.UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180) UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Invalid column name '<column name>'. (SQLSTATE=42S22, SQLERRORCODE=207)`The ad hoc query does not work for the following columns: SUM_Cache_State MIN_Cache_State MAX_Cache_State AVG_Cache_State SUM_Volume_State MIN_Volume_State MAX_Volume_State AVG_Volume_State	No solution is available for this problem at this time.

Feedback