June 9, 2009 at 3:46 pm
Hi Guys!!!!
I have a problem that I do not think the answer anywhere. I have a server and application is on the same machine. During a load of data, which previously took 1 hour, now takes about 3 hours and displays the following error:
DATE/HOUR: 06/09/2009 16:19:11
Message: A transport-level error has occurred when sending the request to the server.
(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Source: .Net SqlClient Data ProviderTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at srAcesso.Conexao.srCommand.ExecuteReader()
at ServicoRecupera.ServicoRecupera.LogarMensagem(stcMensagem objMsg)
Additional Message: Unexpected error message when trying to log to a file.
Task: ConLivre
Somebody already had this kind of problem?
What do I do?
Tank's
Regards!!!!
June 9, 2009 at 3:49 pm
Machine:4 processors
Memory: 8GB ram
Windows Server 2003 SP2
SQL Server 2005 EE (3077)
Regards!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply