2026-04-10 00:30:04,256 [469] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 【JdCloudOrderWithWanliNiuOrderSyncToMCMSOrderSSE】(HttpContext:14663494){"JdDeptNo":"EBU4418055145647","JdWarehouseNo":null,"JdSoOrderDeliveryNos":null,"JdSoOrderSendTimePeriod":null,"OpUserId":0,"OpUser":"【定时服务】","IsIncSync":false,"JdPoOrderNo":null,"JdRtwOrderNo":null,"JdSoOrderNo":null,"JdRtsOrderNo":null} 2026-04-10 00:30:04,636 [469] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 前置数据准备，已耗时: 0s 2026-04-10 00:30:04,659 [469] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步仓库【118068240、118083324、118074989、110021918】“2026-01-29”数据. 2026-04-10 00:30:05,545 [469] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单“EPL4418107062813”... 2026-04-10 00:30:05,707 [469] ERROR MCMS.SaleOrder.Controllers.OrderInfoController - 同步京东云仓采购入库单【EPL4418107062813】到MCMS系统出错：京东事业部商品【EMG4418952447525】未映射，请先进行“SKU配置” 2026-04-10 00:30:05,707 [469] DEBUG MCMS.SaleOrder.Controllers.OrderInfoController - 总耗时: 1s 2026-04-10 09:43:31,779 [493] 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('sjhgfshjfvw',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:37:58' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128399 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-04-10 09:43:31,784 [493] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:43:31,786 [493] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:43:31,787 [493] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:43:31,799 [493] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604100937581741;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('sjhgfshjfvw',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:37:58' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128399 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('sjhgfshjfvw',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:37:58' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128399 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 09:46:00,789 [27] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 09:46:00,791 [27] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:46:00,791 [27] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:46:00,792 [27] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:46:00,793 [27] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604011108281378;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 09:52:28,973 [425] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128399,"UserId":268} 2026-04-10 09:57:29,952 [348] 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('sdfvsdfs',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'内蒙古自治区乌海市海南区',''),'内蒙古自治区',''),'乌海市',''),'内蒙古自治区乌海',''),'乌海市海南区',''),'乌海海南','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:56:34' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128400 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-04-10 09:57:29,954 [348] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:57:29,954 [348] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:57:29,954 [348] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 09:57:29,955 [348] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604100956340627;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('sdfvsdfs',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'内蒙古自治区乌海市海南区',''),'内蒙古自治区',''),'乌海市',''),'内蒙古自治区乌海',''),'乌海市海南区',''),'乌海海南','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:56:34' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128400 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('sdfvsdfs',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'内蒙古自治区乌海市海南区',''),'内蒙古自治区',''),'乌海市',''),'内蒙古自治区乌海',''),'乌海市海南区',''),'乌海海南','')) as Score from OrderInfo where CreateTime <= '2026-04-10 09:56:34' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128400 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 10:31:38,327 [183] 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('白玉区元下田永泰1823微牛电商209',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:28:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128401 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-04-10 10:31:38,330 [183] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:31:38,330 [183] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:31:38,330 [183] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:31:38,332 [183] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604101028369267;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('白玉区元下田永泰1823微牛电商209',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:28:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128401 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('白玉区元下田永泰1823微牛电商209',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:28:36' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128401 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 10:50:49,395 [279] 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('永泰1823',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:50:07' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128402 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-04-10 10:50:49,398 [279] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:50:49,398 [279] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:50:49,398 [279] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 10:50:49,400 [279] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604101050078046;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('永泰1823',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:50:07' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128402 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('永泰1823',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 10:50:07' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128402 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 11:28:55,841 [654] 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('黄边村居安里15号楼201(驿站:后园街45号店',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 11:28:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128387 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-04-10 11:28:55,843 [654] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:28:55,843 [654] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:28:55,843 [654] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:28:55,844 [654] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604101128266563;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('黄边村居安里15号楼201(驿站:后园街45号店',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 11:28:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128387 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('黄边村居安里15号楼201(驿站:后园街45号店',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省广州市白云区',''),'广东省',''),'广州市',''),'广东广州',''),'广州市白云区',''),'广州白云','')) as Score from OrderInfo where CreateTime <= '2026-04-10 11:28:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128387 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 11:35:36,692 [93] 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 <= '2026-04-10 11:34:56' 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) 2026-04-10 11:35:36,694 [93] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:35:36,694 [93] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:35:36,694 [93] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 11:35:36,695 [93] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202604101134557027;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 <= '2026-04-10 11:34:56' 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 <= '2026-04-10 11:34:56' 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:47:01,055 [443] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 14:47:01,056 [443] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:01,056 [443] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:01,057 [443] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:01,058 [443] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604011108281378;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:47:25,134 [671] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2026-04-01 10:38:59' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 14:47:25,136 [671] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:25,136 [671] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:25,136 [671] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:25,137 [671] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604011038597590;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2026-04-01 10:38:59' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2026-04-01 10:38:59' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:47:35,208 [254] 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) 2026-04-10 14:47:35,209 [254] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:35,209 [254] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:35,209 [254] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:35,210 [254] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:47:47,427 [469] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 14:47:47,429 [469] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:47,429 [469] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:47,429 [469] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:47:47,430 [469] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604011108281378;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:49:18,133 [54] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 14:49:18,135 [54] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:49:18,135 [54] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:49:18,135 [54] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:49:18,136 [54] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604011108281378;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:53:08,869 [579] 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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-04-10 14:53:08,871 [579] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:53:08,871 [579] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:53:08,871 [579] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:53:08,872 [579] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604011108281378;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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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('11111',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市抚顺县',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市抚顺县',''),'抚顺抚顺县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 11:08:21' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128391 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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-04-10 14:54:46,971 [399] 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('浏万路101号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'浙江省嘉兴市海盐县',''),'浙江省',''),'嘉兴市',''),'浙江嘉兴',''),'嘉兴市海盐县',''),'嘉兴海盐县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 09:38:46' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128390 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-04-10 14:54:46,973 [399] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:54:46,973 [399] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:54:46,973 [399] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2026-04-10 14:54:46,974 [399] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202604010938461405;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('浏万路101号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'浙江省嘉兴市海盐县',''),'浙江省',''),'嘉兴市',''),'浙江嘉兴',''),'嘉兴市海盐县',''),'嘉兴海盐县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 09:38:46' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128390 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('浏万路101号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'浙江省嘉兴市海盐县',''),'浙江省',''),'嘉兴市',''),'浙江嘉兴',''),'嘉兴市海盐县',''),'嘉兴海盐县','')) as Score from OrderInfo where CreateTime <= '2026-04-01 09:38:46' and Status in (4,5,6) and UserId is not null and UserId <> 4 and CustomerId is not null and CustomerId <> 128390 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 1048 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 1622 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_ae190d0a3e364d91a108c18a9403367d.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1473(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)