Toad World® Forums

Weird loss of access to results

I don’t exactly know how to describe this, but I have found a way to consistently reproduce it, at least in my environment. I can’t figure out exactly what the cause is, so I can’t come up with a generic way to recreate it.

12.6.0.11 (x64) connecting to 10.2.0.3 via a 64-bit client on Win7.

I noticed this first yesterday when retrieving and updating data via the SB. I filtered for a specific appointment_id, changed a processed flag and committed. At some point later I went in to do the same for another appointment_id and it
didn’t find any data for that ID. I had copied and pasted it in from the application error log, so I knew the data was valid. When I questioned a coworker about it he said he could see it just fine. So I cleared the filter, but no data displayed in a table
I know to have a million+ records. Then I noticed that it wouldn’t display data for any table. What the heck?

So I closed TOAD and restarted. Eventually it did the same thing. I was going to report it, but wanted to understand the circumstances to give you steps to recreate the problem. Then later in the day I noticed it happened in a script I
was running in MOE too. A very simple select from one table with a very simple where clause worked, then suddenly… nothing. If I reload the workspace or disconnect and reconnect it would work again. It’s almost as if it still sees the tables, just not the
data in them. Kind of like it’s displaying the result cache for a failed query, except this is in 10g, so it’s not a result cache.

I noticed this morning that when starting fresh (powered off over night) that when I started a test run that should take 30 seconds that when it ran a few minutes I knew that there was a logic flaw so I cancelled it, but then second guessed
myself and said let’s see how long it runs and restarted it. It immediately responded with no results and wouldn’t run the procedure until I reloaded the workspace, thus closing and reopening the connection.

I then tried to recreate the issue in 12.5.0.99 but it seems to act normally there. I can run, cancel, re-run, cancel, re-run and it will process as expected. In the beta once I cancel I won’t get a result on a re-run until I disconnect.

It’s not the act of cancelling though, because I was getting the same issue in the SB after a successful update and commit.

Chris Johnson

IT Systems Analyst

Distribution Logistics

615-855-4371

If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

I’m finding something similar in the editor. I had been getting results for my SQL and had been tweaking various pieces of it. All of a sudden I got no rows returned. So I ran another statement that I knew would give results and again got no results. And another. And another. I then opened up a desc window and selected data from my table out of that window and then queried for that exact record in my editor and got no rows returned. Starting a new connection to the same database did not get my data to show up. The only thing that is working is opening a new tab and running the sql there now.

I wish I had steps to reproduce this, but I don’t. I’ll see if I can get it to happen again. . .

On Thu, Jul 3, 2014 at 10:05 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE: Weird loss of access to results

Reply by Dennis Paulus
If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

BI MIddleware Engineer
Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

I’m not sure but it seems that a similar thing happens with my Toad beta (12.6.0.11/32bit)

I wrote a simple select (ie. select count(*) from footable) that needs several seconds to process, started it and immediately cancelled because I forgot a column for example.

Now starting again and the immediate answer was “no rows returned”!

I closed and restarted Toad and everything is fine again (ok, dis- and reconnect does the same… thx :wink: )

-> seems to be the same topic

Regards Chris

I had been getting results for my SQL and had been tweaking various pieces of it

Did you mean you were tweaking your query or were you changing data in the grid? The original post said they were modifying the data and then the problem occurred, so I’m
trying to find a common nugget to go on, as I haven’t been able to replicate yet.

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Thursday, July 03, 2014 2:52 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

Re: Weird loss of access to results

Reply by phyllis.helton_1150

I’m finding something similar in the editor. I had been getting results for my SQL and had been tweaking various pieces of it. All of a sudden I got no rows returned. So
I ran another statement that I knew would give results and again got no results. And another. And another. I then opened up a desc window and selected data from my table out of that window and then queried for that exact record in my editor and got no rows
returned. Starting a new connection to the same database did not get my data to show up. The only thing that is working is opening a new tab and running the sql there now.

I wish I had steps to reproduce this, but I don’t. I’ll see if I can get it to happen again. . .

On Thu, Jul 3, 2014 at 10:05 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE: Weird loss of access to results

