PLSQLDEV 6.0.0.840 hangs using code assistant

[Alessandro]

Hi,
we are experiencing problems using PLSQLDEV 6.0.0.840 connecting on a particular 8.1.7 Database, there is no problem using PLSQLDEV 5 but when i use Code Assistant from verion 6 PLSQLDEV hangs without reporting any errors

This is the debug.txt file:

PL/SQL Developer 6.0.0.840 20000.6320 - Unlimited user license
C:\Programmi\PLSQL Developer\plsqldev.exe

01/09/2006 10.31.08 Application started
01/09/2006 10.31.08 SortPreferenceSets
01/09/2006 10.31.08 - Default train2
01/09/2006 10.31.08 - System Default
01/09/2006 10.31.52 Oracle Error: Session.
ORA-00942: table or view does not exist
At line 2, position 5
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
01/09/2006 10.31.52 SetSessionAction starts: Main session
01/09/2006 10.31.53 SetSessionAction ends
01/09/2006 10.31.53 ExecuteConnectScript starts
01/09/2006 10.31.53 ExecuteConnectScript ends
01/09/2006 10.31.53 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\oracle\ora92
Found: oci.dll
Using: C:\oracle\ora92\bin\oci.dll
01/09/2006 10.31.53 SortPreferenceSets
01/09/2006 10.31.53 - Default train2
01/09/2006 10.31.53 - System Default
01/09/2006 10.31.54 Create TChildListForm
01/09/2006 10.31.58 Create TSQLForm
01/09/2006 10.31.58 SQLForm

thanx in advance

 

[Marco Kalter]

Can you upgrade to 6.0.6 and try again? If it still hangs, then to obtain some more diagnostic information can you modify the shortcut and add the debug and debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Alessandro]

Hi Marco,
i can reproduce the problem in any Workstation using this version of PLSQLDeveloper, the problem seems to be in version 7 too..
Unfortunately i have no access to this remote database so i can't check directly for any kind of RDBMS system problems (but disabling the Code Asistant queries works as expected) :-(
This is the debug.txt entries from my PC using Oracle 8i oci.dll with debug parameters added:
PL/SQL Developer 6.0.0.840 20000.6320 - Unlimited user license
C:\Programmi\PLSQL Developer\PLSQLDev.exe

04/09/2006 11.22.45 Application started
04/09/2006 11.22.45 SortPreferenceSets
04/09/2006 11.22.45 - Default Administrator
04/09/2006 11.22.45 - System Default
04/09/2006 11.23.09 Oracle Error: Session.
ORA-00942: table or view does not exist
At line 2, position 5
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
04/09/2006 11.23.09 SetSessionAction starts: Main session
04/09/2006 11.23.09 SetSessionAction ends
04/09/2006 11.23.09 ExecuteConnectScript starts
04/09/2006 11.23.09 ExecuteConnectScript ends
04/09/2006 11.23.09 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\oracle\ora81
Found: oci.dll
Using: C:\oracle\ora81\bin\oci.dll
04/09/2006 11.23.10 SortPreferenceSets
04/09/2006 11.23.10 - Default Administrator
04/09/2006 11.23.10 - System Default
04/09/2006 11.23.11 Create TChildListForm
04/09/2006 11.23.11 GetCrashList: 131358.cfg
04/09/2006 11.23.11 GetCrashList: 198008.cfg
04/09/2006 11.23.14 Create TSQLForm
04/09/2006 11.23.14 SQLForm

mmmhhh, now i can see these new entries:
GetCrashList: 131358.cfg
GetCrashList: 198008.cfg

Regards
Alessandro

 

[Alessandro]

Any news?

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer 7.0 shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Alessandro]

Done..

Thanx
Alessandro

 

[Alessandro]

no news, good news? ;-)

Alessandro

 

[Marco Kalter]

Hmm, I'm not sure if I received the log file. Can you resend it?

 

[Alessandro]

re-sent to support@allroundautomations.com