Failed Jobs

Failed jobs do not become expired to allow you to re-queue them without any time pressure. You should re-queue or delete them manually, or apply AutomaticRetry(OnAttemptsExceeded = AttemptsExceededAction.Delete) attribute to delete them automatically.

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 168
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 380
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 165
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatusSoftAlliance(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 370
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.ExecuteSoftAlliance(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 84
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogPendingItems(List`1 items) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 197
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.Execute(Int32 payLogId, String paymentRef) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 35
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Hangfire.SqlServer.SqlServerStorage.CreateAndOpenConnection()
   at Hangfire.SqlServer.SqlServerStorage.UseConnection[T](DbConnection dedicatedConnection, Func`2 func)
   at Hangfire.Server.Worker.PerformJob(BackgroundProcessContext context, IStorageConnection connection, String jobId)

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogPendingItems(List`1 items) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 197
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.Execute(Int32 payLogId, String paymentRef) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 35
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.InvalidOperationException: Could not get a value of the job parameter `CurrentCulture`. See inner exception for details.
 ---> System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=58173; handshake=0; 
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Hangfire.SqlServer.SqlServerStorage.CreateAndOpenConnection()
   at Hangfire.SqlServer.SqlServerStorage.UseConnection[T](DbConnection dedicatedConnection, Func`2 func)
   at Hangfire.Server.PerformContext.GetJobParameter[T](String name)
ClientConnectionId:edf0561d-47c3-4bb7-a25b-e59abd8d9d44
Error Number:-2,State:0,Class:11
   --- End of inner exception stack trace ---
   at Hangfire.Server.PerformContext.GetJobParameter[T](String name)
   at Hangfire.CaptureCultureAttribute.OnPerforming(PerformingContext filterContext)
   at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1 tuple)
   at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstance instance, Func`2 action, String message)
   at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfiler profiler, TInstance instance, Action`1 action, String message)
   at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilter filter, PerformingContext preContext, Func`1 continuation)

System.InvalidOperationException: Could not get a value of the job parameter `CurrentCulture`. See inner exception for details.
 ---> System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 ---> System.ComponentModel.Win32Exception (258): Unknown error 258
   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.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.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Dapper.SqlMapper.ExecuteScalarImpl[T](IDbConnection cnn, CommandDefinition& command)
   at Hangfire.SqlServer.SqlServerConnection.<>c__DisplayClass11_0.<GetJobParameter>b__0(DbConnection connection)
   at Hangfire.SqlServer.SqlServerStorage.UseConnection[T](DbConnection dedicatedConnection, Func`2 func)
   at Hangfire.Server.PerformContext.GetJobParameter[T](String name)
ClientConnectionId:78e55833-56a8-4f6c-892d-f71c0e5100aa
Error Number:-2,State:0,Class:11
   --- End of inner exception stack trace ---
   at Hangfire.Server.PerformContext.GetJobParameter[T](String name)
   at Hangfire.CaptureCultureAttribute.OnPerforming(PerformingContext filterContext)
   at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1 tuple)
   at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstance instance, Func`2 action, String message)
   at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfiler profiler, TInstance instance, Action`1 action, String message)
   at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilter filter, PerformingContext preContext, Func`1 continuation)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 287
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 287
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 287
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 54
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 54
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 54
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 54
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 54
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_insert_softAlliance_payment'.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 654
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 285
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 254
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 55
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_notifications_set_notification_status' expects parameter '@ItemCode', which was not supplied.
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(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 ---
   at Dapper.SqlMapper.ExecuteImplAsync(IDbConnection cnn, CommandDefinition command, Object param) in /_/Dapper/SqlMapper.Async.cs:line 646
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.UpdateNotificationStatus(String paymentRef, String itemCode, NotificationStatus status, NotificationResponseData responseData, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 141
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.updateNotificationStatus(String paymentRef, String itemCode, NibssTQSNotificationResponse response, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 343
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in /app/TqsNibssPDService/BackgroundOperations/Operations/DefaultTaxNotificationProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)