dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #49732
daily scheduling task error
hi,all,
How to deal with this? Thanks.
--------------------------
* ERROR 2017-07-24 02:00:00,052 ERROR: update or delete operation on "fileresource" violate "externalfileresource" 's foreign key constraint "fk_fileresource_externalfileresource"
详细:键值对(fileresourceid)=(862296)仍然是从表"externalfileresource"引用的. (SqlExceptionHelper.java [taskScheduler-10])
* INFO 2017-07-24 02:00:00,068 'system-process' create org.hisp.dhis.datastatistics.DataStatistics, uid: SYKwYegFjqG (AuditLogUtil.java [taskScheduler-18])
* ERROR 2017-07-24 02:00:00,068 HHH000346: Error during managed flush [could not execute statement] (SessionImpl.java [taskScheduler-10])
* ERROR 2017-07-24 02:00:00,084 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-10])
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:241)
at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:755)
at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:590)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
Follow ups