← Back to team overview

dhis2-users team mailing list archive

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