Hello,
Currently we are facing very strange issue. Under high load conditions we are getting following exception. Any help is greatly appreciated.
LogName=Application
SourceName=MyWebApiWebSite
EventCode=0
EventType=2
Type=Error
ComputerName=machinename
TaskCategory=None
OpCode=Info
RecordNumber=2305803
Keywords=Classic
Message=Exception Was Caught: System.TimeoutException
---------------------------------------------
11/07/2022 11:46:58
Type: System.TimeoutException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: The OracleDataReader.Read operation has timed-out executing usp_GetMemberData
Source: mylibMSSD.Data.SqlDataAccess.Oracle
HelpLink:
Data : System.Collections.ListDictionaryInternal
TargetSite : Boolean Read(Oracle.DataAccess.Client.OracleDataReader, Int32, System.Action, System.String)
HResult : -2146233083
StackTrace : at mylibMSSD.Data.SqlDataAccess.Oracle.OracleDataReaderExtensions.Read(OracleDataReader reader, Int32 timeout, Action cancellationAction, String ProcedureName)
at mylibMSSD.Data.SqlDataAccess.Oracle.OracleDataAccess.FillDataSet(OracleDataAdapter da, OracleCommand oCommand, DataSet ds, String TableName)
at mylibMSSD.Data.SqlDataAccess.Oracle.OracleDataAccess.ExecuteDataSet(String StoredProcName, CommandType CmdType, DataSet ds, String tableName, OracleParameter[] Params, Int32 retryCnt)
at mylibMSSD.Data.SqlDataAccess.Oracle.OracleDataAccess.ExecuteDataSet(String StoredProcName, CommandType CmdType, OracleParameter[] Params)
at mylibCV.Partner.DAL.EnrollmentData.SelectEnrollment(String clientKey, Int32 Id, String address)
at mylibMyWeb.BLL.Director.GetEnrollment(Customer customer, Boolean insertMemberIfNotFound)
at mylibMyWeb.BLL.MyWebDirector.ProcessGetData(Customer customer, Boolean requiresMasking, EventType& eventType, List`1 additionalInputs)
Additional Information
MachineName : machine name
TimeStamp : 11/7/2022 7:46:58 PM
FullName : mylibMSSD.Diagnostics, Version=4.6.1704.0, Culture=neutral, PublicKeyToken=null
AppDomainName : /LM/W3SVC/2/ROOT-1-133122862210826652
ThreadIdentity :
WindowsIdentity : IIS APPPOOL\apppool