Thread Abort Exception : Thread was being aborted with Oracle DataAccess

Whiskey

New Member
I am getting Data from a web service and inserting in to a temporary table, from there after performing validation am moving all the data to master table .Data is nearly 1 lakhs.All the data is inserting into the temp table, but not inserting into the master table.(For this transaction, it is taking nearly 20 min. Nearly i tested 7 times, every time am getting the error after 20min).When i check the log, TharedAbortException is there.The above process is happening for 10000 records (taking nearly 6-7 minutes)Following is the error log.\[quote\] Type : System.Threading.ThreadAbortException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Thread was being aborted. Source : Oracle.DataAccess Help link : ExceptionState : System.Web.HttpApplication+CancelModuleException Data : System.Collections.ListDictionaryInternal TargetSite : Int32 ExecuteNonQuery(IntPtr, IntPtr ByRef, IntPtr ByRef, IntPtr ByRef, IntPtr, Int32 ByRef, Int32, Int32, Int64 ByRef, Oracle.DataAccess.Client.OpoSqlValCtx* ByRef, System.String, IntPtr ByRef, IntPtr[], System.String[], Oracle.DataAccess.Client.OpoMetValCtx* ByRef, Int32, Int32) Stack Trace : at Oracle.DataAccess.Client.OpsSql.ExecuteNonQuery(IntPtr opsConCtx, IntPtr& opsErrCtx, IntPtr& opsSqlCtx, IntPtr& opsDacCtx, IntPtr opsSubscrCtx, Int32& isSubscrRegistered, Int32 bchgNTFNExcludeRowidInfo, Int32 bQueryBasedNTFNRegistration, Int64& query_id, OpoSqlValCtx*& pOpoSqlValCtx, String pCommandText, IntPtr& pUTF8CommandText, IntPtr[] pOpoPrmValCtx, String[] ppOpoPrmRefCtx, OpoMetValCtx*& pOpoMetValCtx, Int32 prmCnt, Int32 bFromPool) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at PCS.Integration.PRMV.DAL.SpreadDAL.InsertResourceAssignSpreadToStaging(ProcessLogBO processLogBO, ReadResourceAssignmentSpreadResponseResourceAssignmentSpread[] ResourceSpreadArray)\[/quote\]
 
Top