Troubleshooting
Problem
User clicks "Reports - Run". User chooses report/paramaters, and clicks "Send to Application". User chooses to send to Excel. Excel opens in the background, and the report may appear to start running. However, it never seems to finish.
Problem only affects one/some reports.
Symptom
The symptom varies slightly depending on client device environment:
Client device #1
In one real-life customer client PC environment, after clicking "Send to Application", Excel freezes. User has to eventually give up (by using Windows task manager to close Excel).
Client device #2
Using the same database/report, but a different client PC, user finds that the report starts running, but gets stuck in the "Fetching values, please wait..." stage. That status never changes (the report never finishes).
Client device #3
After sending the 'bad' report to Excel:
- Microsoft Excel appears
- It starts opening/refreshing that report
- At the bottom-left, user sees "Fetching values, please wait..."
- MOST CURIOUSLY it then seems to spend approximately a second or so updating a single row at a time
- You can actually see it building the report (one row of cells at a time)
- The report did eventually finish (after approximately 11-15 minutes).
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
ibm10967199