Hi,
We have deleted some individual’s profile in tracker capture and that is not showing in Tracker Capture when we search but it appears in the list of event reports. Please suggest how to delete that permanently.
Regards,
Pradeep
3 Likes
Hi Pradeep,
You remove soft deleted values under Data Administration > Maintenance
Regards,
···
Elmarie Claasen
Project Manager
Health Information Systems Program
Tel: 041-367 1027
Cell: 082 374 2209
E-mail: elmarie@hisp.org
Skype: elmarie.claasen52
From: Dhis2-devs dhis2-devs-bounces+elmarie=hisp.org@lists.launchpad.net On Behalf Of Pradeep Kumar Thakur
Sent: Wednesday, November 7, 2018 1:30 PM
To: DHIS 2 Users list dhis2-users@lists.launchpad.net; dhis2-devs dhis2-devs@lists.launchpad.net
Subject: [Dhis2-devs] How to delete individuals from Tracker Capture permanently version 2.9
Hi,
We have deleted some individual’s profile in tracker capture and that is not showing in Tracker Capture when we search but it appears in the list of event reports. Please suggest how to delete that permanently.
Regards,
Pradeep
2 Likes
Thank you Elmarie for guidance.
Regards,
Pradeep
···
From: Elmarie Claasen elmarie@hisp.org
Sent: Wednesday, November 7, 2018 6:29 PM
To: Pradeep Kumar Thakur pthakur@fhi360.org; DHIS 2 Users list dhis2-users@lists.launchpad.net; dhis2-devs dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] How to delete individuals from Tracker Capture permanently version 2.9
Hi Pradeep,
You remove soft deleted values under Data Administration > Maintenance
Regards,
Elmarie Claasen
Project Manager
Health Information Systems Program
Tel: 041-367 1027
Cell: 082 374 2209
E-mail: elmarie@hisp.org
Skype: elmarie.claasen52
From: Dhis2-devs dhis2-devs-bounces+elmarie=hisp.org@lists.launchpad.net On Behalf Of Pradeep Kumar Thakur
Sent: Wednesday, November 7, 2018 1:30 PM
To: DHIS 2 Users list dhis2-users@lists.launchpad.net; dhis2-devs dhis2-devs@lists.launchpad.net
Subject: [Dhis2-devs] How to delete individuals from Tracker Capture permanently version 2.9
Hi,
We have deleted some individual’s profile in tracker capture and that is not showing in Tracker Capture when we search but it appears in the list of event reports. Please suggest how to delete that permanently.
Regards,
Pradeep
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to
disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
2 Likes
Hi Elmarie
I was wondering if you (or anyone else) could assist me with this issue. I am also attempting to delete the TEIs from a tracker program and have deleted the records from the actual program. I then went to Data Administration to “Permanently remove soft deleted tracked entity instances”, but received the following error:
ERROR: update or delete on table “trackedentityinstance” violates foreign key
I have attempted to do maintenance on other options, such as “permanently remove soft deleted enrollments” and this worked.
Do you have any idea what could be causing this?
Thanks!
I am running v2.30 build revision 853d10f on Widows Chrome.
2 Likes
Hi Terence,
To be honest I have not used this in v2.30 as we have not upgraded our tracker production instances to 2.30 yet.
However from the errors you are receiving I would recommend you look at the Tracked Entity instances, Program instances and Program stage instances. You would need to delete these in reverse order and ensure that on deleting a Tracked Entity Instance it is not enrolled in any other programs.
Maybe someone else in the community can provide further guidance.
Regards,
Elmarie
2 Likes
Hi @Pradeep and @Terence_Scott,
Hope you can now permanently delete individual’s profile in the tracker capture app as DHIS2-5456 was resolved and available on the build release.
Best,
James.
1 Like
Hi @jomutsani
Thanks for the update, this is great news. We have unfortunately not yet upgraded to the latest build release or V2.32 yet but are thankful that the issue has been resolved by the team!
2 Likes
Hi@jomutsani after upgrade from 2.34.0 to 2.34.1 iam still facing this issue
Detail: Key (trackedentityinstanceid)=(100719) is still referenced from table “relationshipitem”.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.java:1013)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:550)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:536)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
… 143 more
org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [delete from trackedentitydatavalueaudit where programstageinstanceid in (select programstageinstanceid from programstageinstance where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ) ); delete from programstageinstancecomments where programstageinstanceid in (select programstageinstanceid from programstageinstance where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ) ); delete from trackedentitycomment where trackedentitycommentid not in (select trackedentitycommentid from programstageinstancecomments union all select trackedentitycommentid from programinstancecomments); delete from programstageinstance where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ); delete from programmessage_deliverychannels where programmessagedeliverychannelsid in (select id from programmessage where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ) ); delete from programmessage_emailaddresses where programmessageemailaddressid in (select id from programmessage where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ) ); delete from programmessage_phonenumbers where programmessagephonenumberid in (select id from programmessage where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ) ); delete from programmessage where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ); delete from programinstancecomments where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ); delete from trackedentitycomment where trackedentitycommentid not in (select trackedentitycommentid from programstageinstancecomments union all select trackedentitycommentid from programinstancecomments); delete from programinstance where programinstanceid in (select programinstanceid from programinstance where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true) ); delete from trackedentityattributevalue where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true); delete from trackedentityattributevalueaudit where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true); delete from trackedentityprogramowner where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true); delete from programownershiphistory where trackedentityinstanceid in (select trackedentityinstanceid from trackedentityinstance where deleted is true); delete from trackedentityinstance where deleted is true]; ERROR: update or delete on table “trackedentityinstance” violates foreign key constraint “fk_relationshipitem_trackedentityinstanceid” on table “relationshipitem”
Detail: Key (trackedentityinstanceid)=(100719) is still referenced from table “relationshipitem”.; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table “trackedentityinstance” violates foreign key constraint “fk_relationshipitem_trackedentityinstanceid” on table “relationshipitem”
Detail: Key (trackedentityinstanceid)=(100719) is still referenced from table “relationshipitem”.
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:590)
at org.hisp.dhis.maintenance.jdbc.JdbcMaintenanceStore.deleteSoftDeletedTrackedEntityInstances(JdbcMaintenanceStore.java:168)
at org.hisp.dhis.maintenance.DefaultMaintenanceService.deleteSoftDeletedTrackedEntityInstances(DefaultMaintenanceService.java:162)
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:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
at com.sun.proxy.$Proxy281.deleteSoftDeletedTrackedEntityInstances(Unknown Source)
at org.hisp.dhis.webapi.controller.MaintenanceController.deleteSoftDeletedTrackedEntityInstances(MaintenanceController.java:190)
at org.hisp.dhis.webapi.controller.MaintenanceController.performMaintenance(MaintenanceController.java:367)
at org.hisp.dhis.webapi.controller.MaintenanceController$$FastClassBySpringCGLIB$$a0db5fcb.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at org.hisp.dhis.webapi.controller.MaintenanceController$$EnhancerBySpringCGLIB$$efe44d0e.performMaintenance()
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:190)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.hisp.dhis.webapi.config.WebMvcMetricsConfig$PassThroughWebMvcMetricsFilter.doFilterInternal(WebMvcMetricsConfig.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.hisp.dhis.servlet.filter.RequestIdentifierFilter.doFilterInternal(RequestIdentifierFilter.java:103)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:155)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.hisp.dhis.security.filter.CorsFilter.doFilter(CorsFilter.java:126)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:69)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:180)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:115)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:152)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(HttpUrlPatternFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:104)
at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:112)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table “trackedentityinstance” violates foreign key constraint “fk_relationshipitem_trackedentityinstanceid” on table “relationshipitem”
Detail: Key (trackedentityinstanceid)=(100719) is still referenced from table “relationshipitem”.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.java:1013)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:550)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:536)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
… 143 more
Thanks @dguambe, there is a related JIRA issue here: [DHIS2-6770] - Jira? so we will look into whether it has showed up again in 2.34.0/2.34.1.
Best regards,
Karoline