2025-10-21 09:17:48,616 [372] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: INSERT INTO `PackagingPurchaseOrder` (`OrderType`, `OrderStatus`, `ContractNumber`, `PurchaseOrderNumber`, `PurchaseOrderTitle`, `PurchasingCompanyInfoId`, `PurchasingCompanyName`, `SupplierId`, `SupplierName`, `OrderDate`, `TotalAmount`, `PaidAmount`, `InvoicedAmount`, `ShouldInvoicedAmount`, `NotInvoicedAmount`, `NotPaidAmount`, `Remark`, `AttachmentFile`, `PaymentDetail`, `Creator`, `CreateTime`, `Updater`, `UpdateTime`, `Reviewer`, `ReviewDate`, `IsDeleted`) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25);SELECT LAST_INSERT_ID()
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry 'BCCG20251020192534075' for key 'PackagingPurchaseOrder.UIndex_PurchaseOrderNumber'
   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-10-21 09:17:48,627 [372] ERROR NHibernate.Util.ADOExceptionReporter - Duplicate entry 'BCCG20251020192534075' for key 'PackagingPurchaseOrder.UIndex_PurchaseOrderNumber'
2025-10-21 09:17:48,647 [372] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/PackagingPurchaseOrder/AddOrUpdate;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not insert: [MCMS.SaleOrder.Entities.PackagingPurchaseOrder][SQL: INSERT INTO `PackagingPurchaseOrder` (`OrderType`, `OrderStatus`, `ContractNumber`, `PurchaseOrderNumber`, `PurchaseOrderTitle`, `PurchasingCompanyInfoId`, `PurchasingCompanyName`, `SupplierId`, `SupplierName`, `OrderDate`, `TotalAmount`, `PaidAmount`, `InvoicedAmount`, `ShouldInvoicedAmount`, `NotInvoicedAmount`, `NotPaidAmount`, `Remark`, `AttachmentFile`, `PaymentDetail`, `Creator`, `CreateTime`, `Updater`, `UpdateTime`, `Reviewer`, `ReviewDate`, `IsDeleted`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);SELECT LAST_INSERT_ID()]   at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session)
   at NHibernate.Action.EntityIdentityInsertAction.Execute()
   at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable)
   at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
   at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
   at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
   at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
   at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
   at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event)
   at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event)
   at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event)
   at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event)
   at NHibernate.Impl.SessionImpl.Save(Object obj)
   at MCMS.SaleOrder.DAO.Hibernate.GenericHibernateDAO`2.Insert(T entity) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Common\GenericHibernateDAO.cs:line 178
   at MCMS.SaleOrder.Service.Impl.PackagingPurchaseOrderService.Add(PackagingPurchaseOrder entity) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\PackagingPurchaseOrderService.cs:line 75
   at _dynamic_MCMS.SaleOrder.Service.Impl.PackagingPurchaseOrderService.Add(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_5aec746c031f4d34b8c0120873700870.Add(PackagingPurchaseOrder entity)
   at MCMS.SaleOrder.Controllers.PackagingPurchaseOrderController.AddOrUpdate(PackagingPurchaseOrderPostDto pars)
   at lambda_method875(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-21 11:05:48,222 [.NET Signal Handler] INFO  MCMS.SaleOrder.Startup - 【应用程序优雅关闭】
2025-10-21 11:05:55,213 [1] INFO  RedisLogger - ConnectionMultiplexer(567760)附加自定义事件
2025-10-21 11:05:57,752 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】
2025-10-21 11:05:58,256 [1] INFO  MCMS.SaleOrder.Startup - 【应用程序启动成功】
2025-10-21 11:05:58,346 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 1 条已确认(acked)消息.
2025-10-21 11:05:58,348 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:05:58,352 [17] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 1 条已确认(acked)消息.
2025-10-21 11:05:58,353 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:05:58,356 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 1 条已确认(acked)消息.
2025-10-21 11:05:58,358 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:05:58,362 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 3 条已确认(acked)消息.
2025-10-21 11:05:58,371 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 1 条已确认(acked)消息.
2025-10-21 11:06:21,636 [34] WARN  Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.
2025-10-21 11:34:46,523 [.NET Signal Handler] INFO  MCMS.SaleOrder.Startup - 【应用程序优雅关闭】
2025-10-21 11:34:53,485 [1] INFO  RedisLogger - ConnectionMultiplexer(567760)附加自定义事件
2025-10-21 11:34:55,928 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】
2025-10-21 11:34:56,410 [1] INFO  MCMS.SaleOrder.Startup - 【应用程序启动成功】
2025-10-21 11:34:56,483 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,485 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,486 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,488 [31] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,490 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,492 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,493 [24] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:34:56,495 [27] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息.
2025-10-21 11:36:20,921 [37] WARN  Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.
2025-10-21 14:22:26,958 [87] 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('未知12',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省阳泉市郊区',''),'山西省',''),'阳泉市',''),'山西阳泉',''),'阳泉市郊区',''),'阳泉郊','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:21:43' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128343 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-10-21 14:22:26,962 [87] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:22:26,963 [87] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:22:26,964 [87] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:22:26,972 [87] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202510211421426085;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('未知12',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省阳泉市郊区',''),'山西省',''),'阳泉市',''),'山西阳泉',''),'阳泉市郊区',''),'阳泉郊','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:21:43' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128343 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('未知12',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省阳泉市郊区',''),'山西省',''),'阳泉市',''),'山西阳泉',''),'阳泉市郊区',''),'阳泉郊','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:21:43' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128343 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_56775c88f157427788439a634d43f220.GetStringSimilarAddress(String orderNumber, String& msg)
   at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber)
   at lambda_method1369(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-21 14:48:26,551 [177] 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-10-21 14:47:08' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128367 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-10-21 14:48:26,552 [177] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:48:26,552 [177] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:48:26,552 [177] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:48:26,554 [177] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202510211447085926;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-10-21 14:47:08' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128367 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-10-21 14:47:08' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128367 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_56775c88f157427788439a634d43f220.GetStringSimilarAddress(String orderNumber, String& msg)
   at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber)
   at lambda_method1369(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-21 14:54:30,182 [184] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:53:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20
MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync)
   at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync)
   at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync)
   at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd)
2025-10-21 14:54:30,184 [184] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:54:30,184 [184] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:54:30,184 [184] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist
2025-10-21 14:54:30,185 [184] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202510211453272672;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query
[ select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:53:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20 ]
[SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('s',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'辽宁省抚顺市顺城区',''),'辽宁省',''),'抚顺市',''),'辽宁抚顺',''),'抚顺市顺城区',''),'抚顺顺城','')) as Score from OrderInfo where CreateTime <= '2025-10-21 14:53:27' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128340 and Region = '辽宁省|抚顺市|顺城区') o where o.Score >= 80 order by o.Score desc LIMIT 20]   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder)
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces)
   at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.List()
   at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 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_56775c88f157427788439a634d43f220.GetStringSimilarAddress(String orderNumber, String& msg)
   at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber)
   at lambda_method1369(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)