Toad World® Forums

More error ugliness


#1

This morning, with only three tabs open, one of which was sqlserverpedia web
page, I received the following stack trace. This was after clicking on one of
the tabs.

System.NullReferenc eException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.SqlServe r.ActionHandler. DTC.DTCInvoke. .ctor()
at Quest.Toad.SqlServe r.Trl.DTC. DTCListTrl. get_ImageIndex( )
at Quest.Toad.Database Browser.ObjectPa letteControl. SetNodeImage( TreeListNode
node, ITrl trl)
at Quest.Toad.Database Browser.ObjectPa letteControl. RebuildUI( )
at Quest.Toad.Database Browser.ObjectPa letteControl. set_CurrentType( String
value)
at Quest.Toad.Database Browser.ObjectPa letteControl. SetActiveTrl( ITrl trl)
at Quest.Toad.Database Browser.ObjectPa letteControl. ConnectionChange dHandler(
Object sender, ConnectionEventArgs e)
at Quest.Toad.Notifica tion.ConnectionC hangedEventHandl er.Invoke( Object
sender, ConnectionEventArgs e)
at Quest.Toad.Notifica tion.Notificatio nManager. ConnectionChange d(Object
sender, Connection connection)
at Quest.Toad.Connecti onManager. ConnectionHierar chy.set_CurrentC onnection(
Connection value)
at Quest.Toad.Util. Global.set_ CurrentConnectio n(Connection value)
at Quest.Toad.Gui. DocumentConnecti onFollower. ConnectionChange d(Object
sender, EventArgs args)
at System.Windows. Forms.Control. InvokeMarshaledC allbackDo( ThreadMethodEntr y
tme)
at System.Windows. Forms.Control. InvokeMarshaledC allbackHelper( Object obj)
at System.Threading. ExecutionContext .runTryCode( Object userData)
at System.Runtime. CompilerServices .RuntimeHelpers. ExecuteCodeWithG
uaranteedCleanup (TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading. ExecutionContext .RunInternal( ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading. ExecutionContext .Run(ExecutionCo ntext executionContext,
ContextCallback callback, Object state)
at System.Windows. Forms.Control. InvokeMarshaledC allback(ThreadMe thodEntry
tme)
at System.Windows. Forms.Control. InvokeMarshaledC allbacks( )


#2

It seems from the exception trace that it’s not Toad failure (of course,
we should catch this exception and display some meaningful message to the user
instead) but rather you have some issues with DTC/DTC configuration on
either/both client or/and server. Can you try the same with other version of
Toad? 4.6 Freeware should be enough for this.

Thanks for reporting this,

Igor.


#3

Hi Igor,

It seems from the exception trace that it’s not Toad failure (of course, we
should catch this exception and display some meaningful message to the user
instead)

Perhaps, but even a simple syntax error in the simplest of statements –
“SELECTs 42” – in the Editor session throws:

System.NullReferenc eException
Object reference not set to an instance of an object.

Now on my 100+ line SELECT, it was considerably more difficult to determine
where the typo was.

Thanks!
Rich


#4

Yes, we discovered some issues with our formatter recently and we’re
working on resolving them.

But the initial question about DTC doesn’t seem to relate to this. Still,
can you check if you’ll have the same exception in 4.6 freeware (or 4.6
commercial if you have it)? If you won’t but still will have it in 5.0
beta then there is something we should take closer look into.

Thanks,

Igor.


#5

Yes, Igor, I have had this error in 4.6. At least I think so since it is very
hard to duplicate until it decides to happen, then happens frequently. But I
have had stack traces pop up when changing tabs in 4.6, I just don’t know if
they were identical to this one.

Tim


#6

Thanks, Tim, for the reply. I briefly looked into the code where DTC exception
is fired and I think there is a space for some improvement there…

As for other exceptions around the editor – as I said, we discovered some
issues with the formatter and are working right now to resolve them. It’s
a beta and we still have several weeks before the feature freeze.

Igor