Good Afternoon TOAD Team,
Again somehow I missed this new capability, I think was released with MDI/SDI windows; I've switched back to MDI, since on any window I can right click the left corner of the window bar and pop out a window as an SDI window (you can reverse the process with a link in the upper left corner of the popped out window, too). This bug has a simple work around, but happens in 13.0 through today's latest beta, 13.3.0.32. I start any connection with the schema browser and my default "Object list" choice is Favorites, not the TOAD default of Tables. When I pop-in or pop-out a window when Favorites is selected, the window is blank:
The work-around, is pick Tables, and then pick Favorites, the content is then restored.
Larry
Good Afternoon TOAD Team,
Sorry about the scroll bars, removed below:
Again somehow I missed this new capability, I think was released with MDI/SDI windows; I've switched back to MDI, since on any window I can right click the left corner of the window bar and pop out a window as an SDI window (you can reverse the process with a link in the upper left corner of the popped out window, too). This bug has a simple work around, but happens in 13.0 through today's latest beta, 13.3.0.32. I start any connection with the schema browser and my default "Object list" choice is Favorites, not the TOAD default of Tables. When I pop-in or pop-out a window when Favorites is selected, the window is blank:
The work-around, is pick Tables, and then pick Favorites, the content is then restored.
Larry
Hi Larry,
Can you give me some steps to make the Schema Browser come up 'blank' and on Favorites like that? I tried but can't make it happen.
This is what I tried:
- Make schema browser auto-open when connection is made
- Set default object type on schema browser to Favorites.
- Make a connection in Toad. Schema Browser opens to favorites (but it isn't blank)
- Pop-out the Schema Browser. (for me, it popped out OK, not blank)
- Popped it back in. (still looks good here)
Thanks.
-John
Good Afternoon John,
Any time I pop-in or pop-out a schema browser window when Favorites is the choice, it is blank. For the screen shot I changed to Tables and correctly
popped-out, then chose Favorites and Popped-in, took screen shot.
Sorry, I made you path long in my explanation of why I discovered this bug.
Hm, so looks like my steps should do it.
I also tried:
- setting text size to 125% (in windows settings)
- using 64 bit beta
- using "direct" connect method on login window
- setting SB to a schema other than my login schema
Anything else that I might be missing?
Also, I am curious - if you just un-maximize and and then re-maximize the schema browser, does that solve it? I have seen in the past sometimes controls don't paint correctly and just resizing them makes them repaint.
Good Morning John,
Pretty through for one image; I also keep my TOAD settings on OneDrive, so all (two sets, production and development accounts) my workstations
are in sync without backup and recovery of TOAD settings. My TOAD beta support bundle is attached, too.
supportBundle.txt (97 KB)
Good Morning John,
This just got stranger. TOAD version 14.0.0.191.
When connected as schema owner, POP In and Out don't loose the LHS, but when I connect to a schema, even the same schema, using a read-only account the LHS goes blank on POP Out and IN.
Larry
Hi Larry,
This is the first that you've mentioned using a read-only account.
So now I have questions:
- Do you mean that you are checking the "read only" box on the login window? Or do you just mean that the database user only has SELECT privileges and that's it?
- Does this happen when you do not use a read-only account? (in whichever sense you meant by that)
Good Morning John,
By read-only account I mean
database user only has SELECT privileges and that's it. BTW, I leave the read-only box checked for all accounts; I write scripts to change data.
I use two types of accounts, (1)
database user only has SELECT privileges and that's it [LWICKLIFFE in the screen shot below] and (2) schema owner database user [COMMON in the screen shot below].
When connected using a schema owner account, TOAD functions as expected. The LHS is still there and the RHS needs a data refresh when popped in or out (maybe the RHS could
be improved, to no refresh required – but that is off subject).
Looking at your screen shot (the empty one a couple of posts up), I see that you have "Favorites" selected in the dropdown but somehow Roles in showing in the area below (notice the column headers where the objects are listed).
I think that is what's causing the problem. But I don't know how you are getting the SB in that state. Pop in/out doesn't do that for me (I tried while looking at my own schema and another schema).
will you zip up and send me your user files folder? You can send to john.dorlon@quest.com
Thanks
John
Good Morning TOAD Team,
Thank you John! Just letting the forum know that I sent you the requested .zip file, renamed .piz to get outside my office.
Larry
HI Larry,
Well, unfortunately, the mystery remains.
Here is what I did to try to reproduce the problem. Please correct my steps if needed.
Used your user files folder
- Made a connection
- Opened Schema Browser
- Added some objects from 3 different schemas to favorites folders. Named each folder after the schema that owned the objects. One of the objects in the SYS folder was a role.
- disconnected
- Connected read-only as a different user.
- clicked on various objects in SB-Favorites. Popped in, popped out.
- Each time, the SB displayed correctly
Good Afternoon John,
Thank you for looking. Even more oddness: V$VERSION RHS stays populated when pop-out, the LHS is still blank: Same for pop-in, second screenshot below:
Yup, the LHS and RHS are getting out of sync, and/or the panel on LHS that should display the object list is just not being displayed. Not sure why. 
Good Morning John,
Installed 14.0.0.200 clean (was installed in 13.3 beta folder).
I have only used my read-only user,
(Useless more steps, default to data tab on right hand side (RHS) for tables. Close Project Manager, hide connection bar, save passwords, color connections, open schema browser on connect, maximize windows in TOAD, default to COMMON schema when log in as read-only user, name filters and maximize TOAD. Connection Info: User@database in Window Bar and make data the first tab for view. No issue so far, but no favorites. ) ...
Start over clean again. Only thing in favorites is SYS.V_$VERSION. Log in as below and issue is back. I put the favorite in a folder called SYS.
Larry
Hi Larry
I followed your steps. Still no luck here. You didn't mention it in the steps above, but I think you're also setting Favorites to come up by default in the SB, is that right?
Will you send me a support bundle? It'll have info about your environment. Maybe there is something in there that's relevant.
Help -> Support bundle. Just copy/paste it into an email.
Thanks
Good Afternoon John,
Yes, I normally do many settings changes, but from a clean start I made only those changes mentioned. Did not even set data tab as the first tab.
Something is not cleared when clear settings or install in a new directory. If I wait, OneDrive (maybe TOAD, I don’t really know what does it) will put most of the setting back, even to the beta 14.0 directory which was empty.
Support bundle, TOAD.ini and smaller renamed .zip of User Files attached.
How do you recommend to get back to out of box TOAD? My settings are backed up, and I have production and beta TOAD on my development VM.
(Attachment User Files_March 16 2020.piz is missing)
(Attachment Toad.ini is missing)
Support Bundle_March 16 2020.txt (12.2 KB)
If I wait, OneDrive (maybe TOAD, I don’t really know what does it) will put most of the setting > back, even to the beta 14.0 directory which was empty.
I don't know what's doing that, but it isn't Toad.
To restore all Toad settings to fresh install, do this:
- Main Menu -> Utilities -> Copy User Settings.
- Check "Reset to a clean set of user files from the base installation"
- Click OK.
- Toad will restart.
I didn't see anything in your support bundle that jumped out at me. One drive was the only thing out of the ordinary, but I don't think it would cause this.
I have found the problem and it will be fixed soon.
The shortest steps to reproduce it are:
- Log in as user SCOTT or any user without the SELECT privilege on DBA_ROLES
- Go to Schema Browser and choose "Favorites" tab.
- Right-Click on the Schema Browser window bar button and choose Pop Out.
- Schema Browser LHS goes blank.
The key to reproducing this is to log in as user who lacks the SELECT privilege on DBA_ROLES.
-John
1 Like
Good Morning John,
Thank you for all the work!!
Just following up; not fixed yet on 14.0.0.244:
Larry
