Start Debugging then Hangs

[jgemoll]

PL/SQL Developer Debugging constantly hangs when I start the debugger and never comes back.

My first attempt is usually fine but after that I try recompile the proc and referencing objects and that help some times but not always.

Otherwise the IDE locks up. I usually have to close the window and start over.

When I test the proc without debugging it runs without issues.

This has become a royal pain in the butt.

Any assistance is greatly appreciated!!!

 

[a_kassabian]

Are you using the Oracle 11g client? If so, this is a previously reported issue for which there is no fix yet.

Ara

 

[Garrett]

jgemoll
Your debug script probably has a invalid pl/sql code.
See my post - http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=005346

 

[jgemoll]

I'm using the Oracle 10g client.

I would agree with the invalid code but if I execute the procedure it runs fine. Only when I use the debugging tool my environment hangs.

Thanks,
Judy

 

[Nico Scholtz]

We have just upgraded to 10g RAC and now have the same problem. It is however intermittant. Sometimes it works, most times it doesn't.

We have tried setting up a single server in TNSNAMES and have switched off "Update call stack after each step" with no joy.

We would sincerely appreciate any help or suggestions.

 

[sagizvi]

Hi Nico.
Dbms_debug gets hang in our place (11g) when the oracle spatial option is installed.
we installed spatial but not using it, so by deactivating a trigger called mdsys.sdo_geor_err_trigger , the debuuger is now working.

 

[Albert]

This trouble is quite clear (for my mind)http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=005248;p=1#000000
Therefore we are waiting for Pl/SQL Developer team when they will fix an error

 

[Nico Scholtz]

Albert

Have you had any response from AlroundAutomations Support to your quoted posting?? If not, why not?? They should either agree and fix it or prove you wrong.

This problem is driving me nuts! It makes PL/SQL unsuitable for debugging code.

 

[diosmiux]

Have you enabled automatically PLS/SQL beautifier before compiling?

I disabled it and doesn't hung anymore.

 

[Nico Scholtz]

We have resolved the problem of the debugger hanging when using a server cluster by logging in to a specific server.
Our development environment consists of two servers in a cluster and the normal TNSNAMES for the regular application is:

AP75TEST.PBMR.CO.ZA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hqifsd01-vip)(PORT = 2000))
(ADDRESS = (PROTOCOL = TCP)(HOST = hqifsd02-vip)(PORT = 2000))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AP75TEST)))

For debugging purposes, log in to a dedicated single server with:

AP75TEST1.PBMR.CO.ZA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hqifsd01-vip)(PORT = 2000))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = AP75TEST1)))

This resolved the problem for us. All the rest of the settings can be stock standard.
Good luck.

 

[Albert]

Albert
Have you had any response from AlroundAutomations Support to your quoted posting?? If not, why not?? They should either agree and fix it or prove you wrong.

Unfortunately there is no any response...

 

[Jami]

Albert,
I also face the same issue. The IDE hangs when I try debugging.
I removed the cluster of server names in TNSNAMES and am connecting to the dedicated server. It does not help me.

Does AllAroundAutomation care about this debugging issue.

 

[Albert]

Jami
Allround Automation Support team doesn't show an interest in fixing this error

 

[rayma1]

Hi Guys,

I also encounters same problem once in a while. What I usually do with it is I logout/login. I also encounter the same problem whenever I forgot to add debug information on the program I am debugging.

Regards,

 

[rayma1]

I noticed that when I am connecting to a RAC database, the debug does not work.

I am able to run the debug by selecting only one server/host.

Hopefully, they would fix the issue with the DEBUGGER when connected to RAC.

 

[Theod]

Hi,

For debuggin you have to connect to one explizit Rac-node. Then debug works.
If you connect via Loadbalancer, debug don't work, because the debug sesson is than connected to any node.