COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: PolzovatelCognos on 03 May 2011 08:35:19 AM

Title: CAF + CSV reports?
Post by: PolzovatelCognos on 03 May 2011 08:35:19 AM
We encounter the following error when CAF (the IBM Cognos Application Firewall in the Cognos Configuration settings) is set to True (Enabled):
When reports are run in the CSV format or are exported to CSV, an HTTP 400 Bad Request error is generated (with "the webpage cannot be found). All other file formats (PDF, HTML, Excel) work just fine.

With CAF then disabled, running reports in the CSV format works just fine.

Due to security reasons, we would like to have CAF enabled. However, there is also a need to have the ability to run/export reports as CSV. We are on IBM Cognos 8.4.1.

Any suggestions/experiences?
Title: Re: CAF + CSV reports?
Post by: PolzovatelCognos on 03 May 2011 08:45:56 AM
Actually, we just found the following IBM article and are going to try to make the suggested registry change:
https://www-304.ibm.com/support/docview.wss?uid=swg21388375

Cause: IIS 6.0/ II 7 Max URL Length Limit or URLscan max URL Limit
Resolution: On the IIS webserver - In Registry:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters

Add :
DWORD Value Name ="UrlSegmentMaxLength"
Value Data (as hex) ="00000200" which is 512 characters.

Hopefully this will resolve the issue. Thanks.
Title: Re: CAF + CSV reports?
Post by: PolzovatelCognos on 03 May 2011 08:53:42 AM
That actually fixed it. Guess I answered my own question. :)