Good Morning,

I'm working on different Cognos Analytics migration projects,
using different version of target CA (mostly are 11.1.3, 11.1.4, 11.1.5)
but mainly installed on Windows platforms, using IIS as a web server.

We are experiencing a random behavior on some migrated reports, that implement drilling throughs to other reports.
Drill throughs, when clicked, are not executed at all, and user remains on master report, or sometimes is redirected to cognos home page, with no error messages.
After some tests, we verified that there are no error traced into logs,
and that the issue arises mostly when drill-throughs are configured to pass a large amount of parameters (20+).
Simple drill-through, passing no parameters, are always working fine, therefore I'm supposing that issue is related to 'complexity' of drill definition.

As far as we are migrating from Cognos BI 10 , most of our reports have full interactivity disabled, to maintain original layout and to be able to use JavaScript .

Used data sources are various, from DMR models to OLAP cubes.
 
I've searched the on-line technotes and documentation, for any known issue, but find no clue.

Is anybody aware of any known issue in Cognos 11.1.x , about drill-throughs not working properly in some context ?
 
Thanks in advance,


------------------------------
Daniele de Boni
Cognos Specialist
------------------------------

#CognosAnalyticswithWatson

Hello @Daniele de Boni,

you might be hitting the URL maximum length of IIS of 2083 characters?
https://docs.microsoft.com/en-us/iis/configuration/system.webserver/security/requestfiltering/requestlimits/​ 

IE (browser) limit is: 2048 characters.

See for more information:
https://stackoverflow.com/questions/1289585/what-is-apaches-maximum-url-length#:~:text=The%20official%20length%20according%20to,maximum%20URL%20size%20at%202%2C048.&text=Allowed%20default%20size%20of%20URI%20is%208177%20characters%20in%20GET%20request.

Howto test this out?
Copy the not working URL from a Chrome browser to a notepad++ and get a count of characters by marking the url.

We had to shorten parameter names on our reports in the past.


------------------------------
Ralf Roeber
------------------------------

Hi Ralf,

thanks for your suggestions, 
I'll do a check !

Regards,

Daniele

------------------------------
Daniele de Boni
------------------------------

Original Message:
Sent: Mon July 27, 2020 10:07 AM
From: Ralf Roeber
Subject: Drill Through not working in Cognos Analytics

Hello @Daniele de Boni,

you might be hitting the URL maximum length of IIS of 2083 characters?
https://docs.microsoft.com/en-us/iis/configuration/system.webserver/security/requestfiltering/requestlimits/​ 

IE (browser) limit is: 2048 characters.

See for more information:
https://stackoverflow.com/questions/1289585/what-is-apaches-maximum-url-length#:~:text=The%20official%20length%20according%20to,maximum%20URL%20size%20at%202%2C048.&text=Allowed%20default%20size%20of%20URI%20is%208177%20characters%20in%20GET%20request.

Howto test this out?
Copy the not working URL from a Chrome browser to a notepad++ and get a count of characters by marking the url.

We had to shorten parameter names on our reports in the past.


------------------------------
Ralf Roeber
------------------------------

Daniele,

When we upgraded from Cognos 10 to Cognos 11, the upgrade broke some of our drill through functions on reports.  We had to just go into each report and re-point the drill properties.     

Jeanie

------------------------------
Jeanie Krieger
Business Analyst
California State University, Sacramento
Sacramento CA
------------------------------