Toad World® Forums

error.log file in 7.0 beta

SQL NAVIGATOR ERROR LOG

v6.7.0 2012-07-03 16:58:19 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:20 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:21 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:21 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:26 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:31 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-07-03 16:58:31 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-06 12:23:00 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-06 17:47:36 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-06 17:47:47 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-06 17:47:48 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-06 17:47:55 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-08-16 14:06:18 Exception EInvalidOperation in module sqlnavigator.exe at 00062E87. Cannot focus a disabled or invisible window.
v6.7.0 2012-08-22 15:19:32 Exception EOraError in module sqlnavigator.exe at 002D423A. ORA-02290: check constraint (LHADMIN.CK_JOB_LIB_APPROVAL_FLG) violated
v6.7.0 2012-08-22 15:20:08 Exception EOraError in module sqlnavigator.exe at 002D423A. ORA-02290: check constraint (LHADMIN.CK_JOB_LIB_CONNECTION) violated
v6.7.0 2012-09-10 13:08:12 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 09:41:53 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 09:41:54 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 09:41:56 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 09:41:57 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 09:41:59 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-14 14:43:48 Exception EInvalidOperation in module sqlnavigator.exe at 00062E87. Cannot focus a disabled or invisible window.
v6.7.0 2012-09-28 09:28:01 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v6.7.0 2012-09-28 09:28:03 Exception EOleException in module sqlnavigator.exe at 009FEFF9. Error -2147418113 has occurred.
v7.0.0 2013-05-15 11:14:46 Access violation at address 01792FE1 in module ‘sqlnavigator.exe’. Read of address 00000000
v7.0.0 2013-05-15 11:14:46 Access violation at address 01792FE1 in module ‘sqlnavigator.exe’. Read of address 00000000
v7.0.0 2013-05-15 11:14:46 Access violation at address 01792FE1 in module ‘sqlnavigator.exe’. Read of address 00000000

We are able to duplicate the crash in nav 7 that appears related to the .notation in the new editor.

We built a query that accesses 3 different tables. The 3rd table we use an alias sch

The popup window is trying to show schema but it flashes closed quickly.

This continues to happen as you complete the rest of the query.

Eventually the buffer overflows and kaboom. No more nav.

I am trying to build a specific set of tables that will return this. We are able to duplicate this consistnatly in our environment with existing tables. I have not been able to do this on new tables in a test schema.

Good luck - it’s a bit tricky to find but definately a show stopper.

Start with this query

select gs.group_num, gs.plan_num, count(ac.acct_id) acct_countfrom lhods.account ac, lhods.group_structure gswhere ac.group_entity_id = gs.subgroup_idand ac.system_code =‘PCRA’ group by gs.group_num, gs.plan_numorder by count(ac.acct_id)

Then add

Add a new table rsadmin.schedules as schJoin gs.group_num to sch.group_number And gs.plan_num to sch.plan_number

When typing sch. the popup window will flash to hint that nav is suggesting to use the word schema. But as you enter then 2nd join - kapoof.

thanks for the details
I believe this is the same issues as post: http://sqlnavigator.inside.quest.com/thread.jspa?threadID=38971&tstart=0

I have raised PT49970503, we will post a new build soon once we have fixed and tested dot lookup again.

thanks
Lidia