2025-09-01 09:25:29,445 [229] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:29:43,646 [321] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 09:32:43,045 [19] 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-08-13 11:22:48' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128352 and Region = '内蒙古自治区|乌海市|乌达区') o where o.Score >= 80 order by o.Score desc LIMIT 20 MySql.Data.MySqlClient.MySqlException (0x80004005): FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync) at MySql.Data.MySqlClient.NativeDriver.GetResultAsync(Int32 affectedRow, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.GetResultAsync(Int32 statementId, Int32 affectedRows, Int64 insertedId, Boolean execAsync) at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-09-01 09:32:43,050 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 09:32:43,053 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 09:32:43,053 [19] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 09:32:43,060 [19] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202508131122475758;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-08-13 11:22:48' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128352 and Region = '内蒙古自治区|乌海市|乌达区') o where o.Score >= 80 order by o.Score desc LIMIT 20 ] [SQL: select o.OrderNumber,o.Address,o.CreateTime,o.DepartmentName,o.UserName,o.RealName,o.Score from(select OrderNumber,Address,CreateTime,DepartmentName,UserName,RealName,SIMILARITY_STRING('阿斯顿发文',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'内蒙古自治区乌海市乌达区',''),'内蒙古自治区',''),'乌海市',''),'内蒙古自治区乌海',''),'乌海市乌达区',''),'乌海乌达','')) as Score from OrderInfo where CreateTime <= '2025-08-13 11:22:48' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128352 and Region = '内蒙古自治区|乌海市|乌达区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 1159 at MCMS.SaleOrder.Service.Impl.SysStatisticsService.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\Sys\SysStatisticsService.cs:line 1631 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_fe70845e0f964e4c9e1505007ce98485.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1353(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-01 09:33:22,351 [346] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:38:52,566 [156] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:39:14,905 [156] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:41:17,432 [145] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":955} 2025-09-01 09:41:39,780 [165] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:42:01,114 [375] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":955} 2025-09-01 09:42:39,694 [205] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":955} 2025-09-01 09:44:11,908 [405] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":1006} 2025-09-01 09:45:01,613 [405] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":61} 2025-09-01 09:45:25,010 [371] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":6} 2025-09-01 09:45:42,310 [165] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:45:59,585 [350] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":268} 2025-09-01 09:47:11,587 [239] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":1006} 2025-09-01 09:47:31,922 [349] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":61} 2025-09-01 09:51:23,007 [383] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":506} 2025-09-01 09:55:24,174 [203] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":1006} 2025-09-01 09:55:50,625 [169] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":506} 2025-09-01 10:42:05,251 [305] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 10:48:16,374 [22] 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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省佛山市高明区',''),'广东省',''),'佛山市',''),'广东佛山',''),'佛山市高明区',''),'佛山高明','')) as Score from OrderInfo where CreateTime <= '2025-09-01 10:47:05' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128350 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-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,377 [22] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 10:48:16,378 [22] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509011047047286;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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省佛山市高明区',''),'广东省',''),'佛山市',''),'广东佛山',''),'佛山市高明区',''),'佛山高明','')) as Score from OrderInfo where CreateTime <= '2025-09-01 10:47:05' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128350 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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'广东省佛山市高明区',''),'广东省',''),'佛山市',''),'广东佛山',''),'佛山市高明区',''),'佛山高明','')) as Score from OrderInfo where CreateTime <= '2025-09-01 10:47:05' and Status in (4,5,6) and UserId is not null and UserId <> 268 and CustomerId is not null and CustomerId <> 128350 and Region = '广东省|佛山市|高明区') o where o.Score >= 80 order by o.Score desc LIMIT 20] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at MCMS.SaleOrder.DAO.Hibernate.SysStatisticsDAO.GetStringSimilarAddress(String orderNumber, String& msg) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\Sys\SysStatisticsDAO.cs:line 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 1631 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_fe70845e0f964e4c9e1505007ce98485.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1353(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-01 10:49:01,497 [175] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 10:52:50,430 [181] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 10:54:19,656 [62] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 10:55:44,803 [161] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 10:59:28,651 [126] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":268} 2025-09-01 10:59:56,085 [421] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":1006} 2025-09-01 11:00:34,565 [78] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":956} 2025-09-01 11:00:55,918 [78] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":955} 2025-09-01 11:01:48,646 [221] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":957} 2025-09-01 11:04:06,448 [169] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 11:06:15,133 [406] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":1006} 2025-09-01 11:09:57,932 [377] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 11:14:31,461 [271] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":268} 2025-09-01 11:18:16,314 [414] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 11:18:16,395 [276] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 11:18:16,463 [285] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":956} 2025-09-01 11:18:16,535 [65] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 11:19:13,352 [341] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 11:19:13,425 [305] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 11:19:13,510 [158] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":1006} 2025-09-01 11:19:13,574 [208] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 11:41:58,031 [143] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:41:58,032 [143] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:41:58,032 [143] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_e84e7759655c481683a11da3055f865e.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1800(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-01 11:42:53,468 [243] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,469 [243] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:42:53,470 [243] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_e84e7759655c481683a11da3055f865e.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1800(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-01 11:43:21,546 [422] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,548 [422] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:21,549 [422] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_e84e7759655c481683a11da3055f865e.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1800(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-01 11:43:33,722 [21] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,723 [21] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 11:43:33,724 [21] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_e84e7759655c481683a11da3055f865e.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1800(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-01 11:49:25,021 [.NET Signal Handler] INFO MCMS.SaleOrder.Startup - 【应用程序优雅关闭】 2025-09-01 11:49:31,909 [1] INFO RedisLogger - ConnectionMultiplexer(567760)附加自定义事件 2025-09-01 11:49:34,169 [1] DEBUG MCMS.SaleOrder.Startup - 项目运行环境(.NET 6.0.25)：【销售订单微服务测试环境】 2025-09-01 11:49:34,617 [1] INFO MCMS.SaleOrder.Startup - 【应用程序启动成功】 2025-09-01 11:49:34,684 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLog】成功删除 0 条已确认(acked)消息. 2025-09-01 11:49:34,686 [32] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OperateLogBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-01 11:49:34,726 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackAdd】成功删除 9 条已确认(acked)消息. 2025-09-01 11:49:34,730 [26] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.OrderTrackBatchAdd】成功删除 1 条已确认(acked)消息. 2025-09-01 11:49:34,732 [26] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackAdd】成功删除 0 条已确认(acked)消息. 2025-09-01 11:49:34,733 [32] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JDOrderTrackBatchAdd】成功删除 0 条已确认(acked)消息. 2025-09-01 11:49:34,735 [21] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Log.JdSoOrderSyncLogAdd】成功删除 0 条已确认(acked)消息. 2025-09-01 11:49:34,736 [20] DEBUG MCMS.SaleOrder.Service.Impl.SysCoreService - Redis Stream【MCMS.Warehouse.LogisticsJDOrderAdd】成功删除 0 条已确认(acked)消息. 2025-09-01 11:53:42,991 [49] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-09-01 11:54:13,665 [37] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 11:54:53,411 [46] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 11:55:09,722 [57] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 11:56:14,737 [58] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 11:56:40,177 [58] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 11:56:54,462 [60] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 13:39:12,259 [44] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 13:39:12,337 [81] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 13:39:12,408 [44] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":956} 2025-09-01 13:39:12,479 [81] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 13:39:39,976 [74] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 13:39:40,681 [44] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 13:39:43,045 [61] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":1006} 2025-09-01 13:39:43,932 [44] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 13:41:22,888 [165] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 13:41:47,253 [86] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 13:42:23,843 [148] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 13:49:51,935 [103] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 13:50:09,719 [99] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 13:50:32,093 [110] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 14:47:04,336 [140] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 14:47:27,665 [161] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 14:47:56,072 [153] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":61} 2025-09-01 14:49:34,427 [293] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 14:49:54,745 [36] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 14:51:04,762 [309] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 14:51:04,840 [310] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 14:51:04,913 [310] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":956} 2025-09-01 14:52:24,978 [314] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 14:53:27,400 [320] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 14:55:47,663 [342] 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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-01 14:54:48' and Status in (4,5,6) and UserId is not null and UserId <> 1006 and CustomerId is not null and CustomerId <> 128350 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-01 14:55:47,666 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 14:55:47,668 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 14:55:47,668 [342] ERROR NHibernate.Util.ADOExceptionReporter - FUNCTION MCMSSaleOrderV1_Dev.SIMILARITY_STRING does not exist 2025-09-01 14:55:47,676 [342] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/SysStatistics/GetStringSimilarAddress?orderNumber=202509011454473869;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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-01 14:54:48' and Status in (4,5,6) and UserId is not null and UserId <> 1006 and CustomerId is not null and CustomerId <> 128350 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('666',REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Address,' ',''),'　',''),'山西省大同市矿区',''),'山西省',''),'大同市',''),'山西大同',''),'大同市矿区',''),'大同矿','')) as Score from OrderInfo where CreateTime <= '2025-09-01 14:54:48' and Status in (4,5,6) and UserId is not null and UserId <> 1006 and CustomerId is not null and CustomerId <> 128350 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 1631 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_eeb8e19adc1641f3af743a5882a46252.GetStringSimilarAddress(String orderNumber, String& msg) at MCMS.SaleOrder.Controllers.SysStatisticsController.GetStringSimilarAddress(String orderNumber) at lambda_method1380(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-01 14:56:21,695 [341] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 14:57:00,230 [341] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 14:58:54,772 [348] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 15:15:09,102 [295] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 15:15:37,758 [86] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 15:16:17,990 [80] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 15:16:41,352 [63] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 15:17:48,290 [139] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 15:18:03,584 [133] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":268} 2025-09-01 15:18:28,975 [133] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":1006} 2025-09-01 15:42:55,578 [210] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 15:43:16,932 [212] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 15:43:36,240 [188] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 15:44:34,027 [23] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 15:44:58,396 [47] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 15:45:32,907 [19] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":6} 2025-09-01 15:46:00,293 [24] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 15:46:24,672 [52] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":955} 2025-09-01 15:49:10,095 [127] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:49:10,097 [127] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:49:10,098 [127] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5012/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_694bd853fad74e88b698bf295b80220a.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1464(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-01 15:49:30,078 [144] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 15:50:24,573 [34] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,575 [34] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:50:24,576 [34] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_694bd853fad74e88b698bf295b80220a.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1464(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-01 15:50:53,134 [127] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:50:53,202 [86] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 15:50:53,270 [34] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":1006} 2025-09-01 15:51:58,181 [295] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:51:58,246 [299] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 15:51:58,314 [36] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":956} 2025-09-01 15:52:36,838 [86] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":956} 2025-09-01 15:53:23,434 [300] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:53:23,500 [305] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 15:53:23,567 [308] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":955} 2025-09-01 15:53:23,647 [299] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 15:54:16,679 [324] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:54:21,028 [324] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":956} 2025-09-01 15:54:23,343 [300] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128351,"UserId":6} 2025-09-01 15:54:24,422 [320] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128350,"UserId":957} 2025-09-01 15:55:44,509 [336] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":956} 2025-09-01 15:56:24,818 [341] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 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-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,820 [341] ERROR NHibernate.Util.ADOExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId' at line 1 2025-09-01 15:56:24,821 [341] ERROR MCMS.SaleOrder.Common.GlobalExceptionFilter - URL:http://saleorder.10g10g.com/OrderInfo/GetClueFirstOrderOfSale;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query [ SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId; ] [SQL: SELECT o1.LInkPromotionTTClueId, o1.OrderNumber FROM OrderInfo o1 inner JOIN (SELECT LInkPromotionTTClueId, MIN(Id) AS MinId FROM OrderInfo where Status in (6) and LInkPromotionTTClueId in () GROUP BY LInkPromotionTTClueId) o2 ON o1.Id = o2.MinId;] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.ListIgnoreQueryCache(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.OrderInfoDAO.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.DAO.Hibernate\OrderInfoDAO.cs:line 689 at MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) in E:\agent\_work\4\s\MCMS.SaleOrder.Service.Impl\OrderInfoService.cs:line 7692 at _dynamic_MCMS.SaleOrder.Service.Impl.OrderInfoService.GetClueFirstOrderOfSale(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_694bd853fad74e88b698bf295b80220a.GetClueFirstOrderOfSale(List`1 statusList, List`1 clueIdList) at MCMS.SaleOrder.Controllers.OrderInfoController.GetClueFirstOrderOfSale(OrderGetClueFirstOrderOfSalePostDto pars) at lambda_method1464(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-01 15:57:42,051 [263] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:58:29,695 [334] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":1006} 2025-09-01 15:58:59,122 [276] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":6} 2025-09-01 15:59:25,549 [276] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":1006} 2025-09-01 16:01:21,089 [369] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":955} 2025-09-01 16:02:01,690 [366] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128353,"UserId":955} 2025-09-01 16:03:05,567 [365] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128352,"UserId":1006} 2025-09-01 16:03:44,141 [358] DEBUG CapSubscribeService - SubscribeUpdateCustomerLastSoldTime接收到订阅:{"CustomerId":128348,"UserId":1006}