We can’t retrieve the data from data set

by ·Comments Off on We can’t retrieve the data from data set

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 server

Problem:
After upgrade of Cognos and the IIS gateway settings the large dashboard with many columns does not work. If you use less columns the dashboard work. Error like this:

We can’t retrieve the data from data set….

Solution:
Inside IIS Manager on your Microsoft Windows server, check the values for Maximum URL length.
Go to your ibmcognos\bi folder and click on “request filtering”.

Click on edit feature settings on the right side.
Update to 8192 or 16000. (adjust other values as needed)
Click OK (the values are saved in C:\Program Files\ibm\cognos\analytics\webcontent\bi\web.config)
Restart the IIS service and test again.

The CA_IIS_Config.bat file should set this values in your windows server:

More Information:
https://www.cognoise.com/index.php?topic=34991.0

https://www.ibm.com/support/pages/we-cant-retrieve-data-data-set