16.05.2017 22:43:43: loadFiles general exception: One or more errors occurred. 16.05.2017 22:43:43: System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: The query processor could not start the necessary thread resources for parallel query execution. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at InherentSimplicity.DataAccess.DassStockLocationsSku.GetStockLocationSkusNamesTable(Int32 partitionID, String functionName, SqlConnection conn, SqlTransaction trans) at InherentSimplicity.SymTables.LoacationSkusNames.<>c__DisplayClassa.b__5(IGrouping`2 pflns) at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.b__30() at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask) at System.Threading.Tasks.Task.<>c__DisplayClass11.b__10(Object param0) --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at System.Threading.Tasks.Task.Wait() at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally) at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally) at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body) at InherentSimplicity.SymTables.LoacationSkusNames.Init(SqlConnection conn, SqlTransaction trans) at InherentSimplicity.SymTables.LoacationSkusNames..ctor(SqlConnection conn, SqlTransaction trans, String DBName) at InherentSimplicity.SymTables.LoacationSkusNames.reload(SqlConnection conn, SqlTransaction trans, String DBName) at InherentSimplicity.Module1.InputProcessStockLocationSkusParallel.afterProcessDate(DateTime dateToProcess) at InherentSimplicity.Module1.InputProcessStockLocationSkusParallel.processDate(DateTime dateToProcess) at InherentSimplicity.Module1.InputProcessManager.<>c__DisplayClassd.b__a(InputProcessBase inputProcess) at System.Collections.Generic.List`1.ForEach(Action`1 action) at InherentSimplicity.Module1.InputProcessManager.processNewInput() at InherentSimplicity.Module1.SymphonyInitApplication.loadFiles(String dbName, Nullable`1 ActionSource, Boolean sExportCustomReport, Boolean sEmailCustomReports, Boolean autoloadOn) ---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): The query processor could not start the necessary thread resources for parallel query execution. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at InherentSimplicity.DataAccess.DassStockLocationsSku.GetStockLocationSkusNamesTable(Int32 partitionID, String functionName, SqlConnection conn, SqlTransaction trans) at InherentSimplicity.SymTables.LoacationSkusNames.<>c__DisplayClassa.b__5(IGrouping`2 pflns) at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.b__30() at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask) at System.Threading.Tasks.Task.<>c__DisplayClass11.b__10(Object param0) ClientConnectionId:d9f6f00f-b49d-419e-90bf-f277f737e2d0 Error Number:8642,State:2,Class:17<--- 16.05.2017 22:43:43: ------------------------------------ 16.05.2017 22:46:01: Failed to rollback transactionExecuteNonQuery requires an open and available Connection. The connection's current state is closed.