2026-01-30 00:30:05,840 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 【JdCloudOrderWithWanliNiuOrderSyncToMCMSOrderSSE】(HttpContext:24433332){"JdDeptNo":"EBU4418055145647","JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":"【定时服务】","IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null}
2026-01-30 00:30:06,040 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 前置数据准备，已耗时: 0s
2026-01-30 00:30:06,044 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步仓库【118068240、118083324、118074989、110021918】“2026-01-07”数据.
2026-01-30 00:30:06,676 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单“EPL4418107085055”...
2026-01-30 00:30:06,831 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单“EPL4418108737780”...
2026-01-30 00:30:06,960 [340] ERROR MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单【EPL4418108737780】到MCMS系统出错：京东事业部商品【EMG4418969698531】未映射，请先进行“SKU配置”
2026-01-30 00:30:06,960 [340] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 总耗时: 1s
2026-01-30 18:14:40,203 [.NET Signal Handler] INFO  MCMS.SaleOrder.Startup - 【应用程序优雅关闭】
2026-01-30 18:14:46,034 [1] INFO  RedisLogger - ConnectionMultiplexer(567760)附加自定义事件
2026-01-30 18:14:48,426 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】
2026-01-30 18:14:48,887 [1] INFO  MCMS.SaleOrder.Startup - 【应用程序启动成功】
2026-01-30 18:14:48,972 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 1 条已确认(acked)消息.
2026-01-30 18:14:48,974 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,982 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,986 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 1 条已确认(acked)消息.
2026-01-30 18:14:48,987 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,989 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,991 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,993 [19] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,995 [19] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:48,997 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.SaleOrder.UpdateCustomerLastSoldTime】成功删除 0 条已确认(acked)消息.
2026-01-30 18:14:58,527 [20] WARN  Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.
2026-01-30 18:15:53,823 [17] 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('1111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-12-21 17:04:12' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128376 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 MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd)
2026-01-30 18:15:53,828 [17] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2026-01-30 18:15:53,829 [17] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2026-01-30 18:15:53,830 [17] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2026-01-30 18:15:53,840 [17] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202512221704142110;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('1111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-12-21 17:04:12' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128376 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('1111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-12-21 17:04:12' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128376 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_b8d7ed3ae6f7434cb8be22e89132eab6.GetStringSimilarAddress(String orderNumber, String& msg)
   at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber)
   at lambda_method391(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.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2026-01-30 20:33:53,349 [.NET Signal Handler] INFO  MCMS.SaleOrder.Startup - 【应用程序优雅关闭】
2026-01-30 20:33:59,601 [1] INFO  RedisLogger - ConnectionMultiplexer(567760)附加自定义事件
2026-01-30 20:34:01,963 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】
2026-01-30 20:34:02,438 [1] INFO  MCMS.SaleOrder.Startup - 【应用程序启动成功】
2026-01-30 20:34:02,497 [32] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,500 [30] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,507 [30] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,508 [30] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,510 [30] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,512 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,513 [29] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,515 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,517 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.ProductWarehouseOutByOrder】成功删除 0 条已确认(acked)消息.
2026-01-30 20:34:02,519 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.SaleOrder.UpdateCustomerLastSoldTime】成功删除 0 条已确认(acked)消息.
2026-01-30 20:43:35,935 [70] WARN  Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.