IBM Support

Prompt pages run slowly after upgrading Cognos Analytics

Troubleshooting


Problem

After upgrading Cognos Analytics to a new version, when running reports with prompt pages the prompt pages run much slower than they did in the previous version. For prompt pages that would run in seconds, they now take minutes to run.

Resolving The Problem

This happens because the report specifications were not upgraded. This causes the report spec upgrade task to run every time you run the report, which causes additional overhead and has a performance impact.
To resolve this, the "Report Specification Upgrade Task" may be run.
  1. Log on as an administrator with execute permissions for the Content Administration feature.
  2. Open IBM Cognos Administration.
  3. On the Configuration tab, click Content Administration.
  4. Click the arrow on the new content maintenance button New content maintenance on the toolbar, and then click New Report Upgrade
  5. Type a name for the upgrade task and, if you want, a description and screen tip. Click Next.
  6. Select the packages and locations for the report specification you want to upgrade. Click Next.

    If you upgrade report specifications by package, all reports in the content store that are based on the model in the package will be upgraded. If you upgrade report specifications by folder, all reports in the folder will be upgraded.

  7. Choose one of the following:
    • Save and run once opens the run with options page.
    • Save and schedule opens the scheduling tool.
    • Save only allows you to save the upgrade so that you can run it at a later time.

Related Information

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 November 2019

UID

ibm11104831