Toad completely shuts down when schema is locked/unlocked

Toad for Oracle - Beta
1

This issue is the reason I started to use toad beta. I was working with toad support for 2 months and we never found the issue. So I came to the toad beta to see if we can fix it.

I have a script that when a developer needs have a refresh of a oracle schema to a clean “production like” version, I lock the schema, kill all sessions, drop all objects, then datapump the prod like into dev. Toad’s issue is when I do not close the schema in toad and a schema is refreshed, toad will just shut down completely. No warning, no error, no response. Just terminates the process. The only steps to repo that I have to recreate this issue is when I have multiple connections, 1 to the refreshed schema and other “normal” schemas. When I touch toad(i see no pattern), the app will shut down.

I do not know of any toad logs that will capture the error. I checked the windows event viewer and nothing in the logs. When talking to support, they asked me to reinstall toad a few times, clean out the registry, clean out old toad files and installs, check dlls, and few other trouble shooting. Nothing has helped.

What can we do?

2

Happens once a day, any thing i can help with?

3

Just to make sure I understand -

The user is connected, you kill his session (from another Toad or SQL*Plus or whatever), that’s when his Toad shuts down on its own? Is the user’s Toad idle, or is he in the middle of doing something when it closes?

4

Toad will stay open until it gets window’s focus. If I do not touch toad in anyway it(at least its icon) stays up. i click on the task bar icon, then click anywhere in toad, toad will shutdown with no warning or dialog.

5

It sounds like as soon as it receives focus, some query is firing, and not having its error handled properly, and that’s what sends it into its tailspin. I’m not seeing any query fire though when I just put focus on my Toad. So, try this for me -

With the schema not locked and sessions not killed, but in the copy of Toad that keeps crashing, go to the main menu -> Database -> Spool SQL -> Spool to screen. That will capture whatever SQL Toad executes. So then move focus on and off of Toad and see if it captures any SQL at the bottom of the screen. If it does, please post it here or email it to me: john.dorlon@quest.com Thanks.

6

So I opened the spool file and tried again, actually 3 times. The first time I ran it with the spool, i received a different response, now a windows compatiblity error. Clicked ok and toad closed again. Screenshots attached. I checked the compatibility tab in properties of toad.exe and I see nothing checked.

When I logged back into toad and ran the schema rebuild script the second and third time all works fine and I get a oracle msg" ORA-01012: not logged on". (Cool loving this message.) I will keep testing and tell you what I find. Testing takes an hour for each run, so time will tell. The last msg in the spool was

Session: FX_MARC_C@DEV11G
Timestamp: 13:56:08.062
Select cols.column_id, cols.column_name as Name, nullable,
data_type as Type,
decode(data_type, ‘CHAR’, char_length,
‘VARCHAR’, char_length,
‘VARCHAR2’, char_length,
‘NCHAR’, char_length,
‘NVARCHAR’, char_length,
‘NVARCHAR2’, char_length,
null) nchar_length,
Decode( data_type, ‘NUMBER’, data_precision + data_scale, data_length ) Length,
data_precision Precision, data_scale Scale, data_length dlength, data_default
,’ ’ comments
, DATA_TYPE_MOD
,cols.CHAR_USED
,cols.hidden_column, cols.internal_column_id
, qualified_col_name
,InitCap(histogram) histogram
,cols.virtual_column
,num_distinct, num_nulls, round(density, 5) density
FROM
sys.user_tab_cols cols
where 1=1
and cols.table_name = :TABNAME
order by internal_column_id
Error: ORA-03113: end-of-file on communication channel
Process ID: 13117
Session ID: 196 Serial number: 41087

FYI, this has always been an intermittent issue, so it still might be there. Rebooting now to get a clean environment.

7

I was looking in the event viewer and found these errors. Prior to the last crash, the event view never had any errors pertaining to toad.

Faulting application name: Toad.exe, version: 12.7.0.43, time stamp: 0x54e2261a

Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x5315a05a

Exception code: 0xc000041d

Fault offset: 0x000000000000940d

Faulting process id: 0xdbc

Faulting application start time: 0x01d04ba5f8b0b81a

Faulting application path: C:\Program Files\Dell\Toad for Oracle 12.7 Beta\Toad.exe

Faulting module path: C:\Windows\system32\KERNELBASE.dll

Report Id: 14f817f4-b79c-11e4-9312-3417eb976e28

Faulting application name: Toad.exe, version: 12.7.0.43, time stamp: 0x54e2261a

Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x5315a05a

Exception code: 0xc000041d

Fault offset: 0x000000000000940d

Faulting process id: 0xdbc

Faulting application start time: 0x01d04ba5f8b0b81a

Faulting application path: C:\Program Files\Dell\Toad for Oracle 12.7 Beta\Toad.exe

Faulting module path: C:\Windows\system32\KERNELBASE.dll

Report Id: 14f817f4-b79c-11e4-9312-3417eb976e28

8

Hi Marc,

Thanks, and sorry, I wasn’t asking you to go through the whole “refresh the schema” process, just to turn on spool sql on the copy Toad that’s giving you problems, to see what it’s trying to do when it gains and loses focus, because presumably that’s what it’s bombing out on when it crashes.

The query above loads the column details of the selected table in the Schema Browser or Object Palette. As far as I can tell, the only way it runs is if you click on a particular table in one of those places. I tried doing that in both places after the session was killed and locked and Toad didn’t crash for me, just gave a few expected errors.

One possible reason for this being an intermittent problem is that maybe it depends where you click in Toad to give it focus. Does it still crash if you click somewhere in Toad that doesn’t make anything happen? Such as the title (top) or status (bottom) bar?

We’re in the beta forum, so I’m assuming that this is all happening in the current beta, but if not, let me know. Also, please let me know if this is happening in 32 or 64 bit Toad. I’ve been trying all this in 32 bit, but I’ll try 64 too.

Thanks.

-John

9

I’m not sure that this is options related, but if you zip up the user files folder of the crashing Toad and email it to me, I’ll try it with those settings. My email addy is in my 2nd reply to this thread.

10

64 bit. Not sure if the zip file will help. Support tried to fix it with the applied settings in the 12.6 and I also reinstalled toad a few times and wiped out all the settings a few times and it still is an issue. I will still mail you the settings. I looked around how to find what settings where applied for the compatibilitymode and I found the registry entry, but it is binary and I can not read it.