2025-05-28 10:23:14,096 [218] 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 and Region = '辽宁省|鞍山市|台安县') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-05-28 10:23:14,098 [218] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:23:14,098 [218] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:23:14,098 [218] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:23:14,099 [218] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202311071607460182;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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) 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 1158 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 1600 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_58202f484ace4277b893b68fa0f9488c.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1021(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-05-28 10:41:17,186 [228] 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 and Region = '辽宁省|鞍山市|台安县') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-05-28 10:41:17,188 [228] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:41:17,189 [228] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:41:17,189 [228] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 10:41:17,189 [228] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202311071607460182;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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) 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 1158 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 1600 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_58202f484ace4277b893b68fa0f9488c.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1021(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-05-28 11:55:23,851 [251] 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 and Region = '辽宁省|鞍山市|台安县') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-05-28 11:55:23,854 [251] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 11:55:23,854 [251] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 11:55:23,854 [251] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 11:55:23,856 [251] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/SysStatistics/GetStringSimilarAddress?orderNumber=202311071607460182;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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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('11',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省鞍山市台安县',''),'辽宁省',''),'鞍山市',''),'辽宁鞍山',''),'鞍山市台安县',''),'鞍山台安县','')) as Score from OrderInfo where CreateTime <= '2023-11-07 16:07:47' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128341 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.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) 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 1158 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 1600 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_58202f484ace4277b893b68fa0f9488c.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1021(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-05-28 11:55:26,819 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-05-28 11:55:33,843 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-05-28 11:55:36,414 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-05-28 11:55:36,937 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-05-28 11:56:10,412 [31] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-05-28 14:33:40,617 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-05-28 14:33:47,547 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-05-28 14:33:49,883 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-05-28 14:33:50,353 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-05-28 14:34:43,160 [35] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-05-28 14:48:30,325 [107] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('复州城镇.',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省大连市瓦房店市',''),'辽宁省',''),'大连市',''),'辽宁大连',''),'大连市瓦房店市',''),'大连瓦房店市','')) as Score from OrderInfo where CreateTime <= '2023-10-24 17:19:03' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 22654 and Region = '辽宁省|大连市|瓦房店市') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-05-28 14:48:30,329 [107] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:30,330 [107] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:30,331 [107] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:30,339 [107] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202310241719036974;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('复州城镇.',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省大连市瓦房店市',''),'辽宁省',''),'大连市',''),'辽宁大连',''),'大连市瓦房店市',''),'大连瓦房店市','')) as Score from OrderInfo where CreateTime <= '2023-10-24 17:19:03' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 22654 and Region = '辽宁省|大连市|瓦房店市') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('复州城镇.',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省大连市瓦房店市',''),'辽宁省',''),'大连市',''),'辽宁大连',''),'大连市瓦房店市',''),'大连瓦房店市','')) as Score from OrderInfo where CreateTime <= '2023-10-24 17:19:03' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 22654 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 1158 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 1600 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_d29d610e3db848d2b5120c20f7a4b811.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method418(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2025-05-28 14:48:34,828 [109] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('详细地址',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市南郊区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市南郊区',''),'大同南郊','')) as Score from OrderInfo where CreateTime <= '2023-10-16 16:49:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128318 and Region = '山西省|大同市|南郊区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-05-28 14:48:34,830 [109] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:34,830 [109] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:34,830 [109] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-05-28 14:48:34,832 [109] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202310161649015524;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('详细地址',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市南郊区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市南郊区',''),'大同南郊','')) as Score from OrderInfo where CreateTime <= '2023-10-16 16:49:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128318 and Region = '山西省|大同市|南郊区') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('详细地址',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市南郊区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市南郊区',''),'大同南郊','')) as Score from OrderInfo where CreateTime <= '2023-10-16 16:49:02' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128318 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 1158 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 1600 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_d29d610e3db848d2b5120c20f7a4b811.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method418(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)