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