Toad World® Forums

Collaboration Toad for Oracle and SQLAssistant.

Good day.
We use Toad for Oracle 12.1 and SQLAssistant 6.4 for development works. In the process of interaction between Toad and SQL Assistant, Toad displays an exception and crash.

We connected to SQL Assistant technical support. Here is their answer: “Toad for Oracle version 12 is based on Delphi and internally they use Eureka Log 7 library which doesn’t handle exceptions correctly (it’s a bug in their component vendor’s code). Our developers says that Eureka Log 6 and previous versions used in Toad for Oracle 11.x work fine, so that it is a regression on their part. Each time SQL Assistant raises an internal handled exception (which is normal, it raises exceptions in many places), Eureka Log crashes and brings everything down. with it.”

We connected to Eureka Log technical support. Here is their answer: “Sorry, but we cannot help you.
Please send this report to the Toad Developers. They are using an out-of-date version of our product and they have not configured it correctly. If they have purchased our product, they are entitled to an update to the latest version. That is the only fix.The Toad developers should contact us directly.”

Could you help us to fix the exceptions from Eureka Log 7 in Toad12 while SQLAssistant interaction?

Toad trace log:

Version : 7.0.3.0
Date : Wed, 2 Oct 2013 14:03:41 +0400
OS : Microsoft Windows 7 (32 bit)
RAD : BDS 9.0
Dump : $3A $0A $74 $17 $3A $4A $01 $74 $11 $3A $4A $02 $74 $0B $3A $4A $03 $74 $05 $83 $C2 $04 $EB $E8 $42 $42 $42 $89 $D1 $5A $29 $D1
Section : ExceptionHandlerHook
Descr :

Address : $0419A683 - [04190000] Toad.exe - System - - _UStrFromPChar - 0[7]
Module : Toad.exe
Exception : EAccessViolation
Message : Access violation at address 0419A683 in module ‘Toad.exe’. Read of address 00000387
Call Stack : 00 $0419A683 - [04190000] Toad.exe
01 $0446281F - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 704[1559]
02 $0427BCCE - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]
03 $0445D43E - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]
04 $77450AAB - [77440000] ntdll.dll
05 $7745F9CB - [77440000] ntdll.dll
06 $7745F8D0 - [77440000] ntdll.dll
07 $77486FF2 - [77440000] ntdll.dll
08 $1E23341A - [1E090000] SqlAssistPrefs.dll
09 $1E38A667 - [1E090000] SqlAssistPrefs.dll
0A $1E38B9E4 - [1E090000] SqlAssistPrefs.dll
0B $1E38BEB1 - [1E090000] SqlAssistPrefs.dll
0C $7626ED6A - [76220000] kernel32.dll

LastAddr : $0419A683 - [04190000] Toad.exe - System - - _UStrFromPChar - 0[7]
LastModule : Toad.exe
LastException : EAccessViolation
LastMessage : Access violation at address 0419A683 in module ‘Toad.exe’. Read of address 00000387
Call Stack : 00 $12C57B20 - [12BD0000]
01 $0446237F - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 570[375]
02 $0427BCCE - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]
03 $0445D43E - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]
04 $77450AAB - [77440000] ntdll.dll
05 $7745F9CB - [77440000] ntdll.dll
06 $7745F8D0 - [77440000] ntdll.dll
07 $77486FF2 - [77440000] ntdll.dll
08 $1E23341A - [1E090000] SqlAssistPrefs.dll
09 $1E38A667 - [1E090000] SqlAssistPrefs.dll
0A $1E38B9E4 - [1E090000] SqlAssistPrefs.dll
0B $1E38BEB1 - [1E090000] SqlAssistPrefs.dll
0C $7626ED6A - [76220000] kernel32.dll

ActiveObj : (Non-Delphi exception) External exception 0EEDFADE 1E23341F 134610C0 13520140 13460698 1FEFFEC8 1FEFFD90 1FEFFD20
ActiveAddr : $1E23341F - [1E090000] SqlAssistPrefs.dll - SqlAssistPrefs - - LicenseType - 0[124003]

We are on the latest version. I don’t know anything about the internals of SQL Assistant or how they are using exceptions, but Toad also raises exceptions internally and traps them and there are no issues. Eurekalog should be trapping only unhandled exceptions. Exceptions that are raised and properly handled should never be grabbed by Eurekalog.