CTGTRV014E The report cannot be successfully formatted because it completed with
errors, reference ID [REPORTID_59_OBJECTID_6bee6bee]. Click on the following link to
view the report with the errors.
Or:
CTGTRV011E See the Tivoli Common Reporting log files for more information.
https://localhost:30343/TCR/Reports/view
After seeing this message, if you click to the link View the report with the errors,
you see this message displayed at the bottom:
ReportDesign (id = 1):
+ Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -802, SQLSTATE: 22003, SQLERRMC: null
Finding the statement SQLSTATE 22003 indicates that you are experiencing a SQL
arithmetic overflow at the Tivoli Data Warehouse database.
To remedy the problem, choose a smaller time period (the recommended action) or
possibly a different metric. This change causes the calculations being performed for
the report to process less data, reducing the chance of overflow.
Note: All occurrences of this failure in the IBM-provided reports were eliminated
by casting DB2 Integer values to DECIMAL(column_name 31,0). This problem should
not occur with IBM-provided reports, but could be an issue in customer-generated
reports.
No data is plotted in graph, or some columns in the table are blank
In this scenario, you complete the report parameters window to generate a report.
After clicking Submit, you see a report where some columns have data and some
do not.
When you check version levels, you find that the version of database manager you
are using for Tivoli Data Warehouse is correct and that it is defined as your data
source and that all the requested columns in the attribute table are available.
However, even though data is displayed in the other columns of this table in Tivoli
Enterprise Portal, no data is available in the column needed to draw the graph.
Historical data sets have been allocated, historical collection has been configured
and enabled , and some data has been collected. Tivoli Common Reporting is
configured and is drawing a partial report. If the report does not meet your needs,
you may be able to obtain the needed data by one of these methods:
v By choosing a different attribute on the Report Parameters window.
v By ensuring that data for the selected attribute is available for this workspace
configuration. For example, the OMEGAMON XE for Mainframe Networks
monitoring agent cannot collect data for some attributes in OSA reports,
depending on how the OSA adapter is configured.
Confirm that the values for these attributes are being displayed in Tivoli Enterprise
Portal. If no data is being collected for a key attribute because of configuration
issues, consult the product manual to see what configuration change would
provide data for the missing attributes.
To determine the cause of this problem you need to enable detailed logging in
Tivoli Common Reporting, as described in the IBM Tivoli Common Reporting: User's
Guide, and you need to know which agent table (or attribute group) contains the
252 IBM Tivoli Monitoring: Troubleshooting Guide
To Next Page
Loading...
Need help?
General
