PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

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

var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
    FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":305766030,\"PaymentRef\":\"FBN|BRH|EKSG|22-11-2025|743663\",\"PaymentDate\":\"11/22/2025 21:47:21\",\"SettlementDate\":\"11/24/2025 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"4458061125194615\",\"TotalAmount\":20000.0000,\"TotalFee\":15000.0000,\"OagfFee\":225.0000,\"NibssFee\":1575.0000,\"CbnFee\":1650.0000,\"ProductId\":4545,\"ItemCode\":\"0003\"}"));

Parameters

CurrentCulture
"en-GB"
CurrentUICulture
"en-US"

State

11/23/2025 14:09:26 (+56.033s) Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Invalid object name 'paydirect_middlewares.dbo.PaymentItemDetails'.

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'paydirect_middlewares.dbo.PaymentItemDetails'.
   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:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 440
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\PaymentItemsLoggerProcessor.cs:line 42
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

+4.570s Processing

Server:
isw-220521-655:2928
Worker:
8f29229a

+597ms Enqueued

Queue:
default

11/23/2025 14:08:24 Created