Intermittent problem - cannot switch connections when describe window is open

Toad for Oracle & DevOps Toolkit
1

Morning All,

I’m (still) on Toad 13.0.0.80, 64 bit on WIndows 7.

Very occasionally, about once or twice a week, possibly when my sessions have been open for a while, I notice that if I have the describe window open on one session then any attempt to switch to another session using the connection bar, appears to work, but I’m immediately sent back to the session that has the describe window open. The connection bar does show that I’m on the first session - that button is down.

I cannot reproduce this at will, so I’m happy for it to be put on the very back burner until I can, or at least, find some combination of events that causes it, but I thought I’d mention it.

Cheers,
Norm. [TeamT]

2

That sounds familiar, Norm. I found this in our bug tracking system. If this is it, it’s been fixed in 13.1. If this is not it, let me know.

Setup:

  1. In Options, Check “Show only buttons for current connection on window bar”
  2. In Options, Check “all describes are contained in single tabbed window”
  3. Start Toad and open a describe dialog. On the describe toolbar, click the dropdown arrow on the last button and uncheck “Allow multiple connections”

Bug:

  1. Start Toad.
  2. Open 2 connections.
  3. Open a Describe dialog and an Editor in each connection
  4. Maximize the Editor of Connection 2 in Toad.
  5. Click the connection button for toolbar 1. The active connection changes in Toad - toolbars are updated.
  6. Try to click the editor window button for connection 1.
    bug: Toad changes active connection back to connection 2.

workaround: either close describe windows, or
use the “Window” main menu item, or
un-maximize the editor and then click on the other one.

3

Hi John,

Sounds like it’s similar - I’ll see what I can reproduce tomorrow at work.

As ever,
Thanks.

Cheers,
Norm.

4

Morning John,

My setup is exactly the same as described. So far so good. However, when I try to reproduce the bug as per the steps involved, I don’t see the bug happening I’m afraid - which is a good thing. I can swap between sessions happily, and get the correct editor with no problems.

I’ll keep an eye out for when it next happens to see if I can come up with a recipe to make it misbehave.

Cheers,
Norm. [TeamT]

5

darn, I was hoping that was it. OK, let me know…

6

Hi John,

I've suffered from this problem again this morning. Here's what I have gathered, in case it helps. I think I can reproduce it as follows:

  • I have 5 database sessions open;
  • I was in session 2 and placed the cursor on a table name in the editor and pressed F4;
  • I can swap sessions happily at this point, so switch to any other session;
  • In Describe window, click onto indexes, referential or partitioning tabs - these are all I've tested so far;
  • Now, clicking back to session 2 fails.
  • Clicking back to session 2 changes:
    The connection bar correctly;
    The window bar correctly;
    But not the editor itself.

If I close the F4 window, then the editor in session two redraws correctly - assuming I last clicked back onto session 2 of course.

I've been able to reproduce this at will today.

HTH

Cheers,
Norm.

7

Which Toad version are you on, Norm?

8

Hi John,

I’m (still) on Toad 13.0.0.80, 64 bit on Windows 7.

I'll need to get an update at some point soon!

Cheers,
Norm[TeamT].

9

I'm having trouble reproducing it, but I'm not 100% clear on your steps either. Would you mind making a video and emailing it to me?

10

I don't have the ability to create a video John, sorry. I'll try a better description of the steps I take to reproduce:

  • Open two database sessions with at least one editor window each.
  • In session one, put the caret on any object name and press F4.
  • Click into session two while the describe window is open and on-screen.
  • Click back to session one - it works fine. No problems so far.
  • Click into session two again, while the describe window is still open and on-screen.
  • On the describe window, click onto a different tab;
  • Attempt to click back into session one - it will fail to switch the editor window back and will still show the commands for session two.

You have to be on a different database connection from the one you pressed F4 in when you change the tab on the describe window. Once you change the tab, the connection bar shows you are back on the F4 session, the window bar shows you are in the Describe window, but the editor shows the other database's commands.

I think it's probably because the editor isn't getting the chance to grab focus, and thus update, because the describe window has grabbed focus?

Hope this helps. Sorry about the lack of pictures. :slight_smile:

Cheers,
Norm. [TeamT]

11

Hi Norm,

Thanks for the details. Assuming if by "click into session one/two" you mean "click the connection bar button for session one/two"....

I can reproduce that in 13.0 but not 13.1 or the current beta, so it seems to have been fixed.

Thanks,

-John

12

Yes indeed, that's what I failed to make clear, click into the other sessions using the connection bar.

If it's fixed in 13.1, then I'm happy. Thanks again.

Cheers,
Norm[TeamT].

1 Like