Getting System.OutOfMemoryException error when opening Query Builder (.tsm) file
説明
The following error is received when trying to open a Query Builder (.tsm) file.
System.OutOfMemoryException Exception of type 'System.OutOfMemoryException' was thrown. Stack Trace: at System.IO.BinaryReader.ReadBytes(Int32count) at Quest.Toad.Editor.ToadEditorFormat.ReadFile(Sting file) at Quest.Toad.QueryBuilder.QueryBuilder.OpenFile(Sting file) at Quest.Toad.QueryBuilder.timerDelayFileLoad_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventAgrs e) at System.Windows.Forms.Timer.TimerNativeWindow.WindProc(Message & m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
原因
The error is occurring because the SQL was modified in the Query Builder, but was not synced up with the diagram in the Query Builder, and was saved like this.
対策
The .tsm file cannot be fixed and will need to be rebuilt.
WORKAROUND: The file can be opened in Toad Data Point if the .tsm file extension is changed to .sql.
追加情報
The functionality was fixed in v3.5, so this is no longer possible. Starting in v3.5, a .tsm file cannot be saved unless the sql and diagram are synced up.
