Problems Running Reports
The topics in this section document problems you may
encounter when viewing or running reports.
- Report Runs Slowly
The following is a list of questions that will help you to troubleshoot a slow report. - Summaries in a report do not correspond to the visible members
If a crosstab or chart created in IBM® Cognos® Report Studio 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. - Cannot Find the Database in the Content Store (Error QE-DEF-0288)
You cannot retrieve data from the selected database when running a report from IBM Cognos Query Studio, IBM Cognos Connection, or Report Studio. - Parse Errors When Opening or Running an Upgraded Report
Earlier versions of ReportNet and IBM Cognos Business Intelligence included the cast_Date function for reports that run on an Oracle database. This function does not exist for Oracle in IBM Cognos 8.1.2 MR1 and later versions. If a report that uses an Oracle database includes the cast_Date function, parse errors will be received when you try to open or run the 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. - The ORA-00907 Error Appears When Running a Report
When using an Oracle 9.2 data source, under certain circumstances, multiple or nested join operations may fail and produce the following error. - A Report or Analysis Does Not Run Because of Missing Items
You attempt to run a report or analysis and a message indicates that one or more items are missing or changed. Each missing item is listed by its MUN (member unique name). The MUN includes the complete path within the hierarchy for the item. When you place your cursor on an item in the Source tab
, the MUN for that
item is displayed in a tooltip. This situation may occur if members
have been removed from or changed in the data source. It may also
occur when you attempt to run a report that uses items to which you
do not have access. For example, an administrator may create an analysis
that includes items that you do not have the correct permission to
access. - Cannot View Burst Report
When you burst a report, each burst output is sent to the associated list of recipients. - A report upgraded from ReportNet does not retain its original look
When you upgrade a report to IBM Cognos Business Intelligence, a new style sheet is applied that changes the look of the report. - Measure Format Disappears in SSAS 2005
Microsoft SQL Server 2005 Analysis Services (SSAS) does not propagate formatting through calculations. IBM Cognos compensates for this whenever possible, but cannot guarantee to do so in all cases. As a result, if you are working with a Microsoft SSAS cube, any calculation (other than a non-count summary) that is based on or intersects with a formatted measure, such as a currency, may lose the measure format. This may also happen if you use a detail filter or context filter (slicer). - Drill-through Links are Not Active in the Safari Browser
When viewing a PDF report in the Macintosh Safari browser, you cannot open hyperlinks. This is because the Macintosh Safari browser does not have the necessary Adobe Acrobat plug-in. - Data Does Not Appear in a Target Report or the Wrong Data Appears
If no data appears when you drill through to a target report or if the wrong data appears, the problem might be data source conformance. The business keys might be different or might be mismatched. - A Running Total in Grouped Reports Gives Unexpected Results
You have a running total calculation in a grouped report that returns unexpected values. - 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 Report Studio or IBM Cognos Query Studio, and the following error messages appear. - Unable to View Active Reports in Mozilla Firefox
When you try to view an active report in the Mozilla Firefox browser, you may see a blank page or the following message. - 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. The problem also occurs when you try to insert a saved active report in a workspace in IBM Cognos Workspace. - 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. A large set of burst keys or master rows may produce one or more charts per detail, resulting in many master detail executions. This may cause the temp folder to accumulate many gigabytes of temporary files containing data required for successful chart rendering. - 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 Report Studio 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. - Charts in PDF Output Show Unexpected Results
Charts, when viewed in PDF output, have different levels of interaction support, depending on the version of Adobe Acrobat Reader and the style of chart element. - 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. - Cognos Statistics object is not displayed in a report
An IBM Cognos Statistics object is not displayed in a report. - Maps are missing when a report is run in IBM Cognos BI 10.2.2 or later
When a report that was created in IBM Cognos BI 10.2.1.1 or earlier, and contains maps, is run in IBM Cognos BI 10.2.2 or later, the maps are missing.
Parent topic: Troubleshooting