This section contains problems that might occur when you work with Cognos® reports.
If you drag certain columns in an ad hoc query and it returns an arithmetic overflow error, switch to preview with limited data or to preview with no data and add Standard Timestamp to the query.
Certain columns might average or sum up to a number that is larger than the size supported by the database. So the SQL error of arithmetic overflow is returned. If you see the data by hourly timestamp or daily timestamp, or set a query to limit the data, the aggregated value is forced to be within the supported size.
The No data available message is displayed in an ad hoc querying on two tables, but the resulting data indicates that the two tables are queried.
This error occurs because there is no relationship defined between the two tables. Make sure all your ad hoc queries have at least one identifier.
Make sure that all the prerequisites are met and the warehouse is collecting historical data. If you enable historical data collection appropriately, you are able to use the data model for WebSphere® Message Broker Monitoring agent.
If you have all the required tables but still get this error, it might be because the WebSphere Message Broker Monitoring agent is not compatible with the version that is used in the generic model.
To check the query that runs, open the report in the Report Studio. Click
. The queries in the report are displayed. You can view the native SQL.If the table schema that you use is not ITMUser, use the framework manager to update the schema to what you used.
If the managed system node name that is related to a broker is changed, duplicate broker names might exist in the Broker Name field on the Parameter Selection page. This is because the node name change affect the data correlation. The data for the same broker is not correlated for together until after the old node name has rolled out of the warehouse over time.
To distinguish the duplicated broker names, edit the report in the report studio to change the Display Value property of the Broker Name parameter to Origin Node on the Parameter Selection page.