2026-01-03 00:30:06,526 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 【JdCloudOrderWithWanliNiuOrderSyncToMCMSOrderSSE】(HttpContext:48491001){"JdDeptNo":"EBU4418055145647","JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":"【定时服务】","IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null} 2026-01-03 00:30:06,701 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 前置数据准备，已耗时: 0s 2026-01-03 00:30:06,705 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步仓库【118068240、118083324、118074989、110021918】“2025-12-31”数据. 2026-01-03 00:30:07,347 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单“EPL4418105316045”... 2026-01-03 00:30:07,443 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单“EPL4418105318813”... 2026-01-03 00:30:07,533 [187] ERROR MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单【EPL4418105318813】到MCMS系统出错：京东事业部商品【EMG4418927265889】未映射，请先进行“SKU配置” 2026-01-03 00:30:07,534 [187] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 总耗时: 1s 2026-01-03 09:28:55,205 [59] 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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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) 2026-01-03 09:28:55,207 [59] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:28:55,207 [59] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:28:55,207 [59] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:28:55,209 [59] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202601030911552193;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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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_5e6941239e334b508a0858c27cf33c21.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1972(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) 2026-01-03 09:53:04,307 [101] 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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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) 2026-01-03 09:53:04,309 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:04,309 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:04,309 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:04,310 [101] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202601030911552193;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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山东省济南市历下区',''),'山东省',''),'济南市',''),'山东济南',''),'济南市历下区',''),'济南历下','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:11:55' and Status in (4,5,6) and UserId is not null and UserId <> 956 and CustomerId is not null and CustomerId <> 128352 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_5e6941239e334b508a0858c27cf33c21.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1972(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) 2026-01-03 09:53:40,749 [101] 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('dz',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省太原市小店区',''),'山西省',''),'太原市',''),'山西太原',''),'太原市小店区',''),'太原小店','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:18:16' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128369 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) 2026-01-03 09:53:40,751 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:40,751 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:40,751 [101] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-01-03 09:53:40,752 [101] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202601030918157268;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('dz',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省太原市小店区',''),'山西省',''),'太原市',''),'山西太原',''),'太原市小店区',''),'太原小店','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:18:16' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128369 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('dz',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省太原市小店区',''),'山西省',''),'太原市',''),'山西太原',''),'太原市小店区',''),'太原小店','')) as Score from OrderInfo where CreateTime <= '2026-01-03 09:18:16' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128369 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_5e6941239e334b508a0858c27cf33c21.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1972(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) 2026-01-03 10:06:06,006 [321] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128369,"UserId":268} 2026-01-03 10:16:11,559 [350] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956}