VBA to enable the PAfE add-in and auto login users

[CRP0021]

Hi everyone,
Looking for a bit of advice on this topic.
We currently have a PAfE report that auto-logs in users as soon as they launch the report. This is working as expected for our on-prem version of PA.
While preparing for a cloud migration I switched the connection string to point to our cloud URL and the same report has now stopped working and is not even bringing up a login screen.
The problem is intermittent as some users are experiencing the login issue and some are getting prompted to input their IBM ID's into the cloud landing page, which is the desired outcome.
Just looking for a bit of advice on where to look if there are any prerequisites missing or if there is something else to look out for when connecting to cloud vs. on prem.
Any advice would be greatly appreciated.

[ascheevel]

What values are you passing to the 'hideForm' and 'bypassPAWchooser' arguments of LogonSSO? I use the below in a few reports for PA on cloud and it works fine.

Code: Select all

Reporting.LogonSSO(<url>, <database>, False, "")

What version of Pafe are your users running and are some of them already logged in when they open the report? Beginning in Pafe 101 or 103, if a user is already logged in, the LogonSSO will just open PAW homepage in the popup instead of the IBMid input. I handled that by calling LogOff, waiting a bit, and then calling LogonSSO