Toad World® Forums

Out of memory in schema compare


#1

Howdy,

In beta .250, I’m doing a schema compare. After the comparison, I click on
the first table with differences and get:

System.OutOfMemoryE xception
Exception of type ‘System.OutOfMemory Exception’ was thrown.
Stack Trace:
at Quest.Shared. UI.CodeComparer. StrCompareByWagn er.Compare( Byte[]&
abyteFirst, Byte[]& abyteSecond, Int32 nItemSize, Int32[]& anLCSFirst,
Int32[]& anLCSSecond)
at Quest.Shared. UI.CodeComparer. TextsComparerByI tems.Compare( Int32[]&
anLCSFirst, Int32[]& anLCSSecond)
at Quest.Shared. UI.CodeComparer. TextsComparerByT okens.Compare( TokenStream
tokenstream1, TokenStream tokenstream2, Boolean bRefreshDictionary,
Int32[]& anLCSFirst, Int32[]& anLCSSecond)
at
Quest.Schema. MSSQL.UI. TextViewer. CodeComparer. CodeCompareContr ol.Compare( )

at
Quest.Schema. MSSQL.UI. ModelViewers. MSPairModelViewe r.showDetails(
SelectedNodeEven tArgs
e)
at
Quest.Schema. MSSQL.UI. ModelViewers. MSPairModelViewe r.viewer_ SelectedNode(
Object
sender, SelectedNodeEventAr gs e)
at
Quest.Schema. MSSQL.UI. ModelViewers. MSPairModelPlain Viewer.OnSelecte
dNode(SelectedNo deEventArgs
e)
at Quest.Schema. MSSQL.UI. ModelViewers. MSPairModelPlain Viewer.OnChanged ()
at
Quest.Schema. MSSQL.UI. ModelViewers. MSPairModelPlain Viewer.gridView_
FocusedRowChange d(Object
sender, FocusedRowChangedEv entArgs e)
at DevExpress.XtraGrid .Views.Base. ColumnView. RaiseFocusedRowC hanged(Int32
prevFocused, Int32 focusedRowHandle)
at
DevExpress.XtraGrid .Views.Base. ColumnView. DoChangeFocusedR owInternal( Int32
newRowHandle, Boolean updateCurrentRow)
at DevExpress.XtraGrid .Views.Base. ColumnView. set_FocusedRowHa ndle(Int32
value)
at
DevExpress.XtraGrid .Views.Grid. Handler.GridRegu larRowNavigator. OnMouseDown(
GridHitInfo
hitInfo, DXMouseEventArgs e)
at
DevExpress.XtraGrid .Views.Grid. Handler.GridHand ler.OnMouseDown(
MouseEventArgs
ev)
at DevExpress.Utils. Controls. BaseHandler. ProcessEvent( EventType etype,
Object args)
at
DevExpress.XtraGrid .Views.Base. Handler.BaseView Handler.ProcessE
vent(EventType
etype, Object args)
at DevExpress.XtraGrid .GridControl. OnMouseDown( MouseEventArgs ev)
at System.Windows. Forms.Control. WmMouseDown( Message& m, MouseButtons
button, Int32 clicks)
at System.Windows. Forms.Control. WndProc(Message& m)
at DevExpress.XtraEdit ors.Container. EditorContainer. WndProc(Message& m)
at DevExpress.XtraGrid .GridControl. WndProc(Message& m)
at System.Windows. Forms.Control. ControlNativeWin dow.OnMessage( Message& m)
at System.Windows. Forms.Control. ControlNativeWin dow.WndProc( Message& m)
at System.Windows. Forms.NativeWind ow.Callback( IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

I’m pretty sure this isn’t the case, as Process Explorer tells me there is
2.2GB free out of the 3.5GB max on my WinXP laptop with a 3.5GB page file.

Clicking on the same table in the schema compare on ToadSS 4.5.0.854 gives a
“Script is too large to display” popup error.

Thanks!
Rich