Troubleshooting
Problem
Message "We can't retrieve the data from data set
Cause
Limitations on the default web server configurations. Web servers impose a limit on the size of the url address and http query string.
- 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
Diagnosing The Problem
Issue does not occur running the dashboard by using the dispatcher URL (http(s)://<servername>:9300/bi)
Issue occurs running the dashboard by using web server URL (http(s)://<web server>:<port>/ibmcognos)
Resolving The Problem
Microsoft IIS
Here are some instructions on how to change or set these limits:
- Open Internet Information Service Manager on the Cognos IIS host located from Control Panel under "Administrative tools" option.
- On the navigation tree to the left, click "Sites/Default Web Site\IBMCognos" and select the "bi" directory.
- Double-click "Request Filtering" and then click "Edit Feature Settings"
- Modify "Maximum URL Length" and "Maximum Query String".
- Test with first one to at least 16000 and the second to at least 8000
- Click ibmcognos virtual directory.
- In the Home view, Management section, double-click Configuration Editor.
- In the Section drop-down list, expand system.web, and select httpRuntime.
- Set the property maxQueryStringLength to 8192.
- Restart IIS
Apache / IBM HTTP Server
Modify the web server httpd.conf and add these two lines.
LimitRequestBody 32000
LimitRequestLine 32000
Restart the web server.
Was this topic helpful?
Document Information
Modified date:
18 August 2022
UID
swg22005274