Problem with data reader

[jessicashute]

We occasionally have a problem where our data reader throws a null object expection and sets the process we have running at the time to failed. The error message we are able to capture is:

StackTrace " at System.Data.SqlClient.SqlDataReader.GetSqlInt32(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at Ags.SpinII.ServiceControl.Product.DataProductService.Produce(Request aRequest) in D:\jz3m7m_SPIN2-Dev_Bugfix\SP2-DEV\SP2-SRC\Ags.Spin2\Solutions\MainSolution\Ags.Spin2.ServiceControl\DataProductService.vb:line 414" String

We think the data reader is losing the results of the SP somehow but aren't sure how to go about debugging this problem. Can anyone provide any advice?

Thanks,
Jessica

 

[cjard]

does this exception have an innerException that is populated?

I'd keep a logging table in the db and a log on disk of what youre calling it with. I'd also consider stress testing it but making millions of calls in a loop and waiting for it to fall over, in debug