1 Topic by crazypit

  • crazypit
  • Member
  • Offline
  • Registered: 2010-04-07
  • Posts: 16

Topic: Unhandled exception in SmartInspectLinqToSqlAdapter.Write method

Hello,

I make heavy use of the LINQ logging feature. From time to time, i get the following exception:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Gurock.SmartInspect.LinqToSql.SmartInspectLinqToSqlAdapter.Write(String value)
   at Devart.Data.Linq.Provider.DataProvider.LogCommand(IDbCommand dbCommand)
   at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
   at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)

Devart is my LINQ to Oracle provider.

The exception is not so frequent. In hundreds of query logs, 1 is faulted. Can you make something out of this?

2 Reply by dgurock

  • dgurock
  • Administrator
  • Offline
  • Registered: 2009-06-23
  • Posts: 639

Re: Unhandled exception in SmartInspectLinqToSqlAdapter.Write method

Hello,

Thanks for the report. We will look into this and I will let you know when we know more (likely on Monday). Thanks!

Regards,
Dennis

Dennis Gurock,
Director & Co-Founder
Gurock Software

3 Reply by tgurock

  • tgurock
  • Administrator
  • Offline
  • Registered: 2009-07-09
  • Posts: 628

Re: Unhandled exception in SmartInspectLinqToSqlAdapter.Write method

Hello,

The exception is not so frequent. In hundreds of query logs, 1 is faulted. Can you make something out of this?

We've looked into this issue and it seems that the only case a NullReferenceException can be thrown is when the given 'value' argument to this function is null. I'm not sure under which circumstances the Devart provider might pass null to the logger but we haven't seen this behavior with the standard .NET LINQ providers. You could add a null-check for the 'value' argument to the Write function, recompile our SmartInspect to LINQ adapter and retry with the modified version. We might also add this check to future versions of the adapter.

Regards,
Tobias