RE: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

Toad for Oracle & DevOps Toolkit
1

Hi Jacob,

I can’t reproduce this issue. I made a DB connection then saved my workspace. I shut down Toad, shut down the DB, reopened Toad and opened my workspace. I get the same error about the DB not being available and click either OK or Jump and Toad is completely responsive.

I’m curious what happens if you open Toad, don’t select a workspace, just try to connect to this DB without loading a workspace. Same issue? If so, this issue could be more about the state of the DB. Is it shut down completely and unmounted? Is the DB in startup/shutdown mode? Do you have any custom scripts that run when you connect to this DB?

From: jacob.barnes [mailto:bounce-jacobbarnes@toadworld.com]

Sent: Wednesday, January 27, 2016 11:06 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

TOAD crashing when switching to a workspace in which a saved connection is offline.

Thread created by jacob.barnes

TOAD crashing when switching to a workspace in which a saved connection is offline.

I receive the error saying the database is offline, which is completely fine and expected. After clicking “ok” or “jump”, TOAD will hang and crash every time.

I assume the dev or support people read these, but they are wanting me to jump through too many hoops to submit a bug to the point the link in the email about the SR doesn’t even take me to the SR page, just the support home.

TOAD for Oracle 12.8.x

Windows 7

Database 11.2.0.3

Here is the error that should occur:

Here is the crash that shouldn’t occur:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

2

No custom scripts are ran. To be fair, the database was in the process of being refreshed with RMAN and when I said “offline” I should have said “not mounted”. This issue is most likely related to the state of the database as you suggest. If the database is truly shutdown the error I receive indicates it isn’t available and TOAD continues to respond. I should have clarified that, I apologize.

Please try to place the database in a STARTUP NOMOUNT state and try again. I was able to reproduce the error by doing so. In fact, the crash occurs without using the workspace functionality if I try to connect when the database is isn’t mounted.

Thanks,

Sent by an external sender. Use caution opening attachments, clicking web links, or replying unless you have verified this email is legitimate.

RE: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

Thread created by Brad Boddicker

Hi Jacob,

I can’t reproduce this issue. I made a DB connection then saved my workspace. I shut down Toad, shut down the DB, reopened Toad and opened my workspace. I get the same error about the DB not being available and click either OK or Jump and Toad is completely responsive.

I’m curious what happens if you open Toad, don’t select a workspace, just try to connect to this DB without loading a workspace. Same issue? If so, this issue could be more about the state of the DB. Is it shut down completely and unmounted? Is the DB in startup/shutdown mode? Do you have any custom scripts that run when you connect to this DB?

TOAD crashing when switching to a workspace in which a saved connection is offline.

Thread created by jacob.barnes

TOAD crashing when switching to a workspace in which a saved connection is offline.

I receive the error saying the database is offline, which is completely fine and expected. After clicking “ok” or “jump”, TOAD will hang and crash every time.

I assume the dev or support people read these, but they are wanting me to jump through too many hoops to submit a bug to the point the link in the email about the SR doesn’t even take me to the SR page, just the support home.

TOAD for Oracle 12.8.x

Windows 7

Database 11.2.0.3

Here is the error that should occur:

Here is the crash that shouldn’t occur:

To reply, please reply-all to this email.

3

I wasn’t able to get the pictures in my original post to load and I was able to communicate with the support team without going through all the extra steps. Because of which, I deleted my original post. I noticed this one you created and my reply contained some of my personal information. I edited my response, but don’t need to have this separate support thread. Will you please delete this post?

4

No worries. I’ll look for this case to come thought support then

From: jacob.barnes [mailto:bounce-jacobbarnes@toadworld.com]

Sent: Wednesday, January 27, 2016 12:15 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] RE: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

RE: RE: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

Reply by jacob.barnes

I wasn’t able to get the pictures in my original post to load and I was able to communicate with the support team without going through all the extra steps. Because of which, I deleted my original post. I noticed this one you created and my reply contained some of my personal information. I edited my response, but don’t need to have this separate support thread. Will you please delete this post?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

5

Some one from support suggested to rename file ToadActions.dat and after doing this, I closed laptop while leaving office and when logged to laptop it gave message ad do you want to connect and then it is not crashed only 2-3 times. I.e. 3rd time onwards again same problem of crahsing, rarely once in 1 week it is asking do you want to connect (I haven’t check check box for automatic connection). I am trying to raise request for SQL developer instead of following this stupid software. The following is the error message.

Problem signature:
Problem Event Name: APPCRASH
Application Name: Toad.exe
Application Version: 12.7.1.11
Application Timestamp: 55c8c6e3
Fault Module Name: ntdll.dll
Fault Module Version: 6.1.7601.19045
Fault Module Timestamp: 56259295
Exception Code: c0000005
Exception Offset: 0000000000027f25
OS Version: 6.1.7601.2.1.0.256.4
Locale ID: 1033

Regards

Sudarshan Reddy

6

I would take a look at this article from Microsoft on the issue-

https://support.microsoft.com/en-us/kb/2545627

On Jun 21, 2016, at 2:45 AM, sudarshan Reddy bounce-sudarshan_Reddy@toadworld.com wrote:

RE: RE: [Toad for Oracle - Discussion Forum] TOAD crashing when switching to a workspace in which a saved connection is offline.

Reply by sudarshan Reddy
Some one from support suggested to rename file ToadActions.dat and after doing this, I closed laptop while leaving office and when logged to laptop it gave message ad do you want to connect and then it is not crashed only 2-3 times. I.e. 3rd time onwards again same problem of crahsing, rarely once in 1 week it is asking do you want to connect (I haven't check check box for automatic connection). I am trying to raise request for SQL developer instead of following this stupid software. The following is the error message.

Problem signature:

Problem Event Name: APPCRASH

Application Name: Toad.exe

Application Version: 12.7.1.11

Application Timestamp: 55c8c6e3

Fault Module Name: ntdll.dll

Fault Module Version: 6.1.7601.19045

Fault Module Timestamp: 56259295

Exception Code: c0000005

Exception Offset: 0000000000027f25

OS Version: 6.1.7601.2.1.0.256.4

Locale ID: 1033

Regards

Sudarshan Reddy

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

7

I am not sure if this is the same bug but…

I recently discovered that the Object Palette in 64 bit Toad can cause a crash if you are changing to a connection that is no longer connected.

So if you have 64 bit Toad, and your Object Palette is open, then close the Object Palette and I think your error will go away.

The Object Palette bug is fixed for the next beta.