SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA: 12.1.277: Custom Menu Items will not persist

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA: 12.1.277: Custom Menu Items will not persist
Author Message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post SA: 12.1.277: Custom Menu Items will not persist Reply with quote
I upgraded my version of SQL Sentry Plan Explorer, and I guess SolarWinds owns them now so the install path changed.

I've tried to change the "External Program" in the custom menu item, it doesn't stick.

I've created a new menu item, it doesn't stick.

I closed S.A and re-ran as Administrator and tried to change the "external program" or create a new menu item and it doesn't stick.

I've tried to delete all the custom menu items (I only have one). That doesn't stick either.


Is this a bug in 12.1.277?

*Edit: I got it by exporting the config, changing the path in the backup .sas file and re-importing just the "common" section.
Tue Apr 26, 2022 10:59 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
If you face it again, please try temporarily disabling UAC, making config changes and re-enabling it.
Tue Apr 26, 2022 11:16 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
If you face it again, please try temporarily disabling UAC, making config changes and re-enabling it.


I just tested this by disabling UAC, adding a "output file" to the custom menu item, applying the change, hitting OK to close the S.A options dialog and re-entering the dialog to see my output file change did not persist.

Also tried this with UAC disabled and S.A "run as administrator"
Tue Apr 26, 2022 11:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Here is some additional information that might be useful.

If you don't see an error, from the Options dialog point of view it saved changes to the file successfully without operating system reporting an I/O error. Why file changes are silently reverted or somehow virtualized, isn't known to the process saving the changes.

There is also an important difference from where changes are saved. For example, if you use SSMS, and from the plugin's SQL Assistant menu access Options dialog, make changes and save them, most of them are saved by the SSMS/plugin (not all, but most), I would expect it to see the saved changes until SSMS is restarted. But if they are made from systray app, or other editor, in other words fro ma different process, and UAC or something else interferes, then you might be unable to see them in SSMS. You may want to try experimenting with that and checking if it makes a difference in your case.
Tue Apr 26, 2022 11:41 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
Here is some additional information that might be useful.

If you don't see an error, from the Options dialog point of view it saved changes to the file successfully without operating system reporting an I/O error. Why file changes are silently reverted or somehow virtualized, isn't known to the process saving the changes.

There is also an important difference from where changes are saved. For example, if you use SSMS, and from the plugin's SQL Assistant menu access Options dialog, make changes and save them, most of them are saved by the SSMS/plugin (not all, but most), I would expect it to see the saved changes until SSMS is restarted. But if they are made from systray app, or other editor, in other words fro ma different process, and UAC or something else interferes, then you might be unable to see them in SSMS. You may want to try experimenting with that and checking if it makes a difference in your case.


In this case I'm only using the systray app to make the changes and using SQL Editor 64-bit (which I've tried having closed while making the changes and seemingly made no difference)
Tue Apr 26, 2022 11:43 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
In that case, please try changing them from SQL Editor without restarting the process. Same process instance saves them and the same instance reads them. If changes get saved it should show them. If you restart it and they are gone, something reverted them or made them saved to a temporary virtualized copy of the file.
Tue Apr 26, 2022 12:09 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
In that case, please try changing them from SQL Editor without restarting the process. Same process instance saves them and the same instance reads them. If changes get saved it should show them. If you restart it and they are gone, something reverted them or made them saved to a temporary virtualized copy of the file.


Tried it from Options -> SQL Assistant.

Did the same thing, changed the "Output file", hit OK to save.. went back in to confirm, change did not persist.
Tue Apr 26, 2022 12:11 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
I added msedge* to the target exclusion list on the same common settings page and that stuck. But the other stuff does not
Tue Apr 26, 2022 12:26 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
https://www.screencast.com/t/VuHDvz0E


Also I'll note not in this video: If I add msedge* to the target exclusion list AND try to modify the custom menu items before hitting "OK" to save the changes, I lose both.

But if I do the ignored targets, hit OK.. it sticks.
Tue Apr 26, 2022 1:09 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Thank you very much for the useful video. I managed to reproduce the issue after watching it. Indeed this has nothing to do with the UAC. The issue appears to be with Custom Menu editor widget in the Options, which somehow looses all its changes if nothing else is changed before that, and changed specifically in some particular order.


Last edited by SysOp on Wed Apr 27, 2022 10:19 am; edited 1 time in total
Wed Apr 27, 2022 9:01 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
Thank you very much for the useful video. I managed to reproduce the issue after watching it. Indeed this has nothing to do with the UAC. The issue appears to be with Custom Menu editor widget in the Options, which somehow looses all its changes if the if nothing else is changed before that, and changed specifically in some particular order.


Cool. Hope it gets fixed. :)
Wed Apr 27, 2022 9:03 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
I'm sure it will, can't be too complicated :-)
Here is a tracking issue number #SA0042937
Wed Apr 27, 2022 10:20 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
FYI, we expect new build for 12.1 version released over the weekend. That build fixes the menu stickiness issue, i just tested it on my system.
Fri May 06, 2022 10:06 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 805
Country: United States

Post Reply with quote
SysOp wrote:
FYI, we expect new build for 12.1 version released over the weekend. That build fixes the menu stickiness issue, i just tested it on my system.




Fri May 06, 2022 10:08 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.