Failed jobs do not become expired to allow you to re-queue them without any
time pressure. You should re-queue or delete them manually, or apply AutomaticRetry(OnAttemptsExceeded = AttemptsExceededAction.Delete)
attribute to delete them automatically.
System.Net.Http.HttpRequestException: Request error: InternalServerError. Response: {"success":false,"errorCode":"S13","errorMsg":"关键字 'WITH' 附近有语法错误。\r\n关键字 'with' 附近有语法错误。如果此语句是公用表表达式、xmlnamespaces 子句或者更改跟踪上下文子句,那么前一个语句必须以分号结尾。","data":null}
at GxHub.Wms.Core.Comm.HttpClientHelper.<SendHttpClient>d__0`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
at GxHub.Wms.Core.Tasks.SyncEndParcelLatAndLngTask.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()
Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Loda.Cainiao.Api, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyNamefileName, StringcodeBase, EvidenceassemblySecurity, RuntimeAssemblylocationHint, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyNameassemblyRef, EvidenceassemblySecurity, RuntimeAssemblyreqAssembly, StackCrawlMark&stackMark, IntPtrpPrivHostBinder, BooleanthrowOnFileNotFound, BooleanforIntrospection, BooleansuppressSecurityChecks)
at System.Reflection.Assembly.Load(AssemblyNameassemblyRef)
at Hangfire.Common.TypeHelper.AssemblyResolver(StringassemblyString)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at System.TypeNameParser.ResolveAssembly(StringasmName, Func`2assemblyResolver, BooleanthrowOnError, StackCrawlMark&stackMark)
at System.TypeNameParser.ConstructType(Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.TypeNameParser.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError, BooleanignoreCase, StackCrawlMark&stackMark)
at System.Type.GetType(StringtypeName, Func`2assemblyResolver, Func`4typeResolver, BooleanthrowOnError)
at Hangfire.Common.TypeHelper.<>c.<DefaultTypeResolver>b__20_0(Stringname)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKeykey)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKeykey, Func`2valueFactory)
at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2typeResolver, StringtypeName, StringmethodName, StringparameterTypes, Type&type, MethodInfo&methodInfo)
at Hangfire.Storage.InvocationData.DeserializeJob()