Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Expand all | Collapse all

SSO with IIS not working in Cognos 11.1.6

  • 1.  SSO with IIS not working in Cognos 11.1.6

    Posted Mon April 27, 2020 10:29 AM
    Edited by System Admin Fri January 20, 2023 04:45 PM
    After Upgrade from Cognos 11.1.5 to Cognos 11.1.6 SSO is not working.

    When accessing the gateway URI with the IIS server and SSO Enabled, the login page will keep on loading forever.

    I have already done a IIS Reset described here :
    https://www.ibm.com/support/pages/webpage-gateway-uri-keeps-loading-forever-iis-server

    With SSO Disabled everything is working fine.

    Can anyone confirm thins behaviour in Cognos 11.1.6?

    Update:
    There is also an error in the cogserver.log
    2020-04-28T11:31:21.548+0200	ERROR	com.ibm.bi.platform.commons.web.BIResponseWrapper	[Default Executor-thread-223]	sGlCjyyv9GyvGvMCyMlMCvv4lhddM9q8Mldw92j2		sGlCjyyv9GyvGvMCyMlMCvv4lhddM9q8Mldw92j2	NA	xx.xx.xx.xx	50663	LoginUser-149614924	NA	/v1/disp/ibmcognos/sso/cisapi/bi/v1/login	user-profile-service	8400	HttpServletResponseCode for /user-profile-service/v1/login is in error: 599


    ------------------------------
    Daniel Dehm
    ------------------------------
    #CognosAnalyticswithWatson


  • 2.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue April 28, 2020 03:13 AM
    Hi Daniel, i had the same issue when my PDF confidentiality algorithm was set to 256bit. Once i set it to 128 everything was working fine with SSO. But be aware that you will need the original files which are with installation for the jurisdiction policy. so if you change them please put the original back.




    ------------------------------
    Stoyka Bojkova
    ------------------------------



  • 3.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue April 28, 2020 05:42 AM
    Hi Stoyka,

    thank you for your reply. The PDF confidentiality algorithm was allready set to 128bit. This Problem occurs only on Cognos 11.1.6, after a revert to Cognos 11.1.5 everything works as it should.


    ------------------------------
    Daniel Dehm
    ------------------------------



  • 4.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue April 28, 2020 06:12 AM
    On my end is working perfectly fine (what you can try is to do the installation again) sometimes it helps ;) install it over and see

    ------------------------------
    Stoyka Bojkova
    ------------------------------



  • 5.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue April 28, 2020 06:49 AM
    Hi, I have already reinstalled and the problem still persists. This is always the first thing I try =)

    ------------------------------
    Daniel Dehm
    ------------------------------



  • 6.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue April 28, 2020 10:21 AM
    Hi
    I had exactly the same problem, ended doing an uninstall and re-install, as well as IIS setup (Deleted the website and Application Pool.)  
    I used the IIS automated script that ships with Cognos.
    After this this it worked fine...

    Not optimal, I know....

    ------------------------------
    Braam Malherbe
    ------------------------------



  • 7.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Wed April 29, 2020 02:08 AM
    Hi Daniel,

    Have you tried to delete the cache in the web browser ?


    Br
    René

    ------------------------------
    René Kent Nielsen
    Solutions Architect
    CogniTech A/S
    Herning
    ------------------------------



  • 8.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Wed April 29, 2020 02:16 AM
    ​Hi Again

    Something else to try, is to enable (if is disabled) Cognos Application Firewall in Configuration Manager.

    Regards

    ------------------------------
    Braam Malherbe
    ------------------------------



  • 9.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Wed April 29, 2020 02:26 AM
    I've already tried the following things:

    Complete einstall
    IIS Reset as described here https://www.ibm.com/support/pages/webpage-gateway-uri-keeps-loading-forever-iis-server
    Delete the browser cache and different browser
    Disable the CAF


    ------------------------------
    Daniel Dehm
    ------------------------------



  • 10.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Sat May 02, 2020 12:37 PM
    I have experienced the same issues as Daniel and tried all the suggested fixes above, it's got to be a bug. It's always pot luck these days when upgrading Cognos and finding out what new bugs have been introduced.
    I'm reverting back to 11.1.5.

    ------------------------------
    Michael Coyle
    ------------------------------



  • 11.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Mon May 04, 2020 10:29 AM

    Hi Daniel,

    IBM is aware of the issue and is working on it. We've seen a number of clients hit this issue and a number of others not. I won't hazard a guess at this point as to the cause of the issue but multiple IIS SSO scenarios were tested inhouse prior to release.

    I would recommend logging a support case and referencing this APAR so you can be kept up to date.
    APAR 147747

    Cheers,
    Trevor

    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 12.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue January 19, 2021 03:28 PM
    IS this problem FIXED ?

    ------------------------------
    Allen Lin
    ------------------------------



  • 13.  RE: SSO with IIS not working in Cognos 11.1.6

    Posted Tue January 19, 2021 04:59 PM
    Yes. This issue was fixed in May of 2020. Either R6 IF1 or R6 IF2 should resolve the issue.

    We have had confirmation from multiple clients that their issue was resolved after installing the IF1, which was the first version with the fix.

    ------------------------------
    TREVOR COMEAU
    ------------------------------