[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

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.
0
thamilto0410
Asked:
thamilto0410
  • 3
  • 2
2 Solutions
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now