IBM Support

Dashboard upgrade errors. Widgets in dashboards show 'We can't retrieve the data from data set'

Troubleshooting


Problem

Dashboard upgrade errors.  Dashboards from Cognos 11.2 moved to 11.2.1.  All the dashboards are no longer running. Each widget is showing the error message "We can't retrieve the data from the data set" followed by the data module name.  Creating a new dashboard with crosstab, has an error saying "We can't load this visualization"

Cause

  • Restriction in the total size of the HTTP request body sent from the client
  • Limitation of the size of the HTTP request line that is accepted from the client

Environment

  • Windows Server 2016
  • Apache webserver

Diagnosing The Problem

Use the application URL to bypass the gateway.  Using the dispatcher URL isolates the issue to either the dispatcher or the gateway.

Resolving The Problem

Adding the following 2 lines to the Apache httpd.conf file resolves the matter.

  • LimitRequestBody 32000
  • LimitRequestLine 32000
If the error persists, increase the value and restart the webserver

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6iAAC","label":"Installation and Configuration->Gateway"}],"ARM Case Number":"TS007644516","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.2.1"}]

Document Information

Modified date:
14 December 2021

UID

ibm16525236

Page Feedback