Job

System.Data.SqlClient.SqlException

Procedure or function 'ent_tqs_fetch_payment_details_softAlliance' expects parameter '@BillReference', which was not supplied.

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ent_tqs_fetch_payment_details_softAlliance' expects parameter '@BillReference', which was not supplied.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1055
   at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in /_/Dapper/SqlMapper.cs:line 1083
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 725
   at TqsNibssPDService.BackgroundOperations.Repositories.EntPaymentRepository.GetEntPaymentDetailsSoftAlliance(String paymentRef, String billReference, String itemCode) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Repositories\EntPaymentRepository.cs:line 69
   at TqsNibssPDService.BackgroundOperations.Operations.DefaultTaxNotificationProcessor.Execute(String paymentRef, String itemCode, String customerNumber) in C:\Users\sunday.omoyele\Desktop\isw_projects\tqs_Enterprise\TqsNibssPDService\BackgroundOperations\Operations\DefaultTaxNotificationProcessor.cs:line 34
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()

Server:

isw-220521-655:25620

Worker:

a8b67fdd

Queue:

default