PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

// Job ID: #14192496
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
""
CurrentUICulture
""

State

11/22/2025 22:30:22 (+1.327s) 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.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   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 /app/TqsNibssPDService/BackgroundOperations/Repositories/EntPaymentRepository.cs:line 440
   at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in /app/TqsNibssPDService/BackgroundOperations/Operations/PaymentItemsLoggerProcessor.cs:line 44
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

+2.250s Processing

Server:
tqs-ent-service-6459d7b7b9-2vwlx:1
Worker:
dbd07595

+950ms Enqueued

Queue:
default

11/22/2025 22:30:18 Created