Problems when running reports

The topics in this section document problems you may encounter when running reports.

Summaries in a report do not correspond to the visible members
If a crosstab or chart created in IBM® Cognos® Analytics - Reporting using a dimensional data source has a context-dependent set function such as filter or topCount on an edge, summaries do not correspond to the visible members.
Crosstab Shows Percentage But Chart Shows Values
When the crosstab calculates the percentage of the total for an item, the chart does not show the values as a percentage.
DPR-ERR-2002 Unable to execute the request because there were no connections to the process
You cannot run a report in IBM Cognos Analytics on premises.
DPR-ERR-2082 The Complete Error Has Been Logged by CAF With SecureErrorID
You cannot run a report.
Data source not found in Content Manager
You cannot retrieve data from the selected database when running a report.
Overflow Error Occurs When a Value in a Crosstab Is More Than 19 Characters
In a crosstab report, values support a maximum of 19 characters, including the decimal point. If a value exceeds 19 digits, an overflow error occurs. By default, the decimal precision is set to 7 digits, which restricts the number of integers to 11 digits.
IBM Cognos Analytics Runs Out of TEMP Space
By default, IBM Cognos Analytics stores temporary files in the install_location/temp directory. The amount of space required by the temporary files directory depends upon several factors, including the number and type of reports created.
A Report Does Not Run as Expected
A report may not run as expected if the model contains errors or the wrong governor settings.
Scheduled Reports Fail
You schedule reports that previously ran successfully, but now fail.
The Table or View Was Not Found in the Dictionary
When you run a report, the following error message appears:
Unable to Select Multiple Report Formats When Running a Report
When running a report with options, you cannot select multiple formats when the delivery option is to view the report.
A report does not run because of missing items
You attempt to run a report and a message indicates that one or more items are missing or changed.
Cannot View Burst Report
When you burst a report, each burst output is sent to the associated list of recipients.
Recursive evaluation error
You run a report and encounter the following error.
Arithmetic Overflow Error When Running a Report in PDF Format
If you use a Microsoft SQL Server 2005 data source and your report includes aggregations, you may encounter the following error when you run your report in PDF format:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-69' UDA-SQL-0043 Error
You cannot run a report in IBM Cognos Analytics - Reporting, and the following error messages appear.
PCA-ERR-0087 error when you run a large report
You run a large report and you receive a PCA-ERR-0087 error that indicates that the report exceeds the maximum number of tuples allowed.
Differences in the appearance of charts that are run in different formats or on different operating systems
IBM Cognos Analytics - Reporting charts can appear differently when reports are run in different formats or on different operating systems. For example, donut and pie charts can appear smaller in reports that are run on the Linux® on System z® operating system compared to the Windows operating system.
Out-of-memory errors with reports that are run in interactive HTML format
Out-of-memory errors occur when you run a report in interactive HTML format. The errors do not occur when you run the report in other formats, such as PDF or saved HTML.
Problems with viewing saved active report output in Mozilla Firefox 8 or later versions
When you try to view saved Active Report output in Mozilla Firefox 8 or later, you receive errors.
Problems with large SAP BW queries
When you are working with an SAP BW data source, if your report includes a data set greater than 1,000,000 cells, you might encounter an XQE error.
Master Detail or Burst Reports with Charts or Crosstabs May Result in Denial of Service
When running a master detail or burst report that includes a chart or crosstab, disk space exhaustion may cause the report or other requests to fail.
Error when filtering on a _make_timestamp column
You cannot filter on a _make_timestamp column. If you do that, the following error messages appear:
Result set of a multi-fact query contains blanks
The result set of a multi-fact query contains blanks in some columns, even though there is a conformed dimension that should join the records from both fact tables.
RSV-SRV-0040 The report server encountered an internal problem
This error message might occur when you run reports in a distributed IBM Cognos Analytics environment.
Single-select prompt is generated where multi-select prompt might be expected
A single-select prompt control is generated for an IN-filter when you run a report, view tabular data in a report, or set prompt values in report properties. Typically, a multi-select prompt control is expected in these report contexts when the IN-filter is used.
XQE-V5-0005 Identifier not found '_row_id' error
You run a report and get error message XQE-V5-0005 Identifier not found '_row_id'. CAF-WRN-2082 An error has occurred. Please contact your administrator..
Scheduled reports fail after password update: CM-REQ-4159 CM-CAM-4005 Unable to authenticate
When you log in to Cognos Analytics and then change your password, previously scheduled reports may fail, while other non-scheduled reports run successfully during the current session.
Dispatcher communication errors, CAF-WRN-2082 and DPR-ERR-2072, when you run a report
When these errors occur, you cannot run a report.

Parent topic: Problems when running, viewing, and printing reports