Hangfire Dashboard

PostSapJobs.PostOrderToSap

// Job ID: #3646215
using OOP.BackgroundJobsManager.Jobs;

var postSapJobs = Activate<PostSapJobs>();
postSapJobs.PostOrderToSap(1862280, 1889289, 1930657);

Properties

CurrentCulture 
"en-IN"
CurrentUICulture 
"en-US"
RetryCount 
2

State

8/20/2025 7:14:23 AM (+94ms) Failed

An exception occurred during performance of the job.

System.InvalidOperationException

The 'Areacode' property on 'SP_GetPostOrder_head_Result' could not be set to a 'System.Int32' value. You must set this property to a non-null value of type 'System.String'. 

System.InvalidOperationException: The 'Areacode' property on 'SP_GetPostOrder_head_Result' could not be set to a 'System.Int32' value. You must set this property to a non-null value of type 'System.String'. 
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
   at lambda_method(Closure , Shaper )
   at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at OOP.BackgroundTask.Orders.PostOrderToSap.<>c__DisplayClass34_0.<PostOrderToSapDivisionWise>b__1(PostOrderToSapDto post) in D:\Source\GitHub\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 131
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at OOP.BackgroundTask.Orders.PostOrderToSap.PostOrderToSapDivisionWise(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\Source\GitHub\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 110
   at OOP.BackgroundJobsManager.Jobs.PostSapJobs.PostOrderToSap(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\Source\GitHub\OOP\OOP.BackgroundJobsManager\Jobs\PostSapJobs.cs:line 22

+90ms Processing

Server:
ooptest:21432
Worker:
0c71b93d

+5m 12.400s Enqueued

Triggered by DelayedJobScheduler

Queue:
queue-a_orderpostingtosap

+3ms Scheduled

Retry attempt 2 of 2: Could not find stored procedure 'SP_GetPostOrderf…

Enqueue at:
8/20/2025 7:14:10 AM

+2.497s Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Could not find stored procedure 'SP_GetPostOrderf_head'.

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'SP_GetPostOrderf_head'.
   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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass69`1.<ExecuteStoreQueryReliably>b__68()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass69`1.<ExecuteStoreQueryReliably>b__67()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryReliably[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at OOP.BackgroundTask.Orders.PostOrderToSap.<>c__DisplayClass34_0.<PostOrderToSapDivisionWise>b__1(PostOrderToSapDto post) in D:\30.10.2024\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 131
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at OOP.BackgroundTask.Orders.PostOrderToSap.PostOrderToSapDivisionWise(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\30.10.2024\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 110
   at OOP.BackgroundJobsManager.Jobs.PostSapJobs.PostOrderToSap(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\30.10.2024\OOP\OOP.BackgroundJobsManager\Jobs\PostSapJobs.cs:line 22

+56ms Processing

Server:
nsho00swlap7:41896
Worker:
f53969ab

+3m 9.880s Enqueued

Triggered by DelayedJobScheduler

Queue:
queue-a_orderpostingtosap

+ <1ms Scheduled

Retry attempt 1 of 2: Could not find stored procedure 'SP_GetPostOrderf…

Enqueue at:
8/20/2025 7:08:58 AM

+1.750s Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Could not find stored procedure 'SP_GetPostOrderf_head'.

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'SP_GetPostOrderf_head'.
   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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass69`1.<ExecuteStoreQueryReliably>b__68()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass69`1.<ExecuteStoreQueryReliably>b__67()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryReliably[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, ExecutionOptions executionOptions, Object[] parameters)
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at OOP.BackgroundTask.Orders.PostOrderToSap.<>c__DisplayClass34_0.<PostOrderToSapDivisionWise>b__1(PostOrderToSapDto post) in D:\30.10.2024\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 131
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at OOP.BackgroundTask.Orders.PostOrderToSap.PostOrderToSapDivisionWise(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\30.10.2024\OOP\OOP.BackgroundTask\Orders\PostOrderToSap.cs:line 110
   at OOP.BackgroundJobsManager.Jobs.PostSapJobs.PostOrderToSap(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) in D:\30.10.2024\OOP\OOP.BackgroundJobsManager\Jobs\PostSapJobs.cs:line 22

+104ms Processing

Server:
nsho00swlap7:41896
Worker:
74368a33

+20ms Enqueued

Queue:
queue-a_orderpostingtosap

8/20/2025 7:05:56 AM Created