SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[9.0.151 BETA] Error related to very large resultset

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[9.0.151 BETA] Error related to very large resultset
Author Message
jp.alaniz



Joined: 01 Aug 2014
Posts: 18
Country: Mexico

Post [9.0.151 BETA] Error related to very large resultset Reply with quote
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
Tue Sep 27, 2016 4:53 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
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
Tue Sep 27, 2016 5:30 pm View user's profile Send private message
jp.alaniz



Joined: 01 Aug 2014
Posts: 18
Country: Mexico

Post Reply with quote
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.
Tue Sep 27, 2016 6:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
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?
Tue Sep 27, 2016 6:30 pm View user's profile Send private message
jp.alaniz



Joined: 01 Aug 2014
Posts: 18
Country: Mexico

Post Reply with quote
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.
Wed Sep 28, 2016 9:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
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.
Wed Sep 28, 2016 9:33 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.