← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] daily scheduling task error

 

Hi,

Could you create an issue for this error on
Jira, and include the version number?

24. jul. 2017 00:13 skrev "林晓东" <lin_xd@xxxxxxx>:

> 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(AbstractPlatformTransactionMan
> ager.java:730)
>         at org.springframework.transaction.interceptor.
> TransactionAspectSupport.commitTransactionAfterReturnin
> g(TransactionAspectSupport.java:504)
>         at org.springframework.transaction.interceptor.
> TransactionAspectSupport.invokeWithinTransaction(
> TransactionAspectSupport.java:292)
>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References