Toad World® Forums

Error on complex SQL on Toad Data Point 5.0.4.45

#1

Hi all.

I frequently use "subquery factoring" in sql scripts,
I got this message with version 5.0.4.45 when i fetch ALL rows.

The same SQL query works perfectly on version 4.3 and 5.0.3.32.

System.IO.DirectoryNotFoundException
Could not find a part of the path 'C:\Users\fr105676\AppData\Local\Temp\11\161dc99b-14eb-4578-88ce-b21c5e3d43ea.tmp'.
Stack Trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
at Quest.FastData.FastTable.GetTempFileName()
at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object data, FastSerialize serializers)
at Quest.FastData.FastTable.RowCollection.<>c__DisplayClass43_0.b__0(Object state)