2025-11-11 09:31:06,655 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-11-11 09:31:13,592 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-11-11 09:31:16,013 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-11-11 09:31:16,440 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-11-11 09:31:16,549 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 3 条已确认(acked)消息. 2025-11-11 09:31:16,551 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,553 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,556 [33] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,558 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,559 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,561 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:16,563 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 09:31:18,080 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 44028 条已确认(acked)消息. 2025-11-11 09:35:54,662 [48] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-11-11 09:48:38,941 [107] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023894375373(XD251028000637)”... 2025-11-11 09:48:40,110 [107] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 09:48:40,819 [107] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 10:12:53,363 [117] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023996613194(202511050918258859)”... 2025-11-11 10:12:53,453 [117] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 10:19:34,294 [81] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023957032549(XD251109001238)”... 2025-11-11 10:19:35,294 [81] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 10:19:35,401 [81] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 10:42:39,153 [71] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023852950384(XD251031000706)”... 2025-11-11 10:42:39,990 [71] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 10:42:40,096 [71] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 11:07:07,406 [82] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023852386664(202510311737277047)”... 2025-11-11 11:07:07,527 [82] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 11:56:31,595 [190] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:16:23' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-11-11 11:56:31,599 [190] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 11:56:31,600 [190] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 11:56:31,600 [190] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 11:56:31,609 [190] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509261516233655;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:16:23' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:16:23' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_14f474d5c12142c69544df9bd284d017.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1713(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 11:57:31,587 [20] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128309,"UserId":472} 2025-11-11 14:28:16,466 [227] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:26:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-11-11 14:28:16,468 [227] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:28:16,468 [227] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:28:16,468 [227] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:28:16,469 [227] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202511111426019532;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:26:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:26:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_14f474d5c12142c69544df9bd284d017.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1713(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 14:30:41,903 [191] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128340,"UserId":268} 2025-11-11 14:34:11,136 [98] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:33:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-11-11 14:34:11,138 [98] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:34:11,138 [98] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:34:11,138 [98] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-11-11 14:34:11,139 [98] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202511111433361202;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:33:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-11-11 14:33:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_14f474d5c12142c69544df9bd284d017.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1713(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 14:35:27,432 [239] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128340,"UserId":268} 2025-11-11 16:33:59,073 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-11-11 16:34:06,014 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-11-11 16:34:08,468 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-11-11 16:34:08,949 [21] WARN DotNetCore.CAP.Internal.ConsumerServiceSelector - We detected that you have duplicate subscribers (MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder) in same group (cap.queue.mcms.saleorder.v1), this will cause diversity behavior. 2025-11-11 16:34:09,017 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-11-11 16:34:09,088 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-11-11 16:34:09,090 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:34:09,121 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 16 条已确认(acked)消息. 2025-11-11 16:34:09,125 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 3 条已确认(acked)消息. 2025-11-11 16:34:09,128 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 16:34:09,130 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:34:09,134 [33] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 16:34:09,138 [33] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 16:34:09,142 [33] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 8 条已确认(acked)消息. 2025-11-11 16:36:17,016 [22] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-11-11 16:36:39,087 [36] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderReturn/Approval;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:Object reference not set to an instance of an object. at MCMS.SaleOrder.Service.Impl.OrderReturnService.Approval(String returnNumber, Int32 opUserId, String opUser, Boolean pass, String note, Decimal refundTotal, Decimal fee, Int32 receiveWarehouseId, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderReturnService.cs:line 436 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderReturnService.Approval(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_82561f10779845b4913305319393a5a6.Approval(String returnNumber, Int32 opUserId, String opUser, Boolean pass, String note, Decimal refundTotal, Decimal fee, Int32 receiveWarehouseId, String& msg) at MCMS.SaleOrder.Controllers.OrderReturnController.Approval(OrderReturnApprovalPostDto pars) at lambda_method310(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 16:36:53,234 [36] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderReturn/Approval;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:Object reference not set to an instance of an object. at MCMS.SaleOrder.Service.Impl.OrderReturnService.Approval(String returnNumber, Int32 opUserId, String opUser, Boolean pass, String note, Decimal refundTotal, Decimal fee, Int32 receiveWarehouseId, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderReturnService.cs:line 436 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderReturnService.Approval(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_82561f10779845b4913305319393a5a6.Approval(String returnNumber, Int32 opUserId, String opUser, Boolean pass, String note, Decimal refundTotal, Decimal fee, Int32 receiveWarehouseId, String& msg) at MCMS.SaleOrder.Controllers.OrderReturnController.Approval(OrderReturnApprovalPostDto pars) at lambda_method310(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 16:50:38,662 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-11-11 16:50:45,545 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-11-11 16:50:47,799 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-11-11 16:50:48,250 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-11-11 16:50:48,266 [17] WARN DotNetCore.CAP.Internal.ConsumerServiceSelector - We detected that you have duplicate subscribers (MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder) in same group (cap.queue.mcms.saleorder.v1), this will cause diversity behavior. 2025-11-11 16:50:48,317 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,320 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,322 [29] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,324 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,326 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,328 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,331 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,333 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 16:50:48,334 [29] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 0 条已确认(acked)消息. 2025-11-11 16:53:03,444 [39] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-11-11 17:00:36,362 [61] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderReturn/Ship;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:关联订单Id/编号不能为空 at MCMS.SaleOrder.Service.Impl.OrderReturnService.Ship(String returnNumber, Int32 opUserId, String opUser, String note, IDictionary`2 productDetailList, Int32 warehouseId, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderReturnService.cs:line 720 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderReturnService.Ship(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_fab489cc593e4efaafe39db30ce3c164.Ship(String returnNumber, Int32 opUserId, String opUser, String note, IDictionary`2 productDetailList, Int32 warehouseId, String& msg) at MCMS.SaleOrder.Controllers.OrderReturnController.Ship(OrderReturnShipPostDto pars) at lambda_method381(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 17:02:16,600 [73] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderReturn/Ship;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:关联订单Id/编号不能为空 at MCMS.SaleOrder.Service.Impl.OrderReturnService.Ship(String returnNumber, Int32 opUserId, String opUser, String note, IDictionary`2 productDetailList, Int32 warehouseId, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderReturnService.cs:line 720 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderReturnService.Ship(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_fab489cc593e4efaafe39db30ce3c164.Ship(String returnNumber, Int32 opUserId, String opUser, String note, IDictionary`2 productDetailList, Int32 warehouseId, String& msg) at MCMS.SaleOrder.Controllers.OrderReturnController.Ship(OrderReturnShipPostDto pars) at lambda_method381(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-11-11 17:11:31,783 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-11-11 17:11:37,979 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-11-11 17:11:40,515 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-11-11 17:11:40,991 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-11-11 17:11:40,997 [17] WARN DotNetCore.CAP.Internal.ConsumerServiceSelector - We detected that you have duplicate subscribers (MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder) in same group (cap.queue.mcms.saleorder.v1), this will cause diversity behavior. 2025-11-11 17:11:41,054 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,057 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,059 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,061 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,063 [19] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,065 [29] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,067 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,069 [32] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:41,071 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 0 条已确认(acked)消息. 2025-11-11 17:11:51,254 [23] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-11-11 17:15:30,423 [43] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023852951464(XD251031000872)”... 2025-11-11 17:15:32,152 [43] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 17:15:32,550 [43] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 17:34:45,697 [126] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128340,"UserId":268} 2025-11-11 17:40:43,528 [161] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023959998801(XD251110000719)”... 2025-11-11 17:40:44,335 [161] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 17:40:46,795 [161] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 17:44:06,144 [189] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000024017697358(202511091425497968)”... 2025-11-11 17:44:06,243 [189] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 17:45:17,737 [182] DEBUG CapSubscribeService - SubscribeJdCloudOrderIncSyncToSysOrder接收到订阅:{"JdDeptNo":null,"JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":null,"IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null} 2025-11-11 17:45:17,750 [182] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder, Id:4694692386687254551, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: 参数错误. ---> System.Exception: 参数错误. at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-11-11 17:45:17,754 [182] WARN DotNetCore.CAP.Internal.SubscribeExecutor - The 1th retrying consume a message failed. message id: 4694692386687254551 2025-11-11 17:45:17,788 [192] DEBUG CapSubscribeService - SubscribeJdCloudOrderIncSyncToSysOrder接收到订阅:{"JdDeptNo":null,"JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":null,"IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null} 2025-11-11 17:45:17,793 [192] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder, Id:4694692386687254551, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: 参数错误. ---> System.Exception: 参数错误. at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-11-11 17:45:17,793 [192] WARN DotNetCore.CAP.Internal.SubscribeExecutor - The 2th retrying consume a message failed. message id: 4694692386687254551 2025-11-11 17:45:17,820 [192] DEBUG CapSubscribeService - SubscribeJdCloudOrderIncSyncToSysOrder接收到订阅:{"JdDeptNo":null,"JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":null,"IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null} 2025-11-11 17:45:17,824 [192] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder, Id:4694692386687254551, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: 参数错误. ---> System.Exception: 参数错误. at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeJdCloudOrderIncSyncToSysOrder(JdSoOrderSyncToMCMSOrderPostDto pars, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 202 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-11-11 17:47:47,925 [209] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000023961857545(XD251110000755)”... 2025-11-11 17:47:49,091 [209] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 17:47:49,217 [209] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 17:49:06,612 [215] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 同步京东销售出库单“ESL00000024007568590(XD251107000537)”... 2025-11-11 17:49:07,220 [215] DEBUG WanliNiuOrderInfoService - 获取万里牛销售订单总数量：1 2025-11-11 17:49:07,332 [215] DEBUG MCMS.SaleOrder.Service.Impl.OrderInfoService - 2025-11-11 18:11:23,255 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-11-11 18:11:30,199 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-11-11 18:11:32,641 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-11-11 18:11:33,111 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-11-11 18:11:33,119 [22] WARN DotNetCore.CAP.Internal.ConsumerServiceSelector - We detected that you have duplicate subscribers (MCMS.SaleOrder.JdCloudOrderIncSyncToSysOrder) in same group (cap.queue.mcms.saleorder.v1), this will cause diversity behavior. 2025-11-11 18:11:33,179 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-11-11 18:11:33,181 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 18:11:33,207 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 7 条已确认(acked)消息. 2025-11-11 18:11:33,208 [22] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 18:11:33,214 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 18:11:33,216 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-11-11 18:11:33,219 [19] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 18:11:33,222 [19] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 5 条已确认(acked)消息. 2025-11-11 18:11:33,225 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 5 条已确认(acked)消息. 2025-11-11 18:14:56,307 [43] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.