PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

// Job ID: #12509763
using TqsNibssPDService.BackgroundOperations.Operations;

var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
    FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":300257615,\"PaymentRef\":\"FBN|BRH|EKSG|23-09-2025|743313\",\"PaymentDate\":\"09/24/2025 10:32:35\",\"SettlementDate\":\"09/24/2025 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"4470230925103219\",\"TotalAmount\":590000.0000,\"TotalFee\":8400.0000,\"OagfFee\":225.0000,\"NibssFee\":1575.0000,\"CbnFee\":1650.0000,\"ProductId\":4545,\"ItemCode\":\"0003\"}"));

Parameters

CurrentCulture
""
CurrentUICulture
""

State

09/24/2025 13:35:08 (+2.134s) Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Could not find stored procedure 'sp_insert_softAlliance_payment'.

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)

+1.020s Processing

Server:
tqs-ent-service-565474dbf9-67pfx:1
Worker:
a78f6c7f

+563ms Enqueued

Queue:
default

09/24/2025 13:35:05 Created