While migrating all our customers into individual vaults ran into this problem. May not be a bug, may be a misunderstanding on vaults, but feels like a bug.
Version: 2020.2.17.0 64 Bit - Enterprise
Data Source Target: Azure SQL
Problem:
I have a few vault's setup. When I open RDM from scratch, there is no GUI pull down in the navigator to switch vaults. When there is a selector, it's usually immediately under the tree control showing all the RDM entries on the left navigation bar, and above the bottom toolbar that shows which part of vault you are looking at (vault, private, favoriates, etc). However, on opening RDM there is no such selector.
The only way to get it to show up is to go to Administration > Vaults on the top menus. You can just open ADministration > Vaults, and hit Close, and then the vault selector will appear. Seems like it should just always be there. This has been a major stumbling block for long term RDM users first trying vaults. I see a lot of "How the hell do I change vaults in the nav" and then other responding with "its the selector right under the nav tree", followed by responses "I don't have a selector there", then screenshots of people who have it vs. don't have it. This led to us figuring out that the person creating vaults, had it because they had entered the Admin > Vault section, and users just trying ot use vaults who don't go in there, don't have it.
Seems like the app should be checking the datasource on startup or datasource change and if the datasource has vaults defined, show the selector immediately.
Thank you for the post,this is odd we will investigate.
In the meantime, if you try CTRL + refresh (icon top left corner of RDM) does the drop down appear?
Best regards,
Stéfane Lavergne
Thank you for the post,this is odd we will investigate.
In the meantime, if you try CTRL + refresh (icon top left corner of RDM) does the drop down appear?
Best regards,
Yes, CTRL+Refresh DOES make it appear. Normal refresh (without holding down ctrl) does not.
Perfect, it gives me a pretty good idea what is going on. I've logged the issue and we will investigate.
Best regards,
Stéfane Lavergne
Update:
I upgraded to v2020.2.18.0 and this problem still remains. Hopefully its resolved in the next release.
Update:
I upgraded to v2020.2.19.0 and this problems still remains. Is this scheduled to be resolved?
Hello,
Thank you for reaching back to us on that matter!
We are still trying to reproduce this issue at the moment but we have nothing conclusive for now. For this reason, would it be possible for you to provide us the following information:
1- An export of your Data Source Configuration. To do so, please go under File -> Data Sources -> Select your SQL Azure Data Source -> Duplicate -> Change the data it contains with false data -> Ok -> Make sure that the duplicate is selected -> Export Data Source Configuration -> In doing so, a .rdd file will be created.
2- Could you tell us if the user that has this issue receives his permissions from your Roles or did he receive access to the vault directly Vaults settings?
3- Have you configured the offline mode? If so, could you please provide me a screenshot of the following location:
3.1-Under Administration -> System Settings -> Applications -> Offline
3.2-Under Administration -> Vault Settings -> Security Settings
3.3-Under Administration -> Users -> Select your user -> Edit -> Settings
All of these files can be sent to us using the secure link below:
https://devolutions.sharefile.com/filedrop
Best regards,
James Lafleur
Done, files uploaded. Note this is happening with my RDM user account which is a full administrator account, as well as other users.
Hello,
Thank you for these screenshots, I will add them to our current ticket and get back to you shortly.
Best regards,
James Lafleur
@bthomson
The team is still trying to reproduce the error so that we can then fix it. We will keep you posted when the fix is available.
Not sure if it's possible but a video of the issue occurring might be helpful. https://devolutions.sharefile.com/filedrop
Best regards,
Stéfane Lavergne
I sent a video of the problem to your filedrop system. Please note that what you are seeing is recorded from the second RDM lis launched fresh. The screen capture software requires selecting a window to record so I had to wait for the main windows to open and then hit record so you don't see the RDM logo that shows up mid-screen while loading as I couldn't attach the app recording to a window handle until your main window was finally rendered. The key point is that its from a fresh start. It doesn't show the vault selector, you then go into admin > vaults and simply close it, and the vault selector shows up.
Hello Brett,
Thank you for this recording, I will provide it to our Engineering Department and get back to you shortly.
Best regards,
James Lafleur
Thank you for the video, it's perfect. Looking at the video and the code, I see where/why this could happen but everything points to RDM thinking there are no (or 1) repositories.
Why? We know that the workarounds CTRL+refresh or going into Vaults work because they both force a refresh of the repository list so this supports this theory. Since they both force a clear of the cached repository list and we recompute it from scratch.
So why was it empty? Bad cache? Bad fetch? I will need to add some diagnostic code in RDM and get you a private version for you to test. Give me a few days to set this up. I will get back to you soon.
Stéfane Lavergne
Stéfane,
Thank you for the update. I look forward to running the private version and providing logs/output/etc. Just for your reference, I am a senior developer and have developed numerous large .Net Apps, Java Apps, Node.JS, Python, PHP, etc, and have extensive experience in SQL, local caching, networking down to packet analysis, etc. So feel free to communicate in developer/networking/database/os terms so I can help you identify and get the problem fixed. Completely comfortable running queries against data sources, attaching VS debugger to processes, etc.
I am also happy to setup a screen share if you or your engineers just want to run it live in my environment and see/try things quickly to reduce volleys back and forth in the forum.
Thanks,
Brett
Hi Stéfane,
I want to share another "feature" that might be related too.
We use a lot of Repos/Vaults too.
If I logon to my RDM with a user that only has access to 2 Vaults.
Then logoff and logon with my user and i.e. I have access to 9 Vaults.
This causes RDM to only show me the 2 Vaults of the first user.
If I select "Select Vault", I can't see the other Vaults either.
CTRL-Refresh brings them back as you already stated.
We use RDM 2020.2.19.0 with DPS 2020.2.9.0, intelligent caching enabled, offline mode allowd, auto refresh disabled
Kind Regards
Markus
======================
Thank you, Markus,
Yes, it could very much be related, when you login with a different user from the one that created the offline cache, the cache must be cleared. It looks like a different behavior of the same issue going on here.
Best regards,
Stéfane Lavergne
Brett,
I have a private build ready for you, I will send you the download link and steps to following in a private message.
Markus,
I haven't had a chance to look at the offline issue yet.
Best regards,
Stéfane Lavergne
Stéfane,
I ran the debug build and sent you the trace you requested.
Thanks,
Brett
Thank you Brett, I'm in meetings this afternoon. I will have a look at it this after and get back to you.
Best regards,
Stéfane Lavergne
Brett,
I think I found the issue, user security context is not load correctly, to confirm can you please perform the following:
Thank you,
Stéfane Lavergne
New trace sent.
What information does "data source information" include? Does it include hostname, or credentials of the data source?
It sends us the exact same info that you can see if you hit the "print" icon (an html file) and this should also match the UI.
I actually only need this section (yellow):
Stéfane Lavergne
Sent.
Thanks Brett,
I will ask the support to send you the URL (in private) so that we can schedule a remote session.
I'm usually able to figure this out via forum/email but something with this issue has me very confused and we've spent enough time going back and forth.
Thank you for your patience and understanding and talk to you soon.
Best regards,
Stéfane Lavergne
@Brett,
Thank you for your time during the remote session. I will protect the code on our side to prevent this issue in the future.
@all,
The issue happened when starting RDM with an SQL admin (example: sa) but the user didn't exist in RDM. Since the user is an SQL admin, it gets granted access to RDM but then a bug caused the vault selector to not be loaded. For now, creating the user in RDM while resolve the vault selector issue.
@Markus,
We will need to investigate your issue (posted above), I've logged a bug internally for this.
Best regards,
Stéfane Lavergne
Hello Markus,
We've made a fix for the issue where the vault list wouldn't refresh after switching users. It will be included in version 2020.3.
Regards
Jonathan Del Signore
Thank you for your update!
Kind Regards
Markus
======================