"Rick" <rfemmer@newsgroups.nospam> wrote in message
news:uxx1NanGIHA.1164@TK2MSFTNGP02.phx.gbl...
> We  have a several vb.net apps, that were recently upgraded from Framework
> 1.1 to Framework 2.0. Randomly these apps have started throwing the error
> below, the line of code is a connection.open, the connection string has a
> timeout of 500, which should be plenty of time. All of the apps use the
> same data layer class (happens on the same line of code). It doesn't
> happen every time, it's just random and it happens on the connect open not
> when executing the command(an insert into a large table).
>
> Anyone have any suggetions?
>
> The Source was: .Net SqlClient Data Provider
>
> With the Message: Timeout expired.  The timeout period elapsed prior to
> completion of the operation or the server is not responding.
>
> Stack Trace:    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.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
>   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
>   at
> System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
>   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>   at PSXSTL.Digecenter.LookupDataReference.insertDB() in
> C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558
>
> Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
>
> Additional Info: Error occurred in
> PSXSTL.Digecenter.LookupDataReference/insertDB
>   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.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
>   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
>   at
> System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
>   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>   at PSXSTL.Digecenter.LookupDataReference.insertDB() in
> C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> Thanks in advance!
> Rick
>
>

"WenYuan Wang [MSFT]" <v-wyw***@online.microsoft.com> wrote in message
news:Z7kZ2QuGIHA.5176@TK2MSFTNGHUB02.phx.gbl...
> Hello Rick,
> Thanks for Norman's suggestion.
>
> I noticed the exception was raised by SqlCommand.ExecuteNonQuery() method.
> Stack Trace:
> ..
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>
> Have you tried increasing the SqlCommand.Timeout property?
> The default value of SqlCommand is 30 (30 seconds).
> It seems this process need much more time to run. Maybe you should
> increase
> the timeout of this command.
>
> Hope this helps.
> Best regards,
>
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

"Cor Ligthert[MVP]" <notmyfirstn***@planet.nl> wrote in message
news:9C481BD7-FD08-4B83-A754-65DDF9028924@microsoft.com...
> Rick,
>
> Are you sure that there is no "Transaction" used in a class, which is not
> committed or not rolled back?
>
> This is in my idea the first point to look for if there are "Transactions"
> used.
>
> Cor

"Rick" <rfemmer@newsgroups.nospam> wrote in message
news:%23Yt2HQxGIHA.6044@TK2MSFTNGP04.phx.gbl...
> The command timeout is set to 120 and the connection timeout is 500, the
> command is executing a stored proc that inserts 1 record. The stored proc
> works as expected, it will return 'SUCCESS' on insert or the error message
> from the stored proc if it failed. As I said, It only happens randomly.
> And it happens on the _cn.open
>
> Private _cn As System.Data.SqlClient.SqlConnection
>
> _cn = New SqlConnection(connectionstring here)
>
> strSQL.Append("EXEC usp_InsertTblLookupDataReference ")
>
> strSQL.Append(PARAMETERS HERE)
>
> If Not _cn.State = ConnectionState.Open Then
>
> _cn.Open()
>
> End If
>
> Dim returnValue As String = ""
>
> countParam = New SqlClient.SqlParameter("@insertSuccess",
> SqlDbType.NVarChar, 4000)
>
> localSQL = New System.Data.SqlClient.SqlCommand(strSQL.ToString, _cn)
>
> localSQL.CommandTimeout = 120
>
> countParam.Direction = ParameterDirection.Output
>
> localSQL.Parameters.Add(countParam)
>
> localSQL.ExecuteNonQuery()
>
> returnValue = localSQL.Parameters("@insertSuccess").Value.ToString
>
> If returnValue.ToUpper <> "SUCCESS" Then
>
> Throw New Exception("Error Inserting TblLookupDataReference record:" &
> returnValue & " - " & strSQL.ToString)
>
> End If
>
> If  _cn.State = ConnectionState.Open Then
>
>    _cn.Close()
>
> End If
>
> "WenYuan Wang [MSFT]" <v-wyw***@online.microsoft.com> wrote in message
> news:Z7kZ2QuGIHA.5176@TK2MSFTNGHUB02.phx.gbl...
>> Hello Rick,
>> Thanks for Norman's suggestion.
>>
>> I noticed the exception was raised by SqlCommand.ExecuteNonQuery()
>> method.
>> Stack Trace:
>> ..
>> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>>
>> Have you tried increasing the SqlCommand.Timeout property?
>> The default value of SqlCommand is 30 (30 seconds).
>> It seems this process need much more time to run. Maybe you should
>> increase
>> the timeout of this command.
>>
>> Hope this helps.
>> Best regards,
>>
>> Wen Yuan
>> Microsoft Online Community Support
>> ==================================================
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>
>