dhis2-devs team mailing list archive

Thread
Date
Can't delete a tracked entity in dhis2.25

To: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Kamugunga Adolphe <kaadol@xxxxxxxxx>
Date: Thu, 16 Feb 2017 18:11:33 +0200
Hi,
I need help,
i have upgraded our case based report system from 2.24 to version 2.25
Build revision:9f6b262Build date:2017-02-16 06:42The system looks working
fine i can navigate in all apps, but while trying to delete a registered
person in TB tracker program, the system pops up a confirmation window.
After confriming the system displays the message " Error: Could no execute
the statement". Here is the screen[image: Inline images 1]Reading from the
logs file here is the

* INFO  2017-02-16 17:43:58,736 Deleted objects associated with object of
type ProgramStageInstance (DefaultDeletionManager.java [tomcat-http-2])
* INFO  2017-02-16 17:43:58,888 'akamugunga' delete
org.hisp.dhis.program.ProgramStageInstance,
uid: x4vCP11wix6 (AuditLogUtil.java [tomcat-http-2])
* INFO  2017-02-16 17:43:59,050 Deleted objects associated with object of
type ProgramInstance (DefaultDeletionManager.java [tomcat-http-2])
* INFO  2017-02-16 17:43:59,051 'akamugunga' delete
org.hisp.dhis.program.ProgramInstance,
uid: NEwNjmV50iU (AuditLogUtil.java [tomcat-http-2])
* INFO  2017-02-16 17:43:59,284 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,334 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,351 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,357 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,386 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,414 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,437 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,457 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,468 Deleted objects associated with object of
type TrackedEntityAttributeValue (DefaultDeletionManager.java
[tomcat-http-2])
* INFO  2017-02-16 17:43:59,483 Deleted objects associated with object of
type TrackedEntityInstance (DefaultDeletionManager.java [tomcat-http-2])
* INFO  2017-02-16 17:43:59,514 'akamugunga' delete
org.hisp.dhis.trackedentity.TrackedEntityInstance, uid: SdalPo5bhdy
(AuditLogUtil.java [tomcat-http-2])
* WARN  2017-02-16 17:43:59,822 SQL Error: 0, SQLState: 23503
(SqlExceptionHelper.java [tomcat-http-2])
* ERROR 2017-02-16 17:43:59,825 ERROR: update or delete on table
"trackedentityinstance" violates foreign key constraint
"fk_trackedentityauditid_trackedentityinstanceid" on table
"trackedentityaudit"
  Detail: Key (trackedentityinstanceid)=(186670) is still referenced from
table "trackedentityaudit". (SqlExceptionHelper.java [tomcat-http-2])
* ERROR 2017-02-16 17:43:59,827 HHH000346: Error during managed flush
[could not execute statement] (SessionImpl.java [tomcat-http-2])
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint
[fk_trackedentityauditid_trackedentityinstanceid];
nested exception is org.hibernate.exception.ConstraintViolationException:
could not execute statement
    at org.springframework.orm.hibernate5.SessionFactoryUtils.
convertHibernateAccessException(SessionFactoryUtils.java:164)
    at org.springframework.orm.hibernate5.HibernateTransactionManager.
convertHibernateAccessException(HibernateTransactionManager.java:741)
    at org.springframework.orm.hibernate5.HibernateTransactionManager.
doCommit(HibernateTransactionManager.java:589)
    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.
commitTransactionAfterReturning(TransactionAspectSupport.java:485)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:291)
    at org.springframework.transaction.interceptor.
TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.adapter.
MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.
invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy135.deleteTrackedEntityInstance(Unknown Source)
    at org.hisp.dhis.dxf2.events.trackedentity.
