How Do I Troubleshoot Errors Without Details

Posted on 2011-10-03
Last Modified: 2012-06-27
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.
Question by:thamilto0410
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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.
    LVL 1

    Author Comment

    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.
    LVL 83

    Accepted Solution

    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?
    LVL 1

    Author Comment

    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?
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    You really need the Oracle error number/message.
    LVL 1

    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example, show how to take different types of Oracle backups using RMAN.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now