2025-06-13 15:38:10,604 [426] 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-13 15:38:10,612 [426] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:10,614 [426] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:10,615 [426] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:10,622 [426] 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/14 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-13 15:38:30,721 [165] 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-13 15:38:30,724 [165] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:30,724 [165] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:30,725 [165] ERROR NHibernate.Util.ADOExceptionReporter - Unknown column 'this_.JdWarehouseNo' in 'field list' 2025-06-13 15:38:30,726 [165] 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/14 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)