[9.0.151 BETA] Error related to very large resultset

[9.0.151 BETA] Error related to very large resultset

Trying select-copy very large resultset:

Exception: Unhandled exception
operating system : Windows 7 Service Pack 1 build 7601
system language : English
system up time : 5 hours 33 minutes
program up time : 4 hours 52 minutes
processors : 4x Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz
physical memory : 922/3014 MB (free/total)
free disk space : (C:) 4.31 GB
display mode : 1366x768, 32 bit
process id : $644
allocated memory : 354.23 MB
largest free block : 146.87 MB
executable : Ssms.exe
current module : SqlAssistPrefs.dll
module date/time : 2016-09-27 01:55
version : 9.0.151.0
callstack crc : $00000000, $00000000, $42e2346e
exception number : 2
exception message : The application seems to be frozen.

thread $1874:
0a530f78 +3c SqlAssistPrefs.dll SyntaxUnit 1696 +4 TSyntaxThread.Execute

thread $fd0:
0a57d1c3 +1f SqlAssistPrefs.dll ArtIntelPan 811 +1 TBaseSearchThread.Execute

thread $1378:
0a57d1c3 +1f SqlAssistPrefs.dll ArtIntelPan 811 +1 TBaseSearchThread.Execute

Thank you for reporting this. This is a special case in the beta version. We have special kind of self monitoring enabled to catch cases of application freezing.

Would you please describe your environment? System type, database type, database driver used for the connection?
In normal circumstances retrieving large result set should be fully asynchronous unless the driver doesn't support that.

Last edited by SysOp on Tue Sep 27, 2016 6:25 pm; edited 1 time in total

Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.18426
Microsoft .NET Framework 2.0.50727.5485
Operating System Windows 7 Professional

*From SQL simple query window, result to text.

I'm sorry, it's still not clear to me what you are doing when you are getting "application frozen" exception. Are you running a query in the database using SQL Server Management Studio? Or running it from SQL Assistant SQL Editor? Or copying already retrieved results to the clipboard? Something else?

Yes, i'm running a query in the database using SQL Server Management Studio, then attempt to copy part of the resultset (single column) to clippboard.

Thank you. This makes sense. While the result set is being copied and if takes a long time, the SQL Server Management Studio becomes unresponsive and that triggers a special self-monitoring exception in SQL Assistant indicating that the application might be frozen. This is a special exception handler we enabled in the beta version. It will not an issue in the release version. Please treat it as a non-error and ignore it.