Toad World® Forums

SQL Nav 6.2 Opening Tables


#1

Hi

Forgive me if this has already been brought to your attention. Please let me know if I should log a call via another method.

When I try to open a table via the Toolbox (Toolbox -> DB Explorer -> Schema -> Table)

I have tried the following:
Right mouse button menu -> Open: 9:59:58 Internal error occurred; see file ERROR.LOG for details

Ctrl + F2: Navigator Crash

Enter: Navigator Crash

F3 - Generates and executes a select stmt for the table (this works as expected)

In the code editor
Highlight table, Ctrl + Enter (go to definition): Navigator Crash
Right mouse button menu -> Go to definition: Navigator Crash

Is this something in my setup?

Kind regards,
Annelize


#2

Hi Annelize,

Thanks for raising this. We’re sorry for what you experienced :(. Could you please tell me what the build number is of the 6.2 that you use? And what is the OS/Windows version that you’re running Nav? More information would help.

Thanks,
Vincent


#3

Hi Vincent

Thanks for the quick response!

I’m running SQL Navigator Release 6.2.0.1500 with Windows XP Professional, Service Pack 3

Please let me know if you require any other information.
Annelize


#4

Thanks for the information Annelize. SQL Nav should work fine with Window XP.

Does the error happens to all tables that under your Schema? And how about those in Other Schema?

If the error only happens in one/certain table(s), I would like to get the Extract-DDL for the table(s) if possible. You can get it by right-click then Exctract DDL on a table. If the error happens to all the tables or a lot of tables in you database, I would like to get the information about: 1) which oracle client is Nav using? 2) what is the version of Oracle database Nav connects to? 3) the Extract-DDL of your logon user if possible. (you can get it from Exctact DDL function in DB Navigator when selecting this user).

This is a big issue to us and we will surely pay much attention on it until we nail it.


#5

The error / crash happens with all tables in my Schema as well as Other Schema.
I was also able to reproduce the error opening tables via the normal DB Navigator (F12)

  1. Oracle Client: 10.2.0.1.0
  2. Oracle Database version: 9.2.0.7 and 10.2.0.4
  3. Extract-DDL of logon user PAS: (same error occurs when logged on as SYSTEM)

– Start of DDL Script for User PAS
– Generated 17/08/2009 11:12:32 from SYSTEM@DEVELOP9

CREATE USER pas
IDENTIFIED BY
DEFAULT TABLESPACE CLINICAL
TEMPORARY TABLESPACE TEMP
/
GRANT ALTER SESSION TO pas
/
GRANT ANALYZE ANY TO pas
/
GRANT CREATE ANY CONTEXT TO pas
/
GRANT CREATE ANY DIRECTORY TO pas
/
GRANT CREATE EVALUATION CONTEXT TO pas
/
GRANT CREATE RULE TO pas
/
GRANT CREATE RULE SET TO pas
/
GRANT CREATE SESSION TO pas
/
GRANT CREATE USER TO pas
/
GRANT CREATE VIEW TO pas
/
GRANT DROP USER TO pas
/
GRANT SELECT ANY DICTIONARY TO pas
/
GRANT SELECT ANY SEQUENCE TO pas
/
GRANT SELECT ANY TABLE TO pas
/
GRANT UNLIMITED TABLESPACE TO pas
/
GRANT CORP_USER TO pas
/
GRANT DBA TO pas
/
GRANT PAS_USER TO pas
/
ALTER USER pas DEFAULT ROLE ALL
/

– End of DDL Script for User PAS


#6

Hi Annelize,

Thanks for all the information. We’ll look into this and get back to you once we get anything or need anything else. It’s evening in the location of our Dev team. We’ll work on this after we start to work tomorrow. At the same time, if you feel needing, you can contact Quest support by Submit Feedback under Help menu.

Vincent


#7

Thank you for all your help Vincent!
A


#8

Hi Annelize,

I would like to follow up with Vincent’s note. Could you please send in the Support Bundles file. Under Help->Submit Feedback, please click ‘Save to file’ button to save the file SupportBundle.dta to a location on disk. Please attach the file with your reply post.

We have tried with all the systems and environments but could not reproduce it. This is the first case we are aware of :-).

We will try to keep you posted with more updates once we get the support bundle file from you.

  1. Could you please also please advise that if you would have an early version(s) (v5.5, 6.0, 6.1) installed and whether you would have the same issue in those earlier versions?

  2. Can you create a new table? If so, can you open the new table?

  3. If it is possible, could you please export one of the table that you have problem with, send us the .dmp file using the Export table feature, under Main menu Object->Export table, please select the table that you can provide us. If due to security, please ignore this request. Thks

  4. Would you also please try one thing in v6.2, please check the NLS preference as attached screenshot, please set it to ‘No Support’, then restart SQL Navigator. Please repeat those steps that you reported earlier and see if you could open the Table Editor.

Thanks and regards,
Bruce
Message was edited by: bruceduong

Message was edited by: bruceduong
Pref.jpeg


#9

Hi Bruce

We only had a laptop with Nav 5.5 on, so we installed 6.1 and it worked without a problem. After that, I installed 6.2 and I was still able to open a table without any issues.

I have now completely uninstalled Quest from my machine and re-installed 6.2. I can now open all tables in all the ways mentioned before. We’re now doing the same with all the other PC’s.

Thank you for your help!
Annelize


#10

Hi Annelize,

Thank you for your update, and glad to hear that it works for you now after re-install. Please let us know if you would have the problem again, we would like to get to the underlined issue on your system.

Thanks and regards,
Bruce


#11

Thank you Bruce


#12

I’ve upgraded from 6.1.1 and had the same problem. SQL Nav would close itself when going to table definition.
Un-installed everything and re-installed 6.2, now no problem.


#13

Thanks for the feedback, Patrick. This really help :slight_smile:

Hi Annelize, we have figured out the cause that makes SQL Nav crash. When you try to open a table, a dll needs to be loaded by the Table Editor UI. Everything should work well within 6.1 or 6.2. But the problem comes from an unexpected failure with installing 6.2 into the 6.1 folder - the data_editors.dll fails to be upgraded/replaced. unfortunately, SQL Nav 6.2 is not compatible with the dll of 6.1. It fails to handle the exception then crash :(.

The failure of replacing the dll when installing 6.2 cannot be reproduced by our testing. We’ll work on this to avoid happening again in the future release. For now, if anyone meets the error again, please uninstall SQL Nav and remove the files in SQL Nav folder if there’s any file left. Then reinstall SQL Nav. Problem will be solved. By a simple way, you can also get the zipped dll file in the attachment here then unzip it and put it into SQL Nav folder next to sqlnavigator.exe, replacing the old dll.

Thanks,
Vincent
data_editors.zip (734 KB)


#14

Vincent, it’s great that you guys managed to track down the problem! Thanks for all your help.