Toad World® Forums

DB2 Schema Browser


#1

While trying to browse the schemas I get this error:

ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 5008 Thread 1 AppDomain: Name:toad.exe
There are no context policies.
Function: AllocateandLinkStatementHandle
CallStack: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)
at IBM.Data.DB2.DB2Command.a(IntPtr& A_0, IntPtr& A_1, Boolean& A_2, Boolean& A_3, Boolean A_4)
at IBM.Data.DB2.DB2Command.GetStatementHandle()
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Quest.Toad.Db.ProxyCommand.ExecuteReader(CommandBehavior behavior)
at Quest.Toad.Db.Connection.Query(CommandBehavior behavior, String sql, Object[] parameter)
at Quest.Toad.Db.Connection.Quest.Toad.Db.IConnection.Query(String sql, Object[] parameter)
at Quest.Toad.DB2.Trl.Table.TableTrl.get_Comment()
at Quest.Toad.DatabaseBrowser.LeftListControl.toolTip_GetActiveObjectInfo(Object sender, ToolTipControllerGetActiveObjectInfoEventArgs e)
at DevExpress.Utils.ToolTipController.OnGetActiveObjectInfo(ToolTipControllerGetActiveObjectInfoEventArgs e)
at DevExpress.Utils.ToolTipController.OnControlMouseMove(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseMove(MouseEventArgs e)
at DevExpress.XtraTreeList.TreeList.OnMouseMove(MouseEventArgs e)

at System.Windows.Forms.Control.WmMouseMove(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
at DevExpress.XtraTreeList.TreeList.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at Quest.Toad.StartupForm.Main(String[] args) InnerException Message: Operation is not valid due to the current state of the object. Check InnerException property for more detail. SQLSTATE=58005


#2

This really looks like an interanal IBM system error.

I noticed the post below. You were having issues connecting. Did you make any changes to get the connection to work? I am wondering if there are any issues with more than one client on your pc.

http://tda.inside.quest.com/thread.jspa?threadID=38000&tstart=15

Can you enable DB2TRC or DB2NMPTRACE from your windows client (where Toad is running), recreate the issue and send in the trace file?

Debbie