Toad World® Forums

Stability and other issues with commercial version 7.2

I installed the new commercial version of SQLNAV 7.2. After a few minutes working (editing a package body) and immediately after the list of available functions appeared ( autocomplete feature after a ‘.’) an internal error occured but the application did not terminate. I noticed that the connection had been lost due to this error (invalid OCI HANDLE but there were no network or other reasons for the connection to be broken) I reconnected and continue working. Then, after quite some work a fatal error occured and the application terminated. I should have been wise enough to restart sqlnav but the work lost is not the actual issue. After this (the first error occuring so soon) I dont think I can trust the tool until a patch is released addressing the stability issue.

(The sqlnavigator log file is pasted at the end of post)

An other issue has to do with formatting large oracle packages.

I noticed the following:

I have a rather large stored package (the body is about 13.000 lines of code after auto formating).

If I collapse some procedures in the package body and then autoformat the code

The cursor moves to the top of the package and the vertical scroll bar disppears.

There is no way to move further down (the cursor moves down but there is no scrolling and it disappears)

In order to restore functionality you just collapse an expand the whole package body

Version : 7.0.7.1
Date : Thu, 23 Apr 2015 11:59:55 +0300
OS : Microsoft Windows 7 (64 bit)
RAD : BDS 9.0
Dump : $F0 $0F $B0 $23 $74 $94 $F3 $90 $80 $3D $ED $A8 $4B $21 $00 $75 $EA $51 $52 $6A $00 $E8 $5D $F4 $FF $FF $5A $59 $B8 $00 $01 $00
Section : ExitThreadHook
Descr :

Address : $214B5325 - [214B0000] borlndmm.dll - Borlndmm - - (possible SysFreeMem+129) - 0[129]
Module : borlndmm.dll
Exception : EAccessViolation
Message : Access violation at address 214B5325 in module ‘borlndmm.dll’. Write of address 000204B0
Call Stack : 00 $214B5325 - [214B0000] borlndmm.dll
01 $006D39A3 - [00400000] sqlnavigator.exe - ExceptionLog7 - - FullInternalErrorReport - 709[1563]
02 $004EDAE4 - [00400000] sqlnavigator.exe - EBase - - InternalErrorSet - 823[572]
03 $0054A7DD - [00400000] sqlnavigator.exe - EThreadsManager - - ExitThreadHook - 1404[193]
04 $0A1CAB2F - [0A090000] PLSQL_debugger.dll - EThreadsManager - - ExitThreadHandler - 2146[195]
05 $0A1C9701 - [0A090000] PLSQL_debugger.dll - EThreadsManager - - ExitThreadHook - 1396[133]
06 $0D147EAF - [0D010000] data_editors.dll
07 $0D146A81 - [0D010000] data_editors.dll
08 $774A338B - [77490000] kernel32.dll

LastAddr : $214B5325 - [214B0000] borlndmm.dll - Borlndmm - - (possible SysFreeMem+129) - 0[129]
LastModule : borlndmm.dll
LastException : EAccessViolation
LastMessage : Access violation at address 214B5325 in module ‘borlndmm.dll’. Write of address 000204B0
Call Stack : 00 $169B7A28 - [16980000]
01 $006D3503 - [00400000] sqlnavigator.exe - ExceptionLog7 - - FullInternalErrorReport - 572[379]
02 $004EDAE4 - [00400000] sqlnavigator.exe - EBase - - InternalErrorSet - 823[572]
03 $0054A7DD - [00400000] sqlnavigator.exe - EThreadsManager - - ExitThreadHook - 1404[193]
04 $0A1CAB2F - [0A090000] PLSQL_debugger.dll - EThreadsManager - - ExitThreadHandler - 2146[195]
05 $0A1C9701 - [0A090000] PLSQL_debugger.dll - EThreadsManager - - ExitThreadHook - 1396[133]
06 $0D147EAF - [0D010000] data_editors.dll
07 $0D146A81 - [0D010000] data_editors.dll
08 $774A338B - [77490000] kernel32.dll

ActiveObj : ()
ActiveAddr :

Bug report file is located here:
C:\Program Files (x86)\Dell\SQL Navigator for Oracle 7.2\sqlnavigator.log

Learn more about internal errors (for developers):
http://www.eurekalog.com/help/eurekalog/internal_errors.php

Hi Mastorakis,

Could you find the “sqlnavigator.el” file under your data folder? if yes, send it to me please, thanks.

my e-mail address: alan.yang@quest.com

Regards.

Alan

Although I found an el file under an old beta directory, I think is the one you are looking for
sqlnavigator.el.txt (323 KB)

Hi Mastorakis,

Could you find any “sqlnavigator.el” file under the directory " %AppData%\Dell\SQL Navigator 7.2.0\ " ?

I have trouble uploading the file

It says is uploaded but even if I press save I don’t see it in the post

From:
Alan.Yang [mailto:bounce-AlanYang@toadworld.com]

Sent: Friday, April 24, 2015 11:13 AM

To: sqlnavbeta@toadworld.com

Subject: RE: [SQL Navigator - Beta Discussion Forum] Stability and other issues with commercial version 7.2

RE: Stability and other issues with commercial version 7.2

Reply by Alan.Yang

Hi Mastorakis,

Could you find any “sqlnavigator.el” file under the directory " %AppData%\Dell\SQL Navigator 7.2.0\ " ?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator - Beta
notifications altogether.

SQL Navigator - Beta Discussion Forum

Flag
this post as spam/abuse.

I Hope that the file I managed to upload is the one you requested.