PaymentItemsLoggerProcessor.ExecuteForSoftAlliance

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

var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
    FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":305765965,\"PaymentRef\":\"FBN|BRH|EKSG|12-11-2025|743637\",\"PaymentDate\":\"11/12/2025 08:09:15\",\"SettlementDate\":\"11/13/2025 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"1571121125070849\",\"TotalAmount\":100000.0000,\"TotalFee\":8400.0000,\"OagfFee\":225.0000,\"NibssFee\":1575.0000,\"CbnFee\":1650.0000,\"ProductId\":4545,\"ItemCode\":\"0003\"}"));

Parameters

CurrentCulture
""
CurrentUICulture
""

State

11/12/2025 20:45:17 (+1.623s) 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 421
   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.107s Processing

Server:
tqs-ent-service-79c478c89c-7mzfv:1
Worker:
7a631bbd

+640ms Enqueued

Queue:
default

11/12/2025 20:45:14 Created