Azure SQL new used sees nothing until role is re-assigned (uncheck => check again => restart app)

Hello,

- What version of RDM are you running?

- Does the Microsoft AD Authentication Library for MS SQL is installed on the computer?
https://www.microsoft.com/en-us/download/details.aspx?id=48742

Best regards,

Off course it is installed ;). We are using 13.0.6.0 (= latest version)

I just got a user who was working without internet connection. Going in offline mode he only was part of the entries (some foldere where missing).

The folder he could see where folder with all default permission.
The folder he could not see where folders which have custom permission (see printscreen in attachment)

What is the cause of this?
[should i create a separate issue support case in the forum?]

Hello,

Issue #1 - Entries not available on first login
I am currently investigating with our engineering department what could be the root of the issue. This is very strange that you need to do this so that your new user can see the sessions.

Issue #2 - Offline mode
We have resolved a very similar issue last week. The fix will be available in the next release of RDM.

Best regards,

Thanks for the quick responses! Top service

Hello,

Could you do a quick test for me. When the user doesn't see anything, please try to do a CTRL + F5 to refresh the local cache.

If it's not working, I would like you to try another cache engine. To do so, go in File -> Options -> Advanced and change the offline engine for MCDF or SQLite to see if that help or not.

Best regards,

Hey sorry for the late reply; it took a while since we needed to add a new user.
I confirm clearing the cache solves the issue. I didn't used the CTRL+F5 button but did it manually in the menu: File > Datasource > advance > manage cache > delete

Hello,

No problem for the late reply.

Glad that clearing the cache resolved your issue.

Best regards,

Its not my issue, it's an issue in RDM: we have this every time a new user logs in...

Hello,

What version of RDM are you running?

As I understand, you have created a new Azure AD Authentication user and when the user connect for the first time, he receive the message below.
Am I correct?

Failed to authenticate the user in Active Directory (Authenticabon=ActveDirectoryPassword).
Error code OXCAA1OOO1; state 11

Best regards,

We create a new Azure AD Authentication user; the users logs in and sees nothing in the repo. After clearing the cache everything is available. Note that the errormessage didn't appeared on all occasions (last new users didn't have that issue).


But all users have the 'empty repo' issue.

Hello,

What version of RDM are running?

Best regards,

Our custom installer is 13.0.6.0 (installed embeds datasource + license) ; but I think after the installation our users upgrade to the latest version...
Dont know for sure what version the users use... . I use the latest (non beta).

Hello,

As I can see in the post below, your auto refresh is set to 60 seconds. If you set the auto refresh to 0, do you encounter the same issue?
https://forum.devolutions.net/topic29679-azure-sql-datasource-goes-offline-from-time-to-time.aspx?lastpage=1#post116025

Best regards,

I have set this to 60 to maybe resolve the going offline issue (was hopeing the refresh would make the tool to go online again).
We have this issue way before the settings has been set to 60; so this is not related.

Do you have a test environment with Azure SQL and Azure AD authentication?

Hello,

Indeed, we have a SQL Azure test database using AD authentication.

I have created a new account and ask to my colleague to authenticate on the database with this new account.
It's the first time that he's connecting on that data source from his workstation.
I think this replicate your scenario correct?

On the first connection to the data source, the sessions that he had access to see where present without doing a CTRL + F5.

Please note that we both use RDM 13.5.7.0.

That being said, I would like you to try another offline engine to see if that helps. To change the offline engine, please go in File -> Options -> Advanced and change the offline engine to MCDF and/or SQLite. Let me know of the results.

Best regards,