PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

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

var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
    FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":300257712,\"PaymentRef\":\"FBN|BRH|EKSG|24-09-2025|743353\",\"PaymentDate\":\"09/24/2025 13:49:20\",\"SettlementDate\":\"09/25/2025 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"2823240925134907\",\"TotalAmount\":300000.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:48:18 (+2.090s) 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.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)

+2.420s Processing

Server:
tqs-ent-service-5b4c4cfcd7-n6p6q:1
Worker:
aa6296f8

+110ms Enqueued

Queue:
default

09/24/2025 13:48:14 Created