AbstractTrackedEntityInstanceService.deleteTrackedEntityInstance(
AbstractTrackedEntityInstanceService.java:439)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.
invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:202)
    at com.sun.proxy.$Proxy232.deleteTrackedEntityInstance(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.
invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.
invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.support.DelegatingIntroductionIntercep
tor.doProceed(DelegatingIntroductionInterceptor.java:133)
    at org.springframework.aop.support.DelegatingIntroductionIntercep
tor.invoke(DelegatingIntroductionInterceptor.java:121)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy192.deleteTrackedEntityInstance(Unknown Source)
    at org.hisp.dhis.webapi.controller.event.TrackedEntityInstanceControlle
r.deleteTrackedEntityInstance(TrackedEntityInstanceController.java:492)
    at org.hisp.dhis.webapi.controller.event.TrackedEntityInstanceControlle
r$$FastClassBySpringCGLIB$$cfbc2606.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(
MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$
CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
    at org.springframework.security.access.intercept.aopalliance.
MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.CglibAopProxy$
DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
    at org.hisp.dhis.webapi.controller.event.TrackedEntityInstanceControlle
r$$EnhancerBySpringCGLIB$$e98e183b.deleteTrackedEntityInstance(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.web.method.support.InvocableHandlerMethod.
doInvoke(InvocableHandlerMethod.java:221)
    at org.springframework.web.method.support.InvocableHandlerMethod.
invokeForRequest(InvocableHandlerMethod.java:136)
    at org.springframework.web.servlet.mvc.method.annotation.
ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.
java:110)
    at org.springframework.web.servlet.mvc.method.annotation.
RequestMappingHandlerAdapter.invokeHandlerMethod(
RequestMappingHandlerAdapter.java:817)
    at org.springframework.web.servlet.mvc.method.annotation.
RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
java:731)
    at org.springframework.web.servlet.mvc.method.
AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    at org.springframework.web.servlet.DispatcherServlet.
doDispatch(DispatcherServlet.java:959)
    at org.springframework.web.servlet.DispatcherServlet.
doService(DispatcherServlet.java:893)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(
FrameworkServlet.java:968)
    at org.springframework.web.servlet.FrameworkServlet.
doDelete(FrameworkServlet.java:892)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
    at org.springframework.web.servlet.FrameworkServlet.
service(FrameworkServlet.java:844)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(
WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at org.springframework.security.web.access.intercept.
FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.
FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.
doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.session.SessionManagementFilter.
doFilter(SessionManagementFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.
AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
java:113)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.servletapi.
SecurityContextHolderAwareRequestFilter.doFilter(
SecurityContextHolderAwareRequestFilter.java:154)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.savedrequest.
RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.www.
BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.hisp.dhis.security.filter.CorsFilter.doFilter(
CorsFilter.java:126)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.
AbstractAuthenticationProcessingFilter.doFilter(
AbstractAuthenticationProcessingFilter.java:199)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.
AbstractAuthenticationProcessingFilter.doFilter(
AbstractAuthenticationProcessingFilter.java:199)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(
CustomAuthenticationFilter.java:64)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.oauth2.provider.authentication.
OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessing
Filter.java:140)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.logout.
LogoutFilter.doFilter(LogoutFilter.java:110)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(
AutomaticAccessFilter.java:115)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.header.HeaderWriterFilter.
doFilterInternal(HeaderWriterFilter.java:57)
    at org.springframework.web.filter.OncePerRequestFilter.
doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.request.async.
WebAsyncManagerIntegrationFilter.doFilterInternal(
WebAsyncManagerIntegrationFilter.java:50)
    at org.springframework.web.filter.OncePerRequestFilter.
doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.
SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
er.java:87)
    at org.springframework.security.web.FilterChainProxy$
VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(
FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(
FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(
DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
DelegatingFilterProxy.java:262)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(
HttpUrlPatternFilter.java:105)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.springframework.web.filter.ShallowEtagHeaderFilter.
doFilterInternal(ShallowEtagHeaderFilter.java:87)
    at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFil
ter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:110)
    at org.springframework.web.filter.OncePerRequestFilter.
doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.
doFilterInternal(OpenSessionInViewFilter.java:151)
    at org.springframework.web.filter.OncePerRequestFilter.
doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.springframework.web.filter.CharacterEncodingFilter.
doFilterInternal(CharacterEncodingFilter.java:121)
    at org.springframework.web.filter.OncePerRequestFilter.
doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
AuthenticatorBase.java:505)
    at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:103)
    at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:436)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(
AbstractHttp11Processor.java:1078)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
process(AbstractProtocol.java:625)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
run(JIoEndpoint.java:316)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.ConstraintViolationException: could not
execute statement
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(
SQLStateConversionDelegate.java:112)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.
convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:111)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:97)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:207)
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
NonBatchingBatch.java:45)
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(
AbstractEntityPersister.java:3233)
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(
AbstractEntityPersister.java:3470)
    at org.hibernate.action.internal.EntityDeleteAction.execute(
EntityDeleteAction.java:98)
    at org.hibernate.engine.spi.ActionQueue.executeActions(
ActionQueue.java:560)
    at org.hibernate.engine.spi.ActionQueue.executeActions(
ActionQueue.java:434)
    at org.hibernate.event.internal.AbstractFlushingEventListener.
performExecutions(AbstractFlushingEventListener.java:337)
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(
DefaultFlushEventListener.java:39)
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468)
    at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompleti
on(SessionImpl.java:3135)
    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(
SessionImpl.java:2352)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.
beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
    at org.hibernate.resource.transaction.backend.jdbc.internal.
JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(
JdbcResourceLocalTransactionCoordinatorImpl.java:147)
    at org.hibernate.resource.transaction.backend.jdbc.internal.
JdbcResourceLocalTransactionCoordinatorImpl.access$100(
JdbcResourceLocalTransactionCoordinatorImpl.java:38)
    at org.hibernate.resource.transaction.backend.jdbc.internal.
JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.
commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
    at org.hibernate.engine.transaction.internal.TransactionImpl.commit(
TransactionImpl.java:65)
    at org.springframework.orm.hibernate5.HibernateTransactionManager.
doCommit(HibernateTransactionManager.java:581)
    ... 137 more
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on
table "trackedentityinstance" violates foreign key constraint
"fk_trackedentityauditid_trackedentityinstanceid" on table
"trackedentityaudit"
  Detail: Key (trackedentityinstanceid)=(186670) is still referenced from
table "trackedentityaudit".
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:2455)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:2155)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:288)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(
PgPreparedStatement.java:168)
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(
PgPreparedStatement.java:135)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(
NewProxyPreparedStatement.java:105)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:204)
    ... 155 more
Thanks


*Adolphe Kamugunga*
*MIS Technical Advisor*
Mobile: +250 788 740 578 <0788%20740%20578>
Email:kaadol@xxxxxxxxx
Skype: ka.adolphe
 RWANDA