Internal error when extracting multiple users's ddl

Hi.

Using sqlnav v7.1.0.3676

  1. DB explorer (F12)
  2. expand users node
  3. select user
  4. rightclick for context menu
  5. extract DDL
  6. OK

DDL extracts succesfully, but is followed by Internal error, see ERROR.LOG for details.

v7.1.0 2014-08-05 11:29:38 Task “Extract DDL for 1 object(s)” in DoTerminate(): Access violation at address 01D136C2 in module ‘sqlnavigator.exe’. Read of address 00000000

Subsequently the context menu is incomplete, extract ddl is not available.

A new instance of DB explorer may be started, however when clicking OK in step 6 the Output shows: Internal error, see ERROR.LOG for details

v7.1.0 2014-08-05 11:31:09 Access violation at address 01D13585 in module ‘sqlnavigator.exe’. Read of address 00000000

Hi Tony,

Could you provide more environment information for helping us to reproduce this issue?

like OS info, DB versions which you use, or attach your issue photos for us.

Thanks,

Michael

Sure.

The system summary from msinfo32 is as follows:

  • [System Summary]
  • Item Value
  • OS Name Microsoft Windows 7 Professional
  • Version 6.1.7601 Service Pack 1 Build 7601
  • Other OS Description Not Available
  • OS Manufacturer Microsoft Corporation
  • System Name TONYWIN7PRO
  • System Manufacturer VMware, Inc.
  • System Model VMware Virtual Platform
  • System Type x64-based PC
  • Processor Intel® Core™ i7-2720QM CPU @ 2.20GHz, 2199 Mhz, 2 Core(s), 2 Logical Processor(s)
  • BIOS Version/Date Phoenix Technologies LTD 6.00, 7/31/2013
  • SMBIOS Version 2.4
  • Windows Directory C:\Windows
  • System Directory C:\Windows\system32
  • Boot Device \Device\HarddiskVolume1
  • Locale United States
  • Hardware Abstraction Layer Version = “6.1.7601.17514”
  • User Name TONYWIN7PRO\Tony
  • Time Zone Central Europe Daylight Time
  • Installed Physical Memory (RAM) 2.00 GB
  • Total Physical Memory 2.00 GB
  • Available Physical Memory 687 MB
  • Total Virtual Memory 4.00 GB
  • Available Virtual Memory 1.72 GB
  • Page File Space 2.00 GB
  • Page File C:\pagefile.sys
    As you can see I’m running windows via VMWare.
    I have attached the full file as it contains other information which may, or may not, be of use to you.

Database stuff:

  • Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
  • PL/SQL Release 12.1.0.1.0 - Production
  • CORE 12.1.0.1.0 Production
  • TNS for Linux: Version 12.1.0.1.0 - Production
  • NLSRTL Version 12.1.0.1.0 - Production
    I’m afraid that all of our databases have been upgraded so I cannot check to see if this is specific to 12.1 - Sorry.
    tony Reed-sqlnav7-access_violations.zip (33 KB)

Hi Tony,

Could you have a try to follow these steps:

  1. backup your user profile. (%userprofile%\AppData\Roaming\Quest Software\SQL Navigator 7.1.0), then delete it

  2. open Registry, backup HKEY_CURRENT_USER\Software\Quest Software\SQL Navigator 7.1.0, then delete it

  3. reopen Nav, click on cancel button for using new profile and layout

Retry your issue steps again, to see if still have Internal error

Michael