title: Core .Net SqlClient Data Provider raises error of "The request failed to run because the batch is aborted" randomly?
body: <p>I've .Net core C# application which calls a stored procedure with different parameters in parallel. From time to time I got the following exception.</p>
  
  <blockquote>
    <p>The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy.</p>
  </blockquote>
  
  <pre>
  System.AggregateException: One or more errors occurred. (The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy.) ---> System.Data.SqlClient.SqlException: The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy.
     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
     at System.Data.SqlClient.SqlInternalConnection.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.TryConsumeMetaData()
     at System.Data.SqlClient.SqlDataReader.get_MetaData()
     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
     at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
     at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod)
     at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
     at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
     at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
  --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
     at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
  </pre>
  
  <p>What caused the exception? </p>
  
  <pre><code>var options = new ParallelOptions { MaxDegreeOfParallelism = 4 };
  Parallel.ForEach(items, options, t =&gt;
  {
      try
      {
          var result = DoWork(t.A, t.Range).Result;
      }
      catch (Exception ex)
      {
          _logger.LogError(ex, $"{ex.ToString()}");
      }
  });
  
  public async Task&lt;string&gt; DoWork(A table, SqlXml range)
  {
      _context.Database.SetCommandTimeout(150000);
      using (var cmd = Conn.CreateCommand())
      {
          cmd.CommandTimeout = 1200;
          cmd.CommandText = "storedProc";
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.SmallInt) { Value = table.Id });
          cmd.Parameters.Add(new SqlParameter("@Range", SqlDbType.Xml) { Value = range });
          var result = await cmd.ExecuteScalarAsync();
          return result as string;
      }
  }
  </code></pre>