Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Expand all | Collapse all

PAfE keeps asking for Login

  • 1.  PAfE keeps asking for Login

    Posted 12/23/21 06:47 AM
    Hello,

    We are using PAfE 2.0.69.

    We have the following issue:

    • A user opens Excel and logs into PAW.
    • He\She then tries to change a filter (SUBNM) and an empty element selection window pops up:
    • The user closes this window and tries again. Now a login screen appears instead of the element selection. Remember the user is already logged in:
    • After logging in for the second time the white window appears again:
    • Continue with step 3. This is essentially an endless loop of logging in and being logged out.
    This happens for all users. The login window also always appears when inputting data or spreading. After having logged in for the Nth time still nothing works.

    Our current workaround is having IE open in the background. When at least one IE window is open everything works as expected. Our current guess therefore is that the session data gets deleted from the Addin as soon as all IE Windows are closed. This would align with our observations.

    We have already checked the IE settings and Cookies should be persisted. At least we have not found a setting saying otherwise.

    I hope somebody here has an idea about how to approach this issue.

    ------------------------------
    Constantin Budin
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAfE keeps asking for Login

    Posted 12/23/21 11:27 AM
    Have you had a look at the logs in PAX, should be located here
    C:\Users\<UserName>\AppData\Local\Cognos\Office Connection\Logs

    Should hopefully give some more information. Also what version of excel does the user have?
    If it's office 365 I'd also check that "Optimise for Compatibility" is set, you can find this within Excel option under General. (If it isn't set, set it and see if the issue still occurs)

    Has this issue always happened? If not go through what may have changed. Perhaps an update to PAX. Perhaps the anti-virus is going haywire, with all the patches going on with log4j at the moment, it would surprise me if this hasn't been updated recently. I've even seen a company's anti-virus deleting the .xll file for PAX because it thought it was a rogue file.

    ------------------------------
    Simon Saul
    ------------------------------



  • 3.  RE: PAfE keeps asking for Login

    Posted 01/10/22 02:58 AM
    Hello,

    unfortunately we do not see anything significant inside the logs except the message that the cookie is not valid or cannot be found. The mentioned setting is also enabled. 

    The issue appeared after updating to PAfE 2.0.69. With older versions everything worked as expected. As for the AntiVirus: This seems highly unlikely as everything works as long as an IE window is open in the background. This indicates to me that somehow the cookie cache is not persisted when all IE windows close.


    ------------------------------
    Constantin Budin
    ------------------------------



  • 4.  RE: PAfE keeps asking for Login

    Posted 01/10/22 04:49 AM
    Is this behaviour occurring for all users? When did the behaviour start, after upgrading PAX, following windows update?
    The message and the temporary solution are related, PAX has a dependency on IE for authentication.

    Do you have SSO, have you tried disabling it and does it still occur?

    I think I recall seeing this issue before on, but I can't recall the details, I'll try and dig into the memory banks :)

    ------------------------------
    Simon Saul
    ------------------------------



  • 5.  RE: PAfE keeps asking for Login

    Posted 01/10/22 05:17 AM
    Edited by System Admin 01/20/23 04:23 PM
    This happens for all users and after upgrading to PAfE 2.0.69. from PAfE 2.0.66.
    SSO is used, but the issue still persists with user and password login.

    Thank you very much!

    (We have also already opened a ticket with IBM)

    ------------------------------
    Constantin Budin
    ------------------------------



  • 6.  RE: PAfE keeps asking for Login

    Posted 01/10/22 05:49 AM
    Edited by System Admin 01/20/23 04:37 PM

    Hi Constantin,

    It feels like something to do with cookies which I know you mentioned you cleared etc. But throwing out some ideas just in case.

    1) Site Privace Actions - have you added your site to the list?


    2) Advanced Privacy Settings - Have you configured per below?


    3) After clearing the cache, cookies etc do you have any cookies left in %LocalAppData%\\Microsoft\Windows\INetCache?

    4) Assuming you have just cleared and no cookies persist. If you log into PAfE, does the cookie:<user>@login.ibm.com get created?

    Let us know on the above. May give insight where someone has an answer.


    Edit: Also check that nothing is kept in %LocalAppData%\\Microsoft\Windows\INetCookies.

    ------------------------------
    George Tonkin
    ------------------------------



  • 7.  RE: PAfE keeps asking for Login

    Posted 01/10/22 05:59 AM
    Hello,

    1) We can't add the affected site to this list, since IE thinks it is an invalid domain. However this should not be the issue, since the same settings work for other customers of ours.
    2) The settings are set accordingly
    3) No cookies remain.
    4)This cookie never gets created at least not in this folder. 


    ------------------------------
    Constantin Budin
    ------------------------------



  • 8.  RE: PAfE keeps asking for Login

    Posted 01/10/22 06:25 AM
    Shell:Cookies in the IE address bar should take you to the relevant folder.

    Perhaps the customer has some sort of Group Policy that prevents the creation of cookies (possibly 3rd party) or changing privacy settings?

    ------------------------------
    George Tonkin
    ------------------------------



  • 9.  RE: PAfE keeps asking for Login

    Posted 01/10/22 06:33 AM
    I will ask about the group policy, but this seems unlikely as other cookies are still created.

    ------------------------------
    Constantin Budin
    ------------------------------



  • 10.  RE: PAfE keeps asking for Login

    Posted 01/10/22 09:07 AM
    Some other things to try
    • Since moving to pafe 2.0.69 and getting this error, have you tried moving a user back to pafe 2.0.66 and seeing if it still occurs?
    • Have you tried installing pafe 2.0.69 onto a machine that's never had pafe installed before, and does it still error then?
    If both 2.0.66 and 2.0.69 are getting the error both an existing and new machines, as George says, I suspect the cookie is being blocked.

    ------------------------------
    Simon Saul
    ------------------------------



  • 11.  RE: PAfE keeps asking for Login

    Posted 01/10/22 09:12 AM
    Also have you tried deleting/renaming the office connection folder and letting it recreate when opening pax
    C:\Users\<UserName>\AppData\Local\Cognos\Office Connection

    I don't see how this would impact it, but wouldn't hurt to try.

    ------------------------------
    Simon Saul
    ------------------------------



  • 12.  RE: PAfE keeps asking for Login

    Posted 01/11/22 03:13 AM
    Unfortunately deleting this folder did not change a thing.

    ------------------------------
    Constantin Budin
    ------------------------------



  • 13.  RE: PAfE keeps asking for Login

    Posted 01/11/22 03:12 AM
    When reverting back to 2.0.66 the cookie is created in the IE cache and everything works. So something must have changed in 2.0.69 to break things. What is interesting: The cookies appear to be stored in a deprecated place with 2.0.66:



    ------------------------------
    Constantin Budin
    ------------------------------



  • 14.  RE: PAfE keeps asking for Login

    Posted 01/11/22 05:29 PM
    Hmm vary perculiar. I know it's a pain, but I think it might be worth testing other versions of Pax
    2.0.67
    2.0.68
    2.0.70

    Also about the behaviour that causes the logout. When trying to change the filter subnm, I take it you mean tries to go into the subset editor.

    Does the error occur when opening views or amending subsets from other dimensions.

    I while back I had a client whose Paw kept crashing because of a particular "forbidden" characters had been populated in a text attribute. 

    Does the subset editor also work fine in Paw through Edge/chrome etc..  With ie closed

    Does the client have any file monitoring tools they could use to track file activity whilst the is replicated, perhaps that might show something. 

    Have you tried switching the model to security mode 1 (native tm1 authentication) and seeing if this is indeed a cookie related issue. 

    It sure sounds like a dozy of a problem. And I hope some of these ideas help.

    ------------------------------
    Simon Saul
    ------------------------------



  • 15.  RE: PAfE keeps asking for Login

    Posted 01/12/22 03:48 AM
    Thank you for the input

    The last working version is 2.0.67.

    The subset editor works just fine through Crome/Edge. It is just the issue that PAfE is loosing the cookie\Login\credentials for some reason.

    mode 1  does not appear to change a thing.

    I will look into file monitoring next.

    ------------------------------
    Constantin Budin
    ------------------------------



  • 16.  RE: PAfE keeps asking for Login

    Posted 01/12/22 04:37 AM
    is the error message in the logs any different in mode 1?

    ------------------------------
    Simon Saul
    ------------------------------



  • 17.  RE: PAfE keeps asking for Login

    Posted 02/16/22 07:11 AM
    Edited by System Admin 01/20/23 04:46 PM
    The issue has been resolved by using the FQDN instead of just the VM alias when connecting to PAW:

    computer1.company.com instead of just computer1

    ------------------------------
    Constantin Budin
    ------------------------------