Figures dont save in data visualizer app after upgrading to 2.39.1.2

Haliz.t · 8 May 2023 09:54

Dear CoP member,
Good day,

i have upgraded my DHIS 2 instance from 2.38.1.1 to 2.39.1.2 and am trying to save figures generated by the Data Visualizer app, however when i click on save i get a message of (Something went wrong, There was a problem getting the data from the server) i opened the network consul and this is what i found

this is the response
{“httpStatus”:“Internal Server Error”,“httpStatusCode”:500,“status”:“ERROR”,“message”:“ERROR: cannot execute nextval() in a read-only transaction”}

What to do, please?

Gassim · 8 May 2023 15:21

Please clear the server cache using Data Administration app → Maintenance, clear application cache & reload apps. And then please run the analytics tables export in the same app.

After that please check the Catalina.out log if there are any errors, if not please login to the instance using your browser’s Guest mode (to make sure it’s not a cache issue) , so if it works then go back to your usual browser profile and clear the cache.

If it doesn’t work and there are errors in the log, please share the full Catalina.out log (without sensitive info)

Thanks!

Haliz.t · 19 May 2023 18:25

dear @Gassim Thanks for your continuous support.
i tried all what you have mentioned including the guest mode , and i still get the same problem… and i dont know how to look for the catalina.out log…

Gassim · 22 May 2023 10:12

Hi

Thanks!

To monitor the behavior of Tomcat the log is the primary source of information. The log can be viewed with the following command:
tail -f tomcat-dhis/logs/catalina.out
(source)

Please make sure to remove any sensitive info before sharing.

Haliz.t · 4 June 2023 15:05

Dear @Gassim
so this is the information in Catalina.out

Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: Jun 04 17:31:15 tracker tomcat9[8918]: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:107)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:534)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:114)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:194)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:179)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:100)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:75)
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:652)
at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:645)
at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:640)
at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.save(HibernateIdentifiableObjectStore.java:182)
at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.save(HibernateIdentifiableObjectStore.java:123)
at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.save(HibernateIdentifiableObjectStore.java:111)
at org.hisp.dhis.period.hibernate.HibernatePeriodStore.addPeriod(HibernatePeriodStore.java:93)
at org.hisp.dhis.period.hibernate.HibernatePeriodStore.reloadForceAddPeriod(HibernatePeriodStore.java:204)
at org.hisp.dhis.period.DefaultPeriodService.reloadPeriods(DefaultPeriodService.java:192)
at jdk.internal.reflect.GeneratedMethodAccessor8319.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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy188.reloadPeriods(Unknown Source)
at org.hisp.dhis.dimension.DefaultDimensionService.mergeDimensionalObjects(DefaultDimensionService.java:580)
at org.hisp.dhis.dimension.DefaultDimensionService.mergeAnalyticalObject(DefaultDimensionService.java:309)
at jdk.internal.reflect.GeneratedMethodAccessor5106.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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy207.mergeAnalyticalObject(Unknown Source)
at org.hisp.dhis.webapi.controller.VisualizationController.addDimensionsInto(VisualizationController.java:86)
at org.hisp.dhis.webapi.controller.VisualizationController.deserializeJsonEntity(VisualizationController.java:77)
at org.hisp.dhis.webapi.controller.VisualizationController.deserializeJsonEntity(VisualizationController.java:51)
at org.hisp.dhis.webapi.controller.AbstractCrudController.postJsonObject(AbstractCrudController.java:432)
at jdk.internal.reflect.GeneratedMethodAccessor8760.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:1071)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
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:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.hisp.dhis.webapi.filter.AppOverrideFilter.doFilterInternal(AppOverrideFilter.java:106)
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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.hisp.dhis.webapi.filter.RequestIdentifierFilter.doFilterInternal(RequestIdentifierFilter.java:95)
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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
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:123)
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: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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:352)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:117)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:126)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:120)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:164)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:170)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.hisp.dhis.webapi.security.apikey.Dhis2ApiTokenFilter.doFilterInternal(Dhis2ApiTokenFilter.java:111)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.hisp.dhis.webapi.filter.CorsFilter.doFilter(CorsFilter.java:152)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:151)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:129)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.hisp.dhis.webapi.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:107)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:93)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
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:361)
at org.hisp.dhis.webapi.filter.CspFilter.doFilterInternal(CspFilter.java:81)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.context.SecurityContextHolderFilter.doFilter(SecurityContextHolderFilter.java:82)
at org.springframework.security.web.context.SecurityContextHolderFilter.doFilter(SecurityContextHolderFilter.java:69)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:62)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.session.ForceEagerSessionCreationFilter.doFilterInternal(ForceEagerSessionCreationFilter.java:45)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:361)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:225)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:190)
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: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: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: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:117)
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:117)
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.security.config.WebMvcMetricsConfig$PassThroughWebMvcMetricsFilter.doFilterInternal(WebMvcMetricsConfig.java:99)
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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:375)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute nextval() in a read-only transaction
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
… 182 more

Gassim · 6 June 2023 16:05

The errors you are seeing are related to issues with the app connecting to the database which means we need to check the database configuration. Please check your postgresql.conf file for any configuration that’s different from the default settings in the documentation.

I’d start with these headings:

Client Connection Defaults
Resource Usage
Connections and Authentication
Replication
Write Ahead Log

Thanks!