// Job ID: #3645957
using OOP.BackgroundJobsManager.Jobs;
var postSapJobs = Activate<PostSapJobs>();
postSapJobs.PostOrderToSap(1862273, 1889281, 1930649);
| CurrentCulture | |
| CurrentUICulture | |
| RetryCount | |
An exception occurred during performance of the job.
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) at System.Collections.Generic.List`1.ForEach(Action`1 action) at OOP.BackgroundTask.Orders.PostOrderToSap.PostOrderToSapDivisionWise(Int32 OrderId, Int32 DivisionOrderID, Int32 OrderAmendmentID) 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
Retry attempt 2 of 2: The 'Areacode' property on 'SP_GetPostOrder_head_…
An exception occurred during performance of the job.
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.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
Retry attempt 1 of 2: The 'Areacode' property on 'SP_GetPostOrder_head_…
An exception occurred during performance of the job.
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