Reply by Dennis Paulus

If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting
your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Phyllis Helton

BI MIddleware Engineer

Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

In my case I was doing it both ways. I originally noticed it in the SB, and yes, I did try refreshing.

I also noticed it in a separate incident when I was working on a packaged pipelined function although once whatever it is that is causing the incorrect behavior
to occur it doesn’t matter what I run. SB describes, simple queries, everything returns no results.

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Monday, July 07, 2014 7:20 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

RE:
Weird loss of access to results

Reply by Dennis Paulus

I had been getting results for my SQL and had been tweaking various pieces of it

Did you mean you were tweaking your query or were you changing data in the grid? The original post said they were modifying the data and then the problem occurred, so I’m
trying to find a common nugget to go on, as I haven’t been able to replicate yet.

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Thursday, July 03, 2014 2:52 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

Re:
Weird loss of access to results

Reply by phyllis.helton_1150

I’m finding something similar in the editor. I had been getting results for my SQL and had been tweaking various pieces of it. All of a sudden I got no rows returned. So
I ran another statement that I knew would give results and again got no results. And another. And another. I then opened up a desc window and selected data from my table out of that window and then queried for that exact record in my editor and got no rows
returned. Starting a new connection to the same database did not get my data to show up. The only thing that is working is opening a new tab and running the sql there now.

I wish I had steps to reproduce this, but I don’t. I’ll see if I can get it to happen again. . .

On Thu, Jul 3, 2014 at 10:05 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE:
Weird loss of access to results

Reply by Dennis Paulus

If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting
your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Phyllis Helton

BI MIddleware Engineer

Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Are you guys running queries in threads? Do you have Code Insight options turned on? Are you running 32 or 64 bit? Just looking for some similarities between the cases to try to replicate - if you can let us know, it would be appreciated.

Chris - If you don’t mind, can you please zip your user files and send them to me offline (Dennis.Paulus@quest.com)? I haven’t been able to reproduce
this at all, so maybe if I’m using your same settings I’ll be able to narrow it down a bit. Thanks.

From: crjohnso [mailto:bounce-crjohnso@toadworld.com]

Sent: Monday, July 07, 2014 8:30 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

RE: Weird loss of access to results

Reply by crjohnso

In my case I was doing it both ways. I originally noticed it in the SB, and yes, I did try refreshing.

I also noticed it in a separate incident when I was working on a packaged pipelined function although once whatever it is that is causing the incorrect behavior
to occur it doesn’t matter what I run. SB describes, simple queries, everything returns no results.

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Monday, July 07, 2014 7:20 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

RE:
Weird loss of access to results

Reply by Dennis Paulus

I had been getting results for my SQL and had been tweaking various pieces of it

Did you mean you were tweaking your query or were you changing data in the grid? The original post said they were modifying the data and then the problem occurred, so I’m
trying to find a common nugget to go on, as I haven’t been able to replicate yet.

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Thursday, July 03, 2014 2:52 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

Re:
Weird loss of access to results

Reply by phyllis.helton_1150

I’m finding something similar in the editor. I had been getting results for my SQL and had been tweaking various pieces of it. All of a sudden I got no rows returned. So
I ran another statement that I knew would give results and again got no results. And another. And another. I then opened up a desc window and selected data from my table out of that window and then queried for that exact record in my editor and got no rows
returned. Starting a new connection to the same database did not get my data to show up. The only thing that is working is opening a new tab and running the sql there now.

I wish I had steps to reproduce this, but I don’t. I’ll see if I can get it to happen again. . .

On Thu, Jul 3, 2014 at 10:05 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE:
Weird loss of access to results

Reply by Dennis Paulus

If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting
your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Phyllis Helton

BI MIddleware Engineer

Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I’m running 64 bit, queries in threads, code insight on. I am just modifying my SQL, not touching the data in the grid.

On Mon, Jul 7, 2014 at 9:58 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE: Weird loss of access to results

Reply by Dennis Paulus

