[7.0.136 beta] Database Load Generator unresponsive

[7.0.136 beta] Database Load Generator unresponsive

When I try to use Database Load Generator with a simple stored proc it remains in a unresponsive state and crashes SSMS just before finshing

Also wuth a simple select from a table with no rows I get

Code:

09.07.2014 12:14:32 Database load started.
09.07.2014 12:14:32 4 Threads started.
09.07.2014 12:14:37 Worker processes results: successful - 26149; failed - 0
09.07.2014 12:14:42 Worker processes results: successful - 49028; failed - 0
09.07.2014 12:14:47 Worker processes results: successful - 75369; failed - 0
09.07.2014 12:14:52 Worker processes results: successful - 101519; failed - 0
09.07.2014 12:14:57 Worker processes results: successful - 127970; failed - 0
09.07.2014 12:15:02 Worker processes results: successful - 149320; failed - 0
09.07.2014 12:15:07 Worker processes results: successful - 171771; failed - 0
09.07.2014 12:15:12 Worker processes results: successful - 198043; failed - 0
09.07.2014 12:15:17 Worker processes results: successful - 223476; failed - 0
09.07.2014 12:15:22 Worker processes results: successful - 249842; failed - 0
09.07.2014 12:15:27 Worker processes results: successful - 273597; failed - 0
09.07.2014 12:15:32 New Worker Process failed. 299188 successful executions. 1 failed execution.
09.07.2014 12:15:32 Average duration: 0,80
09.07.2014 12:15:32 1 fail: Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:15:32 Database load completed.
09.07.2014 12:15:32 Successful worker process executions: 0.
09.07.2014 12:15:32 Failed worker process executions: 1.
09.07.2014 12:15:32 Database load ended.

and with a select from a table with 400000 rows I get

Code:

09.07.2014 12:47:09 Database load started.
09.07.2014 12:47:10 4 Threads started.
09.07.2014 12:47:14 Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:19 Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:24 Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:30 Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:35 Worker processes results: successful - 0; failed - 0
09.07.2014 12:50:40 New Worker Process failed. 4 failed executions.
09.07.2014 12:50:40 Average duration: 210039,43
09.07.2014 12:50:40 2 fails: Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:50:40 2 fails: Object reference not set to an instance of an object. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:50:40 Database load completed.
09.07.2014 12:50:40 Successful worker process executions: 0.
09.07.2014 12:50:40 Failed worker process executions: 1.
09.07.2014 12:50:40 Database load ended.

thank you.

	Quote:
	with a select from a table with 400000 rows I get

I don't see a single query completed. Looks like all queries failed because they took longer to run than what you allowed for a worker process in its properties and so they got eventually aborted. . Could you please verify your SELECT statement and test parameters?

	Code:
	Invalid attempt to call NextResult when reader is closed

I have submitted a bug report for this issue.

As for the stored procedure crashing SSMS, could you please provide more details? Please reproduce this issue and then locate %APPDATA%\SQL Assistant\7.0\SQLAssist.log file and open it in the Notepad. there should be an exception stack trace recorded in that file. Please post the exception data.

Sorry but no errors.
With a new installation of latest version there is not an SQLAssist.log file
The only error appears in event viewer as Application Hang for ssms.exe with no useful details.
Maybe you can reproduce.

I hope the team would be able to reproduce that issue.