IBM Support

Suddenly slow (for example 3 minutes, compared with 10 seconds) to open a Data Entry form (even if only one user active) caused by out of date statistics

Troubleshooting


Problem

User clicks 'Company - Data Entry - Reported Values'. User chooses parameters, and clicks 'open'. There is a long delay (for example 3 minutes). Eventually the data entry form appears (in Excel).

Symptom

Originally (for example at the beginning of the month, before anyone has entered any data) the data entry form opens quickly (for example in 10 seconds). However, after a while (after users have entered data in the form, during the month end process) the problem occurs.

  • For example, it suddenly takes 3 minutes (not 10 seconds) to open the same form.

The problem affects all users, and is reproducible even when only 1 user is on the system.

Example:

In one real-life example, the problem only affects the current period (for example 1601). If the user tries to open a future period (for example 1602) then the form opens quickly (for example 10 seconds).

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","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.

Document Information

Modified date:
08 May 2025

UID

swg21976521

Page Feedback