2025-04-01 15:25:59,966 [.NET Signal Handler] INFO MCMS.Finance.Startup - 【应用程序优雅关闭】 2025-04-01 15:26:06,235 [1] INFO RedisLogger - ConnectionMultiplexer(24152954)附加自定义事件 2025-04-01 15:26:08,280 [1] DEBUG MCMS.Finance.Startup - 项目运行环境(.NET 6.0.25)：【财务微服务测试环境】 2025-04-01 15:26:08,675 [1] INFO MCMS.Finance.Startup - 【应用程序启动成功】 2025-04-01 15:41:19,758 [99] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-04-01 16:40:29,876 [.NET Signal Handler] INFO MCMS.Finance.Startup - 【应用程序优雅关闭】 2025-04-01 16:40:36,470 [1] INFO RedisLogger - ConnectionMultiplexer(24152954)附加自定义事件 2025-04-01 16:40:38,582 [1] DEBUG MCMS.Finance.Startup - 项目运行环境(.NET 6.0.25)：【财务微服务测试环境】 2025-04-01 16:40:39,110 [1] INFO MCMS.Finance.Startup - 【应用程序启动成功】 2025-04-01 16:41:19,801 [38] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect. 2025-04-01 16:44:40,775 [45] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: INSERT INTO `WeComFundApproval` (`FundOAType`, `FundTypeText`, `FundOANumber`, `Applyer`, `ApplyTime`, `ApprovalStatus`, `FundReason`, `FundTotal`, `PayTypeText`, `Payee`, `PayeeBank`, `PayeeBankNo`, `SourceJson`, `UseDepartmentId`, `UseDepartment`, `PayStatus`, `OpUser`, `OpTime`, `OpRemark`, `IsWage`, `IsBuy`, `PayCompany`, `PayAccount`, `PayTime`) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23);SELECT LAST_INSERT_ID() MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '202504010088-0' for key 'WeComFundApproval.Index_FundOANumber' 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 MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) 2025-04-01 16:44:40,781 [45] ERROR NHibernate.Util.ADOExceptionReporter - Duplicate entry '202504010088-0' for key 'WeComFundApproval.Index_FundOANumber' 2025-04-01 16:44:40,782 [45] ERROR NHibernate.Event.Default.AbstractFlushingEventListener - Could not synchronize database state with session NHibernate.Exceptions.GenericADOException: could not insert: [MCMS.Finance.Entities.WeComFundApproval][SQL: INSERT INTO `WeComFundApproval` (`FundOAType`, `FundTypeText`, `FundOANumber`, `Applyer`, `ApplyTime`, `ApprovalStatus`, `FundReason`, `FundTotal`, `PayTypeText`, `Payee`, `PayeeBank`, `PayeeBankNo`, `SourceJson`, `UseDepartmentId`, `UseDepartment`, `PayStatus`, `OpUser`, `OpTime`, `OpRemark`, `IsWage`, `IsBuy`, `PayCompany`, `PayAccount`, `PayTime`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);SELECT LAST_INSERT_ID()] ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '202504010088-0' for key 'WeComFundApproval.Index_FundOANumber' 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 MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(DbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) --- End of inner exception stack trace --- at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list) at NHibernate.Engine.ActionQueue.ExecuteActions() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) 2025-04-01 16:44:40,807 [45] ERROR MCMS.Finance.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5011/WeComFundApproval/WeComFundApprovalCrawl;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not insert: [MCMS.Finance.Entities.WeComFundApproval][SQL: INSERT INTO `WeComFundApproval` (`FundOAType`, `FundTypeText`, `FundOANumber`, `Applyer`, `ApplyTime`, `ApprovalStatus`, `FundReason`, `FundTotal`, `PayTypeText`, `Payee`, `PayeeBank`, `PayeeBankNo`, `SourceJson`, `UseDepartmentId`, `UseDepartment`, `PayStatus`, `OpUser`, `OpTime`, `OpRemark`, `IsWage`, `IsBuy`, `PayCompany`, `PayAccount`, `PayTime`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);SELECT LAST_INSERT_ID()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list) at NHibernate.Engine.ActionQueue.ExecuteActions() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) at NHibernate.Impl.SessionImpl.Flush() at MCMS.Finance.DAO.Hibernate.GenericHibernateDAO`2.BatchDBOperate(ICollection`1 entity, Action`1 fun) in E:\agent\_work\5\s\MCMS.Finance.DAO.Hibernate\Common\GenericHibernateDAO.cs:line 170 at MCMS.Finance.DAO.Hibernate.GenericHibernateDAO`2.Insert(ICollection`1 entity) in E:\agent\_work\5\s\MCMS.Finance.DAO.Hibernate\Common\GenericHibernateDAO.cs:line 145 at MCMS.Finance.Service.Impl.WeComFundApprovalService.BatchAdd(List`1 entities) in E:\agent\_work\5\s\MCMS.Finance.Service.Impl\WeComFundApprovalService.cs:line 206 at MCMS.Finance.Service.Impl.WeComFundApprovalService.WeComFundApprovalCrawl(Int32 useDepartmentId, String useDepartment, OATemplateType fundOAType, String oACorpId, String oACorpSecret, String oATemplateId, DateTime crawDateBegin, DateTime crawDateEnd, String& msg, Nullable`1 spStatus, Int32 cursor) at _dynamic_MCMS.Finance.Service.Impl.WeComFundApprovalService.WeComFundApprovalCrawl(Object , Object[] ) at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments) at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint() at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation) at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() at Spring.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_c45e6f1e5431461c903f3bbec8f7b270.WeComFundApprovalCrawl(Int32 useDepartmentId, String useDepartment, OATemplateType fundOAType, String oACorpId, String oACorpSecret, String oATemplateId, DateTime crawDateBegin, DateTime crawDateEnd, String& msg, Nullable`1 spStatus, Int32 cursor) at MCMS.Finance.Controllers.WeComFundApprovalController.WeComFundApprovalCrawl(WeComFundApprovalCrawlPostDto pars) at lambda_method68(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-04-01 17:20:48,699 [.NET Signal Handler] INFO MCMS.Finance.Startup - 【应用程序优雅关闭】 2025-04-01 17:20:55,436 [1] INFO RedisLogger - ConnectionMultiplexer(24152954)附加自定义事件 2025-04-01 17:20:57,613 [1] DEBUG MCMS.Finance.Startup - 项目运行环境(.NET 6.0.25)：【财务微服务测试环境】 2025-04-01 17:20:58,001 [1] INFO MCMS.Finance.Startup - 【应用程序启动成功】 2025-04-01 17:41:19,739 [102] WARN Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware - Failed to determine the https port for redirect.