asked on

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.

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.

thamilto0410

ASKER

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.

ASKER CERTIFIED SOLUTION

Nasir Razzaq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thamilto0410

ASKER

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?

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thamilto0410

ASKER

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.