locked
TdsParse Exception RRS feed

  • Question

  • Hello there,

    I am having a very strange issue using SQLClient library. We use dapper in our repository library to perform CRUD operations.

    Every now and then the insert command fails which the famous 'Object Reference not set to an instance of a type' 

    But the problem is the call stack does not have any of our internal code. We have stepped into Dapper where the actual call is made to insert and it fails the odd time. It is not consistent and call the same step works again without any issue. We have spent hours trying to track the issue but with no luck. We also turned on ETW for ado.net to see if there is anything useful or meaningful message to point to the actual issue but no luck. Would appreciate if anyone could give us some guidance on this

    Call stack on the exception

       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(SqlCommand cmd, _SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       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.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)
       at Dapper.SqlMapper.<QueryImpl>d__125`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)
       at Emydex.iWAMS.FW.Persistence.DapperImp.DapperWrapper`1.<>c__DisplayClass5_1.<ExecuteInsert>b__0() in C:\DATA\Emydex-Dev\Repo\iWAMS\Main\FW\iWAMS.FW.Persistence\DapperImp\DapperWrapper.cs:line 104

    Thanks 

    Sharad

    Tuesday, June 12, 2018 4:05 PM

Answers

  •  at Dapper.SqlMapper.Query[T]( 

    Hello Sharad,

    the base error is raised by Dapper, not by SQL Server nor by it's client; so contact Dapper support for the issue.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, June 12, 2018 4:20 PM