Print Thread
Page 3 of 3 1 2 3
Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #62196 11/16/20 09:41 AM
Joined: Jan 2020
Posts: 2
S
Member
Offline
Member
S
Joined: Jan 2020
Posts: 2
+1

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #62281 12/22/20 03:56 PM
Joined: Dec 2020
Posts: 1
A
Member
Offline
Member
A
Joined: Dec 2020
Posts: 1
+1 Have had this issue forever with PL/SQL Developer. It is a great tool but the one feature that I like the best gives me the most trouble and that is a hung debug window (for any reason). Will highly appreciate if this is fixed.

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #62282 12/23/20 12:32 PM
Joined: Sep 2019
Posts: 34
Spain
E
El Offline
Member
Offline
Member
E
Joined: Sep 2019
Posts: 34
Spain
+1 I have the same problem


-------------------------------
Elias F.M.
Re: Test window can not be closed when debug has gone wrong or connection has been lost
Marco Kalter #63858 04/20/22 01:10 PM
Joined: Apr 2022
Posts: 1
C
Member
Offline
Member
C
Joined: Apr 2022
Posts: 1
Currently using PL/SQL Developer V13, and the issue still exists.
Is there a fix for this, and if not maybe some explanation?
Is it necessary for the connected user to have ALTER SESSION privilege? because this is required to use the workaround to open another PL/SQL Developer instance and kill the rogue test session.

Re: Test window can not be closed when debug has gone wrong or connection has been lost
juanian #64515 03/17/23 12:21 PM
Joined: Nov 2022
Posts: 5
M
Member
Offline
Member
M
Joined: Nov 2022
Posts: 5
Most annoying bug occurring on a daily basis to date, which should be solvable even in a suboptimal manner, regardless if it's related to some obscure oci driver bug.


Originally Posted by juanian
Sadly, it appears that this will never be fixed. I recently upgraded to Version 14 and just ran into the problem (again). Checking the forums, I still see my original post from 13 years ago ( Debug session 'stuck' on ORA-03114 - not connected to oracle loop ).

The problem can occur when a debugging session is left 'executing' too long, and Oracle times out the session. So, the previous workarounds (like killing the Oracle session) won't work, because Oracle has already killed the session on the database side.

I would have thought it should be a pretty 'simple' fix in PL/SQL Developer - when the user tries to close the window and receives the "Test Window cannot be closed, Script is still executing", and then clicks the Terminate button, and gets the error:
Error during debug step:
ORA-03114: not connected to ORACLE
Debug session terminated.

clear the 'flag' that indicates that the session is still executing. Since the session is already disconnected from Oracle, there is no need to be concerned about a dangling process on the Oracle side.

The only way I can see that will get out of the situation is to kill the PL/SQL Developer app in Task Manager. That is a bit drastic, but since there is no known work-around, that is the only way to solve the issue. (Trying to close the window from the Task Bar (or by clicking the X in the upper right of the application) just pops up the same "Test Window cannot be closed, Script is still executing" dialog.)

This problem should be very simple to reproduce - start a Debug session, disconnect the PC from the network, and try to do a step. Once the connection times out, the error should occur.

I'm assuming that fixing this is too low on the list of bug fixes for AA, likely because an insufficient number of people have let AA know that they have this problem. So if you do have this problem, let AA know, so it might inch up a tad on their 'bugs to fix' list.

Thanks
Juan

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #64516 03/17/23 10:18 PM
Joined: Dec 2022
Posts: 6
G
Member
Offline
Member
G
Joined: Dec 2022
Posts: 6
+1

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #64517 03/20/23 07:53 AM
Joined: Jan 2006
Posts: 66
Lithuania
Member
Offline
Member
Joined: Jan 2006
Posts: 66
Lithuania
+1


Dalius
Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #64521 03/22/23 11:09 AM
Joined: Jan 2003
Posts: 88
A
Member
Offline
Member
A
Joined: Jan 2003
Posts: 88
+1

So irritating... SQL Developer doesn't seem to suffer from this.


Andy
Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #64559 04/21/23 10:48 AM
Joined: Dec 2001
Posts: 236
berlin
F
Member
Offline
Member
F
Joined: Dec 2001
Posts: 236
berlin
+1

It is possible to kill the session(s) on the database server in order to be able to interact with the program again. However, debugging is no longer possible until plsd is restarted (debug = run).

Page 3 of 3 1 2 3

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.039s Queries: 14 (0.013s) Memory: 2.5581 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-19 19:00:21 UTC
Valid HTML 5 and Valid CSS