Print Thread
Page 1 of 3 1 2 3
Test window can not be closed when debug has gone wrong or connection has been lost
#44497 09/04/12 08:29 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
I have a test window that has "crashed" because of failing to break a debug session on an 11g database. The result now is that the execution has stopped, but the green Run arrow and the red Break lightning are enabled like the debugging session was still aktive. Nothing happens whether I press the green arrow nor the red lightning.

The problem is that the test window can not be closed. I get the message: "Test Window cannot be closed, Script is still executing". If I press Terminate, nothing happens.

I am now severely limited in what I can do in PLD: no compilation, no running of new test scripts. Only option is to save all programs, selects etc. and use task manager to force PLD to end. Not a very elegant solution.

This can also happen if I run SQL scripts of test windows using a databse connected via a VPN connection and the VPN connection fails for some reason (network problems etc.)

Please make it possible to force close a test window no matter the state of the debugging session. It must always be possible to close a window and end PLD in an orderly fashion without having to use the task manager.

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #44500 09/04/12 09:13 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Test window can not be closed when debug has gone wrong or connection has been lost
Marco Kalter #44502 09/04/12 09:16 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Thanks. Please make it a high priority, it causes great amounts of extra work and frustrations

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #44510 09/05/12 09:53 AM
Joined: Apr 2011
Posts: 49
Member
Offline
Member
Joined: Apr 2011
Posts: 49
i've experienced the same issue. i believe this works:
- click the X to close the window
- that terminates the debug session
- then Cancel the window closure

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Claus Pedersen #46879 04/20/13 11:39 AM
Joined: Dec 2012
Posts: 17
G
Member
Offline
Member
G
Joined: Dec 2012
Posts: 17
Still the probelem is persisting??
Any solution u got ??

---we are facing same issues ---Hari Developer Team

Re: Test window can not be closed when debug has gone wrong or connection has been lost
archer #46947 04/29/13 09:17 PM
Joined: Aug 2007
Posts: 53
Phoenix
J
Member
Offline
Member
J
Joined: Aug 2007
Posts: 53
Phoenix
I have a similar problem, but I don't think the workaround from archer works for me. When I try to close the window, I get the "Test Window can't be closed..." box. Clicking Terminate give me the error:
Error during debug step:
ORA-03114: not connected to ORACLE
Debug session terminated.

but the debug session remains; the green arrow and the red lightning bolt are both active, and clicking them gives the same error.

Can PL/SQL Developer be modified to actually terminate the debug session when it says "Debug session terminated"? (I'm using Version 9.0.6.1665)

One other note: Right-clicking on the window in the Window List shows the "Close Window" disabled, but the "Execute" is enabled. (Choosing Execute just locks up PSD as "Initializing...")

Last edited by juanian; 04/29/13 09:49 PM.
Re: Test window can not be closed when debug has gone wrong or connection has been lost
juanian #47021 05/08/13 08:40 AM
Joined: Aug 2007
Posts: 13
R
Member
Offline
Member
R
Joined: Aug 2007
Posts: 13
To confirm, this is still an issue with 10.0.2

Re: Test window can not be closed when debug has gone wrong or connection has been lost
Richard Scott #47494 07/19/13 09:04 PM
Joined: Aug 2007
Posts: 53
Phoenix
J
Member
Offline
Member
J
Joined: Aug 2007
Posts: 53
Phoenix
And it has been around for quite a while . . .

Debug session 'stuck' on ORA-03114 - not connected to oracle loop

Re: Test window can not be closed when debug has gone wrong or connection has been lost
juanian #49861 12/05/14 09:35 PM
Joined: Dec 2014
Posts: 1
D
Member
Offline
Member
D
Joined: Dec 2014
Posts: 1
This issue is still with 10.0.5. is there any plan to get it corrected? every time have to terminate the process from task management, it's very frustrating!

Re: Test window can not be closed when debug has gone wrong or connection has been lost
davqi #49865 12/08/14 04:22 PM
Joined: Apr 2003
Posts: 517
Portland, OR, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 517
Portland, OR, USA
When I get this problem, I open another PL/SQL Developer program, open the sessions window and then kill the hung test session. That has always worked as far as I remember. It's still not elegant and it's a hassle, but I don't lose anything else this way.

Page 1 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.049s Queries: 15 (0.018s) Memory: 2.5598 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-28 18:57:15 UTC
Valid HTML 5 and Valid CSS