daily scheduling task error

Support - Assistance technique
1

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)

2

Hi,

Could you create an issue for this error on

Jira, and include the version number?

···
  1. jul. 2017 00:13 skrev “林晓东” lin_xd@126.com:

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)

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp