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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.