2025-09-26 09:42:31,061 [81] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509260941245428】的物流代收货款，由 0.00 变更为 0,物流代收不存在. 2025-09-26 09:46:01,349 [271] 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-09-26 09:46:01,354 [271] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:46:01,357 [271] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:46:01,357 [271] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:46:01,370 [271] 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 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 09:48:51,355 [326] 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-09-26 09:48:51,357 [326] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:48:51,357 [326] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:48:51,357 [326] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:48:51,358 [326] 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 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 09:52:06,054 [306] 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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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-09-26 09:52:06,056 [306] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:06,056 [306] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:06,056 [306] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:06,057 [306] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509260944394816;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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 and Region = '河北省|唐山市|路北区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 09:52:28,411 [320] 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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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-09-26 09:52:28,412 [320] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:28,413 [320] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:28,413 [320] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:52:28,413 [320] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509260944394816;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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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 <= '2025-09-26 09:44:39' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 and Region = '河北省|唐山市|路北区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 09:59:49,344 [118] 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-09-26 09:59:49,346 [118] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:59:49,346 [118] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:59:49,346 [118] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 09:59:49,347 [118] 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 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 10:08:03,059 [290] 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('wfergtyj',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-26 09:58:56' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128360 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-09-26 10:08:03,060 [290] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:08:03,060 [290] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:08:03,060 [290] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:08:03,061 [290] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509260958561473;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('wfergtyj',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-26 09:58:56' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128360 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('wfergtyj',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-26 09:58:56' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128360 and Region = '山西省|大同市|矿区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 10:23:12,492 [24] 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('121221',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省通化市辉南县',''),'吉林省',''),'通化市',''),'吉林通化',''),'通化市辉南县',''),'通化辉南县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 10:22:21' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128361 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-09-26 10:23:12,494 [24] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:23:12,494 [24] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:23:12,494 [24] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 10:23:12,495 [24] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509261022215371;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('121221',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省通化市辉南县',''),'吉林省',''),'通化市',''),'吉林通化',''),'通化市辉南县',''),'通化辉南县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 10:22:21' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128361 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('121221',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省通化市辉南县',''),'吉林省',''),'通化市',''),'吉林通化',''),'通化市辉南县',''),'通化辉南县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 10:22:21' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128361 and Region = '吉林省|通化市|辉南县') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_15f1e3307b654523b09b1cdbab928680.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1596(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-09-26 10:30:00,859 [178] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261022215371】的物流代收货款，由 0.00 变更为 1.0,物流代收不存在. 2025-09-26 10:43:46,819 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-09-26 10:43:52,887 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-09-26 10:43:55,334 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-09-26 10:43:55,799 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-09-26 10:43:55,870 [30] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-09-26 10:43:55,872 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 10:43:55,900 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 2 条已确认(acked)消息. 2025-09-26 10:43:55,902 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 1 条已确认(acked)消息. 2025-09-26 10:43:55,904 [29] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 10:43:55,905 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 10:43:55,907 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 10:43:55,909 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 10:45:38,583 [36] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-09-26 11:16:24,391 [165] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261058102577】的物流代收货款，由 1.00 变更为 1.00,物流代收不存在. 2025-09-26 13:43:05,752 [157] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261143372870】的物流代收货款，由 0.00 变更为 0,物流代收不存在. 2025-09-26 13:43:21,043 [129] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261143372870】的物流代收货款，由 0.00 变更为 0,物流代收不存在. 2025-09-26 13:46:14,100 [79] 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 <= '2025-09-26 11:43:37' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128364 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-09-26 13:46:14,103 [79] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 13:46:14,104 [79] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 13:46:14,105 [79] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 13:46:14,113 [79] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509261143372870;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 <= '2025-09-26 11:43:37' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128364 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 <= '2025-09-26 11:43:37' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128364 and Region = '内蒙古自治区|乌海市|乌达区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_63decb53b0734aa6978c55f798a171d6.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method2087(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-09-26 13:46:57,525 [85] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128364,"UserId":268} 2025-09-26 14:40:18,682 [156] DEBUG CapSubscribeService - SubscribeOrderCompleteV4接收到订阅:{"OrderNumber":"202509261058102577","Freight":0.0,"Fee":0.0,"OPUserId":1,"OPUser":"Admin(WN10000)","ReceiptTime":null} 2025-09-26 14:40:18,710 [156] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.OrderCompleteV4, Id:4694676012250660913, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 ---> System.Exception: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-09-26 14:40:18,712 [156] WARN DotNetCore.CAP.Internal.SubscribeExecutor - The 1th retrying consume a message failed. message id: 4694676012250660913 2025-09-26 14:40:18,742 [139] DEBUG CapSubscribeService - SubscribeOrderCompleteV4接收到订阅:{"OrderNumber":"202509261058102577","Freight":0.0,"Fee":0.0,"OPUserId":1,"OPUser":"Admin(WN10000)","ReceiptTime":null} 2025-09-26 14:40:18,762 [139] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.OrderCompleteV4, Id:4694676012250660913, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 ---> System.Exception: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-09-26 14:40:18,762 [139] WARN DotNetCore.CAP.Internal.SubscribeExecutor - The 2th retrying consume a message failed. message id: 4694676012250660913 2025-09-26 14:40:18,788 [139] DEBUG CapSubscribeService - SubscribeOrderCompleteV4接收到订阅:{"OrderNumber":"202509261058102577","Freight":0.0,"Fee":0.0,"OPUserId":1,"OPUser":"Admin(WN10000)","ReceiptTime":null} 2025-09-26 14:40:18,811 [139] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - An exception occurred while executing the subscription method. Topic:MCMS.SaleOrder.OrderCompleteV4, Id:4694676012250660913, Instance: DevelopmentServer DotNetCore.CAP.Internal.SubscriberExecutionFailedException: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 ---> System.Exception: SubscribeOrderCompleteV4处理失败，订单【202509261058102577】有其他应代收款项 at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) --- End of inner exception stack trace --- at MCMS.SaleOrder.Service.Impl.CapSubscribeService.SubscribeOrderCompleteV4(OrderCompleteV4PostDto data, CapHeader header) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\CAP\CapSubscribeService.cs:line 109 at Microsoft.Extensions.Internal.ObjectMethodExecutor.<>c__DisplayClass30_0.b__0(Object target, Object[] parameters) at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at DotNetCore.CAP.Internal.SubscribeInvoker.ExecuteWithParameterAsync(ObjectMethodExecutor executor, Object class, Object[] parameter) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeInvoker.InvokeAsync(ConsumerContext context, CancellationToken cancellationToken) at DotNetCore.CAP.Internal.SubscribeExecutor.InvokeConsumerMethodAsync(MediumMessage message, ConsumerExecutorDescriptor descriptor, CancellationToken cancellationToken) 2025-09-26 14:49:03,522 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-09-26 14:49:09,837 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-09-26 14:49:12,445 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-09-26 14:49:12,962 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-09-26 14:49:13,034 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:13,036 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:13,069 [33] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 18 条已确认(acked)消息. 2025-09-26 14:49:13,073 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 12 条已确认(acked)消息. 2025-09-26 14:49:13,075 [23] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:13,077 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:13,079 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:13,081 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 14:49:25,900 [27] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-09-26 15:07:24,338 [3] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261503319238】的物流代收货款，由 10.00 变更为 0,物流代收不存在. 2025-09-26 15:07:58,279 [33] INFO MCMS.SaleOrder.Service.Impl.OrderInfoService - 订单【202509261503319238】的物流代收货款，由 0.00 变更为 0,物流代收不存在. 2025-09-26 15:08:39,575 [20] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:03:32' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-26 15:08:39,578 [20] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:08:39,580 [20] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:08:39,580 [20] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:08:39,589 [20] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509261503319238;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:03:32' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('黎族路1号',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'吉林省白山市长白朝鲜族自治县',''),'吉林省',''),'白山市',''),'吉林白山',''),'白山市长白朝鲜族自治县',''),'白山长白朝鲜族自治县','')) as Score from OrderInfo where CreateTime <= '2025-09-26 15:03:32' and Status in (4,5,6) and UserId is not null and UserId <> 472 and CustomerId is not null and CustomerId <> 128309 and Region = '吉林省|白山市|长白朝鲜族自治县') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_8430cd9fa66f4c2081597feac9cfc772.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1536(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-09-26 15:26:48,282 [203] 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 <= '2025-09-26 15:25:13' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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-09-26 15:26:48,284 [203] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:26:48,284 [203] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:26:48,284 [203] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-26 15:26:48,285 [203] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509261525139115;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 <= '2025-09-26 15:25:13' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 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 <= '2025-09-26 15:25:13' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128344 and Region = '河北省|唐山市|路北区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1630 at _dynamic_MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors) at CompositionAopProxy_8430cd9fa66f4c2081597feac9cfc772.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1536(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-09-26 16:04:47,358 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-09-26 16:04:54,321 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-09-26 16:04:56,794 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-09-26 16:04:57,276 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-09-26 16:04:57,337 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,340 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,342 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,343 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,345 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,347 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,348 [32] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:04:57,350 [25] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-09-26 16:05:52,740 [35] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.