How Do I Troubleshoot Errors Without Details

Good Evening,

I have a vb.net 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.
LVL 1
thamilto0410Asked:
Who is Participating?
 
CodeCruiserCommented:
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?
0
 
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.
0
 
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.
0
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?
0
 
slightwv (䄆 Netminder) Commented:
You really need the Oracle error number/message.
0
 
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.
0
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.