Chris - If you don’t mind, can you please zip your user files and send them to me offline (Dennis.Paulus@quest.com)? I haven’t been able to reproduce this at all, so maybe if I’m using your same settings I’ll be able to narrow it down a bit. Thanks.

From: crjohnso [mailto:bounce-crjohnso@toadworld.com]

Sent: Monday, July 07, 2014 8:30 AM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

RE: Weird loss of access to results

Reply by crjohnso

In my case I was doing it both ways. I originally noticed it in the SB, and yes, I did try refreshing.

I also noticed it in a separate incident when I was working on a packaged pipelined function although once whatever it is that is causing the incorrect behavior to occur it doesn’t matter what I run. SB describes, simple queries, everything returns no results.

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]
Sent: Monday, July 07, 2014 7:20 AM
To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

RE: Weird loss of access to results

Reply by Dennis Paulus

I had been getting results for my SQL and had been tweaking various pieces of it

Did you mean you were tweaking your query or were you changing data in the grid? The original post said they were modifying the data and then the problem occurred, so I’m trying to find a common nugget to go on, as I haven’t been able to replicate yet.

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Thursday, July 03, 2014 2:52 PM
To: toadoraclebeta@toadworld.com
Subject: Re: [Toad for Oracle - Beta Discussion Forum] Weird loss of access to results

Re: Weird loss of access to results

Reply by phyllis.helton_1150

I’m finding something similar in the editor. I had been getting results for my SQL and had been tweaking various pieces of it. All of a sudden I got no rows returned. So I ran another statement that I knew would give results and again got no results. And another. And another. I then opened up a desc window and selected data from my table out of that window and then queried for that exact record in my editor and got no rows returned. Starting a new connection to the same database did not get my data to show up. The only thing that is working is opening a new tab and running the sql there now.

I wish I had steps to reproduce this, but I don’t. I’ll see if I can get it to happen again. . .

On Thu, Jul 3, 2014 at 10:05 AM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE: Weird loss of access to results

Reply by Dennis Paulus

If you can replicate the issue, maybe turn on Spool SQL (Database > Spool SQL) and maybe it’ll catch something that can give a little more information.

Side note: When in the SB and this happens, did you try pressing the ‘Refresh Data’ button on the toolbar, or maybe even try ‘Refresh Detail Panel (Right Hand Side)’.

I noticed you mentioned you’re using workspaces - it’s just a guess, but maybe something is funky happening there. Maybe try turning workspaces off, or even better if you can, try resetting your user files to see if you can still replicate the issue (but of course, before doing this, it would be nice to see if we can isolate what might be causing the issue).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Phyllis Helton

BI MIddleware Engineer
Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

BI MIddleware Engineer
Digital Strategies, Cru | Insight Team

Office :phone: 407-515-4452

phyllis.helton@cru.org

my setup is 32 bit, no queries in threads, no code insight use.

After cancelling the query every subsequent run yields “no rows returned”.

Funny: the message in the statusbar says “Row 0 of 0 fetched so far (more rows exist)”.

This behaviour appears in a editor window AND the sb (data tab) and lasts as long as the tab/window exists.

I am havingthe SAME issues with 12.6 beta. LOTS of issues. This issue is occuring for me when I am not logged into the schema that has the tables… If I log into that schema I get results. If I log in as someone else the results do NOT showup. This does not happen in the latest production release.

running 64-bit, queries in threads, code insight on.

From editor execute

select * from dba_tables xx order by xx.num_rows desc;

cancelled query

re-executed and editor says “no row returned”

I now get “no rows returned” for any query I execute from that editor tab e.g. SELECT * FROM DUAL:.

Seems to be as soon as I cancel a query, that editor tab is hosed.

We were able to replicate the issue when cancelling a query. Thanks for the steps. We’re looking into it.

It’s a bug in one of our third party libraries. They are working on a fix.

On Mon, Jul 7, 2014 at 10:08 AM -0700, “Dennis Paulus”
bounce-Dennis_Paulus@toadworld.com wrote:

RE: Weird loss of access to results

Reply by Dennis Paulus
We were able to replicate the issue when cancelling a query. Thanks for the steps. We’re looking into it.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

This is fixed in the next beta.