// Job ID: #12450978
using TqsNibssPDService.BackgroundOperations.Operations;
var paymentItemsLoggerProcessor = Activate<PaymentItemsLoggerProcessor>();
await paymentItemsLoggerProcessor.ExecuteForSoftAlliance(
FromJson<EntPaymentSoftAlliance>("{\"paymentLogId\":300257567,\"PaymentRef\":\"FBN|BRH|EKSG|19-09-2025|743290\",\"PaymentDate\":\"09/22/2025 11:11:58\",\"SettlementDate\":\"09/22/2025 00:00:01\",\"IsOwnBankCheque\":true,\"CustomerNumber\":\"5571190925161704\",\"TotalAmount\":300000.0000,\"TotalFee\":8400.0000,\"OagfFee\":225.0000,\"NibssFee\":1575.0000,\"CbnFee\":1650.0000,\"ProductId\":4545,\"ItemCode\":\"0003\"}"));
| CurrentCulture | |
| CurrentUICulture | |
An exception occurred during performance of the job.
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.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 646 at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.InsertSoftAlliancePaymentAsync(EntPaymentSoftAlliance payment, String status) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 266 at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.LogSoftAlliancePendingItems(List`1 items, EntPaymentSoftAlliance payment) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 235 at TqsNibssPDService.BackgroundOperations.Operations.PaymentItemsLoggerProcessor.ExecuteForSoftAlliance(EntPaymentSoftAlliance payment) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\PaymentItemsLoggerProcessor.cs:line 54 at System.Runtime.CompilerServices.TaskAwaiter.GetResult()