2025-06-16 10:38:06,659 [154] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:38:06,664 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:06,667 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:06,667 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:06,668 [154] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:38:19,946 [55] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:38:19,948 [55] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:19,948 [55] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:19,948 [55] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:19,949 [55] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:38:26,247 [146] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:38:26,250 [146] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:26,250 [146] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:26,250 [146] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:26,251 [146] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:38:39,704 [289] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:38:39,705 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:39,705 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:39,706 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:38:39,706 [289] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:38:57,836 [146] DEBUG CapSubscribeService - SubscribeOperateLogBatchAdd接收到订阅:{"PlatformOperateLogs":[{"PlatformType":0,"OperatorId":1,"Operator":"Admin(WN10000)","OperateTime":"2025-06-16 10:38:57","OperateIp":"-","OperateType":1,"OperateModule":50,"OperateRemark":"修改销售线索配置：国台一部新四军 邹凤豪(WN10143) 2025年06月 不区分渠道 【每日上限】由“-1”变更为“2”【月度上限】由“-1”变更为“3”"},{"PlatformType":0,"OperatorId":1,"Operator":"Admin(WN10000)","OperateTime":"2025-06-16 10:38:57","OperateIp":"-","OperateType":1,"OperateModule":50,"OperateRemark":"修改销售线索配置：国台一部新四军 黄小妹(WN10167) 2025年06月 不区分渠道 【每日上限】由“-1”变更为“2”【月度上限】由“-1”变更为“3”"}]} 2025-06-16 10:39:04,644 [289] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:39:04,645 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:04,645 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:04,645 [289] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:04,646 [289] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:39:19,693 [154] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:39:19,695 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:19,696 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:19,696 [154] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:39:19,696 [154] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 10:41:48,630 [300] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 10:41:48,632 [300] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:41:48,632 [300] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:41:48,632 [300] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 10:41:48,632 [300] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 11:09:44,180 [403] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 11:09:44,182 [403] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:09:44,182 [403] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:09:44,182 [403] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:09:44,182 [403] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 11:20:55,012 [379] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 11:20:55,014 [379] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:20:55,014 [379] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:20:55,014 [379] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:20:55,014 [379] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 11:21:11,790 [286] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 11:21:11,793 [286] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:21:11,793 [286] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:21:11,793 [286] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 11:21:11,794 [286] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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-06-16 15:13:02,792 [236] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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-06-16 15:13:02,795 [236] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 15:13:02,795 [236] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 15:13:02,795 [236] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-16 15:13:02,796 [236] ERROR MCMS.Log.Common.GlobalExceptionFilter - URL:http://log.10g10g.com/JdSoOrderSyncLog/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2 ] Name:cp0 - Value:2025/6/1 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] Name:cp1 - Value:2025/6/17 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)] [SQL: SELECT this_.Id as id1_12_0_, this_.`JdDeptNo` as JdDeptNo2_12_0_, this_.`JdWarehouseNo` as JdWarehouseNo3_12_0_, this_.`JdSoOrderDeliveryNo` as JdSoOrderDeliveryNo4_12_0_, this_.`ErpDeliveryNo` as ErpDeliveryNo5_12_0_, this_.`SalesPlatformSource` as SalesPlatformSource6_12_0_, this_.`SalesPlatformDeliveryNo` as SalesPlatformDeliveryNo7_12_0_, this_.`WaybillNo` as WaybillNo8_12_0_, this_.`SysOrderNumber` as SysOrderNumber9_12_0_, this_.`SyncTime` as SyncTime10_12_0_, this_.`SyncResult` as SyncResult11_12_0_, this_.`SyncRemark` as SyncRemark12_12_0_, this_.`SyncUser` as SyncUser13_12_0_ FROM `JdSoOrderSyncLog` this_ WHERE this_.`SyncTime` >= ?p0 and this_.`SyncTime` < ?p1 ORDER BY this_.Id desc limit ?p2] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'this_.JdWarehouseNo' in 'field list' 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) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder) at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session) at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria) at NHibernate.Impl.CriteriaImpl.List[T]() at MCMS.Log.DAO.Hibernate.JdSoOrderSyncLogDAO.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\7\s\MCMS.Log.DAO.Hibernate\JdSoOrderSyncLogDAO.cs:line 72 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_088128406fde403db87e1692f48ea305.GetObjectListBySearch(JdSoOrderSyncLogQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) at MCMS.Log.Controllers.JdSoOrderSyncLogController.GetList(JdSoOrderSyncLogSearchDto pars) in E:\agent\_work\7\s\MCMS.Log\Controllers\JdSoOrderSyncLogController.cs:line 81 at lambda_method115(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)