Problem with Test screen (Debug)

[fidelfs]

I am having issues when I try to debug a package. I will explain the behavior.

-- First time I run the test (f9), I see all the icons grayed out. I cannot click the step into icon.
The test screen never comes back, I try to break it but nothing happen and I forced to cancel the session.

-- I have to cancel using task manager.

-- I restart Pl/SQl developer and the crash recovery let me recover my sesion.

-- I execute the test (f9) and now I can step into. no problem. I can finish the debug.

-- I try again then the problem starts again. It does not let me step into so I have use task mana...... etc.

Do you know what may cause this issue? I read another post similar and follow the advise and asked the dba to reload the packages for debug in 10g, but I still have the same issue.

Here is some technical info:

We are using Oracle applications 11.5.10

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
02.27959 - Unlimited user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 1,047,784 kB (474,776 available)
Paging file : 2,520,708 kB (2,078,524 available)
Virtual memory : 2,097,024 kB (1,993,224 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\fidel_fernandez\default.ini

Plug-Ins
*Comment lines v1.3 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*LBC Recall Named SQL (C:\Program Files\PLSQL Developer\PlugIns\LBCNamedSQL.dll)
*PasteOptions 1.2 (C:\Program Files\PLSQL Developer\PlugIns\PasteOptions.dll)
*PL/SQL Developer Scale Plug-In version 2003/11/13 (C:\Program Files\PLSQL Developer\PlugIns\Scale.dll)
*SesInfo (2.2) www.softema.com (C:\Program Files\PLSQL Developer\PlugIns\SesInfo.dll)
*Shortcuts Plug-In v1.2 by Tiger (C:\Program Files\PLSQL Developer\PlugIns\shortcuts.dll)
*texType (2.1) - www.softema.com (C:\Program Files\PLSQL Developer\PlugIns\texType.dll)
*wList (2.5) - www.softema.com (C:\Program Files\PLSQL Developer\PlugIns\wList.dll)
(* is Active)

Aliases
adev.world
aib.world
aird.world
aird1.world
aird2.world
...

Homes
ORACLEHOME (C:\ORACLE)
OraClient10g_home1 (C:\Oracle\product\10.1.0\Client_1)
Tools_Home (C:\ORACLE_Tools)

DLLs
C:\ORACLE_Tools\bin\oci.dll
C:\ORACLE_Tools\bin\ORA803.DLL
C:\ORACLE_Tools\bin\ORA804.DLL
C:\ORACLE_Tools\bin\ORA805.DLL

TNS File
C:\ORACLE_Tools\NET80\Admin\tnsnames.ora

Using
Home: Tools_Home
DLL: C:\ORACLE_Tools\bin\oci.dll
OCI: Version 8.0
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Character size: 3 byte(s)

 

[Marco Kalter]

If the Test Window hangs, it may be that the server process has died. Check if a trace file exist that is related to the problem, and if so, send it to me.

 

[Mic R. W. Buchanan]

I get this problem and the no trace file can be found. I have uninstalled the application, since it has worked rather successfully previously.

We reloaded the debug packages and it made no difference. Any other ideas?

 

[Marco Kalter]

You could try to shutdown/restart the instance, and/or increase the shared pool size of the instance. Maybe memory requirements have changed over time for your instance.

 

[Hongfei Sun]

Hi all,I'm chinese coder.
I'm sorry about you problem.

 

[Hongfei Sun]

But i agree with the ideas above.