PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

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

var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
    FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":305786537,\"PaymentRef\":\"FBN|BRH|EKSG|4-06-2026|744810\",\"PaymentDate\":\"06/04/2026 12:20:09\",\"SettlementDate\":\"06/05/2026 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"8619080426150102\",\"TotalAmount\":3100143.0000,\"TotalFee\":15000.0000,\"OagfFee\":225.0000,\"NibssFee\":1575.0000,\"CbnFee\":1650.0000,\"ProductId\":4545,\"ItemCode\":\"0003\"}"));

Parameters

CurrentCulture
"en-NG"
CurrentUICulture
"en-US"

State

06/11/2026 10:44:24 (+16.233s) Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Procedure or function fetch_softAlliance_paymentItems has too many arguments specified.

System.Data.SqlClient.SqlException (0x80131904): Procedure or function fetch_softAlliance_paymentItems has too many arguments specified.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__122_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 418
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.GetSoftAlliancePaymentItems(String billReference, Int32 productId) in C:\isw_projects\tqs_ent_service\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 694
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in C:\isw_projects\tqs_ent_service\TqsNibssPDService\BackgroundOperations\Operations\PaymentItemsLoggerProcessor.cs:line 50
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

+1.190s Processing

Server:
isw-260407-1aso:5432
Worker:
63d959cd

+104ms Enqueued

Queue:
default

06/11/2026 10:44:07 Created