Toad World® Forums

Error on complex SQL on Toad Data Point 5.0.4.45

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)

Hi,

I believe that this is related to "Serialization temporary folder" option. In current version of TDP you are able to set this temporary folder in setting. From some reason your temporary folder doesn't exist so we are not able use it for cache your data.
You can check this option in TDP in menu:
Tool -> Options -> Database -> Script Result -> "Serialization temporary folder"

Please check this option and set it to some existing location
(recommended default value)
C:\Users\fcevela\AppData\Local\Temp

Filip

Thanks a lot ! It works better now ! :wink:

Regards,

Franck