No entity found for query

fernando · 17 June 2022 13:13

Hi all.

I am getting this error ‘No entity found for query’ when I click on share settings or design data entry form options of a data set, so I can’t either share the data set or access the form editor of the data set.

Thanks

Gassim · 17 June 2022 16:10

Hi @fernando

Is this for all data sets or a particular one? Would you please check the Network tab in your browser’s developer tools (F12) and see if there is an error please take a screenshot? You will open the tools right before the error appears.

Thanks!

fernando · 18 June 2022 16:15

Hi @Gassim.

No, this is not for all data sets. It’s only for 4 data sets.

“httpStatus”:“Internal Server Error”,“httpStatusCode”:500,“status”:“ERROR”,“message”:“No entity found for query”}

Thanks

Gassim · 7 July 2022 17:00

Sorry the screenshot doesn’t say much except the generic error. It does say that it’s a server side issue so we might need the Catalina.out log (without sensitive info)

Thanks!

chase.freeman · 22 July 2022 13:18

I’m getting this error when trying to open a program (the network request is to /metadata endpoint and when using the /api/identifiableObjects endpoints. Version 2.36.10

{“httpStatus”:“Internal Server Error”,“httpStatusCode”:500,“status”:“ERROR”,“message”:“No entity found for query”}

Log Error:

Jul 22 13:02:40 5b43a4ea server: IDZPACxRTajH3Z6QvjSTPP6CheAepkQleLNF+NHwXAN/k=javax.persistence.NoResultException: No entity found for query
Jul 22 13:02:40 5b43a4ea server: at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1643)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.user.hibernate.HibernateUserStore.getDisplayName(HibernateUserStore.java:579)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.user.DefaultUserService.lambda$getDisplayName$2(DefaultUserService.java:822)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.cache.LocalCache.get(LocalCache.java:115)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.user.DefaultUserService.getDisplayName(DefaultUserService.java:822)
Jul 22 13:02:40 5b43a4ea server: at sun.reflect.GeneratedMethodAccessor4112.invoke(Unknown Source)
Jul 22 13:02:40 5b43a4ea server: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Jul 22 13:02:40 5b43a4ea server: at java.lang.reflect.Method.invoke(Method.java:498)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
Jul 22 13:02:40 5b43a4ea server: at com.sun.proxy.$Proxy137.getDisplayName(Unknown Source)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:428)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:316)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:528)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:592)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:316)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.lambda$toCollectionNode$0(DefaultFieldFilterService.java:251)
Jul 22 13:02:40 5b43a4ea server: at java.util.ArrayList.forEach(ArrayList.java:1257)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.toCollectionNode(DefaultFieldFilterService.java:250)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.dxf2.metadata.DefaultMetadataExportService.getMetadataAsNode(DefaultMetadataExportService.java:230)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.webapi.controller.metadata.MetadataImportExportController.getMetadata(MetadataImportExportController.java:247)
Jul 22 13:02:40 5b43a4ea server: at sun.reflect.GeneratedMethodAccessor4264.invoke(Unknown Source)
Jul 22 13:02:40 5b43a4ea server: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Jul 22 13:02:40 5b43a4ea server: at java.lang.reflect.Method.invoke(Method.java:498)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
Jul 22 13:02:40 5b43a4ea server: at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
Jul 22 13:02:40 5b43a4ea server: at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.servlet.filter.AppOverrideFilter.doFilterInternal(AppOverrideFilter.java:175)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.webapi.filter.RequestIdentifierFilter.doFilterInternal(RequestIdentifierFilter.java:105)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(HttpUrlPatternFilter.java:123)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.webapi.filter.ExcludableShallowEtagHeaderFilter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:125)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:182)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:149)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.webapi.filter.CorsFilter.doFilter(CorsFilter.java:116)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.hisp.dhis.webapi.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:90)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
Jul 22 13:02:40 5b43a4ea server: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
Jul 22 13:02:40 5b43a4ea server: at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
Jul 22 13:02:40 5b43a4ea server: at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
Jul 22 13:02:40 5b43a4ea server: at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
Jul 22 13:02:40 5b43a4ea server: at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1615)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
Jul 22 13:02:40 5b43a4ea server: at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
Jul 22 13:02:40 5b43a4ea server: at java.lang.Thread.run(Thread.java:748)

sele · 15 August 2022 20:10

@chase.freeman , I am facing a similar problem on one of my instances. For it happens when I am editing a dataset or Aggregate data elements.

Did you find any solution or any idea on how to solve this. catalina doesn’t say much.

INFO 2022-08-15T19:55:09,785 Hibernate caches cleared (DefaultHibernateCacheManager.java [http-nio-8080-exec-2]) IDNxVnTM2q7mbAoYq3JZbQECbJ92UItZGnwN6Z16BJZaM=
javax.persistence.NoResultException: No entity found for query
at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1643)
at org.hisp.dhis.user.hibernate.HibernateUserStore.getDisplayName(HibernateUserStore.java:608)
at org.hisp.dhis.user.DefaultUserService.lambda$getDisplayName$2(DefaultUserService.java:836)
at org.hisp.dhis.cache.LocalCache.get(LocalCache.java:116)
at org.hisp.dhis.user.DefaultUserService.getDisplayName(DefaultUserService.java:836)
at jdk.internal.reflect.GeneratedMethodAccessor1159.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy138.getDisplayName(Unknown Source)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:405)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:312)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:505)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:312)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.lambda$toCollectionNode$0(DefaultFieldFilterService.java:247)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.toCollectionNode(DefaultFieldFilterService.java:246)
at org.hisp.dhis.webapi.controller.AbstractFullReadOnlyController.getObjectInternal(AbstractFullReadOnlyController.java:390)
at org.hisp.dhis.webapi.controller.AbstractFullReadOnlyController.getObject(AbstractFullReadOnlyController.java:259)
at jdk.internal.reflect.GeneratedMethodAccessor1158.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.hisp.dhis.commons.jsonfiltering.web.JsonFilteringRequestFilter.doFilter(JsonFilteringRequestFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.hisp.dhis.servlet.filter.AppOverrideFilter.doFilterInternal(AppOverrideFilter.java:175)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.hisp.dhis.webapi.filter.RequestIdentifierFilter.doFilterInternal(RequestIdentifierFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
at org.hisp.dhis.webapi.filter.ExcludableShallowEtagHeaderFilter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:125)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(HttpUrlPatternFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:149)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.hisp.dhis.webapi.filter.CorsFilter.doFilter(CorsFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.hisp.dhis.webapi.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)

Gassim · 17 August 2022 07:56

@fernando @chase.freeman @sele

I’ve been following up with @dhis2-platform about this. As @viet suggested, here’s the jira bug issue: https://jira.dhis2.org/browse/DHIS2-13607

Thank you!

sele · 22 August 2022 14:18

Thanks @Gassim. I will follow-up on the bugs.

I had to forcefully change the Sharing setting at the back-end (PostgreSQL) to Public, and update the version to 2.37.7.1. At least solved my challenge

Innocentmwaba · 31 January 2023 17:37

I am experiencing this error “No entity found for query” when i try to open the dataset. Anyone to assist me with the solution?

Gassim · 31 January 2023 17:42

Welcome to the community @Innocentmwaba!

So this is a well known issue. Please watch the jira ticket to receive updates on the issue.

@Innocentmwaba could you try this suggested solution and see if it works for you?

Thanks!

It might also help if you please provide the following info:

Innocentmwaba · 31 January 2023 18:21

Well noted. Let me try that