How Do I Troubleshoot Errors Without Details

Good Evening,

I have a application with an Oracle database backend.  I am logging for errors and I have gotten the following a couple of times over the last month.

Error in: case_decision.aspx and procedure is sbmtform_onclick  Error Message:   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
   at case.sbmtForm_Onclick(Object Src, EventArgs E)

Now when this has happened I am also tracking the case number and I check the record in the database and it is getting updated.  But still the error.  The few other error logs I have gotten had details like column not large enough etc.  

My question is HOW do I troubleshoot this to determine why it is happening?  Someone please point me in the right direction.  I have check my application log and I have checked the server log for that day as well already.  I don't know where to go next.
Who is Participating?
It looks like the above log is also related to similar problem as the exception is being thrown by Oracle client. Are you also saving the Exception.Message along with stack trace?
slightwv (䄆 Netminder) Commented:
If the full stack trace isn't being captured to show the actual error message and a general area of the code, not sure how to find it.

The 'column to small' should be easy:  find where it is possible where a field is to large for the column.
thamilto0410Author Commented:
slightwv:  stack trace is being captured and the above is still all I get.  As for column to small that was a log from a different day that actually told me what was wrong as I pointed out above I am not getting any details from the couple of logs that look like the above so I don't know where to start.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

thamilto0410Author Commented:
codecruiser:  No.  I am in other procedures but not this one as I thought stack trace would give me all I needed to fix.  I will add the message back in.  Any other suggestions?
slightwv (䄆 Netminder) Commented:
You really need the Oracle error number/message.
thamilto0410Author Commented:
Thank you both.  I now have both stacktrace and message set to log to a log file daily.  Considering the problem only happens about once or twice a month I won't leave this ticket open.  I will wait for the next time to see if the changes made gives more insight.  Have a good day to you both.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.