Getting an Out of Memory error using Freeware version 5.6.0.568

Toad for SQL Server
1

Getting the following error message when using the freeware version (5.6.0.568). Happens randomly when typing in an editor.

System.OutOfMemoryException
Out of memory.
Stack Trace:
at System.Drawing.Image.FromHbitmap(IntPtr hbitmap, IntPtr hpalette)
at System.Drawing.Image.FromHbitmap(IntPtr hbitmap)
at System.Windows.Forms.ImageList.GetBitmap(Int32 index)
at System.Windows.Forms.ImageList.ImageCollection.get_Item(Int32 index)
at DevExpress.Utils.ImageCollection.GetImageListImage(Object images, Int32 index)
at DevExpress.XtraBars.ViewInfo.BarLinkViewInfo.GetLinkImageCore(BarLinkState state)
at DevExpress.XtraBars.ViewInfo.BarLinkViewInfo.GetLinkImage(BarLinkState state)
at DevExpress.XtraBars.ViewInfo.BarLinkViewInfo.GetLinkImageCore(BarLinkState state)
at DevExpress.XtraBars.ViewInfo.BarLinkViewInfo.GetLinkImage(BarLinkState state)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLinkImageCore(BarLinkPaintArgs e, Rectangle r, BarLinkState state, ImageAttributes attr)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLinkDisabledGlyph(BarLinkPaintArgs e)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLinkNormalGlyph(BarLinkPaintArgs e, Boolean lighter)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLinkNormal(BarLinkPaintArgs e)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLinkHorizontal(BarLinkPaintArgs e)
at DevExpress.XtraBars.Painters.BarBaseButtonLinkPainter.DrawLinkHorizontal(BarLinkPaintArgs e)
at DevExpress.XtraBars.Painters.BarLinkPainter.DrawLink(BarLinkPaintArgs e)
at DevExpress.XtraBars.Painters.BarLinkPainter.Draw(GraphicsInfoArgs e, CustomViewInfo info, Object sourceInfo)
at DevExpress.XtraBars.Painters.BarLinkObjectPainter.DrawObject(ObjectInfoArgs e)
at DevExpress.Utils.Drawing.ObjectPainter.DrawObject(GraphicsCache cache, ObjectPainter painter, ObjectInfoArgs e)
at DevExpress.Utils.Drawing.Animation.XtraAnimator.DrawAnimationHelper(GraphicsCache cache, ISupportXtraAnimation obj, Object animationId, ObjectPainter painter, ObjectInfoArgs info, ObjectPainter textPainter, ObjectInfoArgs textInfo)
at DevExpress.Utils.Drawing.Animation.XtraAnimator.DrawAnimationHelper(GraphicsCache cache, ISupportXtraAnimation obj, Object animationId, ObjectPainter painter, ObjectInfoArgs info, DrawTextInvoker drawTextMethod, Object textInfo)
at DevExpress.XtraBars.Painters.BarPainter.DrawLink(GraphicsInfoArgs e, BarControlViewInfo viewInfo, BarLinkViewInfo item)
at DevExpress.XtraBars.Painters.BarPainter.Draw(GraphicsInfoArgs e, CustomViewInfo info, Object sourceInfo)
at DevExpress.XtraBars.Controls.CustomControl.DirectDraw(PaintEventArgs e)
at DevExpress.XtraBars.Controls.CustomControl.OnPaint(PaintEventArgs e)
at DevExpress.XtraBars.Controls.CustomBarControl.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg)
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)

2

Hi,

can you please give me more details:

  • What SQL Server you are connected at the moment you get the exception?
  • How many connections you have at this moment? Are you switching between of them frequently?
  • How large database you have active/selected for editor?
  • How many documents/editors you have opened in toad at this moment? per each connection please
  • Can you please let me know basics steps/operations you perform prior to exception?

Thanks

3

Connecting to a SQL Server 2005 Database
Happens with a single connection
The database is 1.4 G
Happened this morning with 2 editors open on a single connection
Happened when performing a simple one table select statement. Seems to happen when moving the cursor across the editor screen to select text.

4

Thanks for details!

would you please tell me the quantity ob objects in your database?
tables/views/procedures/functions

also how many SQL Servers you have registered in the connection manager?
can you please try to disable “pool service status” in tools>options>database>general
and see you you still get out of memory.

5

I changed the Pool Service Status setting and that stopped the error from occuring. Thanks.