Red Gate forums :: View topic - Error while generating the data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Error while generating the data

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nee_609



Joined: 16 Dec 2008
Posts: 2

PostPosted: Tue Dec 16, 2008 3:59 pm    Post subject: Error while generating the data Reply with quote

Hi there,

I am trying to generate the test data for my database in dev environment.
This is relational database and properly normalizaed. Now when i try to generate data using Data Generator i am getting below error for most of tables. Please Advice.

Thanks !

[dbo].[tbltestTable] ExecuteScalar requires an open and available Connection. The connection's current state is closed.
System.InvalidOperationException: ExecuteScalar requires an open and available Connection.
The connection's current state is closed.at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior,
Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior,
Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at
az.a(CancellableController , Int32 , Int32 , ConnectionProperties , GenerateAction , SqlConnection ,
SDGProject , GenerationReport )
System.InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at az.a(CancellableController , Int32 , Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Mon Dec 22, 2008 5:35 pm    Post subject: Reply with quote

Hello,

Sorry this hasn't been answered in such a long time, but we don't have a ready answer to this problem. The connection to the SQL Server is closed when it should be in an open state, and this could mean that the connection was closed by the server for some reason, the network had experienced a problem, or the .NET Framework installation had malfunctioned and freed resources being used by the connection.

There is an implication that the connection was initially successful, otherwise there would have been a connection failure error thrown by the software. Some places that may have useful information are the SQL Server logs, and the application event logs on the client computer.

Sorry I can't be more helpful.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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