Android 2.5.1 AutoValue_D2Error (bug or configuration error)

RaTED_S · 28 August 2022 10:14

Cause: The server could not complete this request.

Exception: retrofit2.adapter.rxjava2.HttpException: HTTP 500

Created: Sun Aug 28 11:42:59 GMT+02:00 2022

Http Error Code: 500

Error component: Server

Url: https://myserver.org/dataentry/api/programStages?fields=id,code,name,displayName,created,lastUpdated,deleted,description,displayDescription,executionDateLabel,dueDateLabel,allowGenerateNextVisit,validCompleteOnly,reportDateToUse,openAfterEnrollment,repeatable,captureCoordinates,featureType,formType,displayGenerateEventBox,generatedByEnrollmentDate,autoGenerateEvent,sortOrder,hideDueDate,blockEntryForm,minDaysFromStart,standardInterval,programStageSections[id,code,name,displayName,created,lastUpdated,deleted,sortOrder,programIndicators[id],dataElements[id],renderType],programStageDataElements[id,code,name,displayName,created,lastUpdated,deleted,displayInReports,dataElement[id,code,name,displayName,created,lastUpdated,deleted,shortName,displayShortName,description,displayDescription,valueType,zeroIsSignificant,aggregationType,formName,domainType,displayFormName,optionSet[id],categoryCombo[id],fieldMask,style[color,icon],access[read],legendSets[id],attributeValues[value,attribute[id,code,name,displayName,created,lastUpdated,deleted,shortName,displayShortName,description,displayDescription,valueType,unique,mandatory,indicatorAttribute,indicatorGroupAttribute,userGroupAttribute,dataElementAttribute,constantAttribute,categoryOptionAttribute,optionSetAttribute,sqlViewAttribute,legendSetAttribute,trackedEntityAttributeAttribute,organisationUnitAttribute,dataSetAttribute,documentAttribute,validationRuleGroupAttribute,dataElementGroupAttribute,sectionAttribute,trackedEntityTypeAttribute,userAttribute,categoryOptionGroupAttribute,programStageAttribute,programAttribute,categoryAttribute,categoryOptionComboAttribute,categoryOptionGroupSetAttribute,validationRuleAttribute,programIndicatorAttribute,organisationUnitGroupAttribute,dataElementGroupSetAttribute,organisationUnitGroupSetAttribute,optionAttribute]]],compulsory,allowProvidedElsewhere,sortOrder,allowFutureDate,renderType,programStage[id]],style[color,icon],periodType,program,access[data[write]],remindCompleted,enableUserAssignment,attributeValues[value,attribute[id,code,name,displayName,created,lastUpdated,deleted,shortName,displayShortName,description,displayDescription,valueType,unique,mandatory,indicatorAttribute,indicatorGroupAttribute,userGroupAttribute,dataElementAttribute,constantAttribute,categoryOptionAttribute,optionSetAttribute,sqlViewAttribute,legendSetAttribute,trackedEntityAttributeAttribute,organisationUnitAttribute,dataSetAttribute,documentAttribute,validationRuleGroupAttribute,dataElementGroupAttribute,sectionAttribute,trackedEntityTypeAttribute,userAttribute,categoryOptionGroupAttribute,programStageAttribute,programAttribute,categoryAttribute,categoryOptionComboAttribute,categoryOptionGroupSetAttribute,validationRuleAttribute,programIndicatorAttribute,organisationUnitGroupAttribute,dataElementGroupSetAttribute,organisationUnitGroupSetAttribute,optionAttribute]]&filter=program.id:in:[za0h99Xd5wr,uQZsAclhMvC,aRUVZ8JUihb,R8wqb6fpfxA]&filter=access.data.read:eq:true&paging=false

StackTrace: org.hisp.dhis.android.core.maintenance.AutoValue_D2Error

GOT THAT ERROR WHEN TRYING TO LOG IN ON ANDROID DHIS 2 CAPTURE APP V2.6.2

vgarciabnz · 29 August 2022 12:24

Hi @RaTED_S,

it seems that the server returns an error 500. Could you try copy/paste the url in a browser and check if the server’s response is correct?

RaTED_S · 29 August 2022 19:44

Hie @vgarciabnz

even on Browser its returning error 500…that error massage was generated when trying to login to Android Captured

raju · 30 August 2022 10:34

Hi @RaTED_S

i got same error few weeks ago. The following worked for me,

Long press Dhis2 app icon → App info → Clear data → Clear Cache-> Login

if this doesn’t work you can try clear all data option

vgarciabnz · 30 August 2022 11:01

If the browser returns an error 500, then it seems to be an issue in the backend. Do you have access to server logs? If so, try a query in the browser and share with us the error

RaTED_S · 31 August 2022 09:01

@vgarciabnz thats the Error log

Caused by: org.postgresql.util.PSQLException: ERROR: null value in column “dataelementid” of relation “datasetelement” violates not-null constraint
Detail: Failing row contains (6485, null, null, null).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:134)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)

RaTED_S · 31 August 2022 09:01

Still getting the same error result

raju · 31 August 2022 09:16

could you please check if the dataelementid have any null value

RaTED_S · 31 August 2022 22:00

@raju @vgarciabnz

now getting a new log after solving dataelementid issue below is the new log from server

Aug 31 19:52:15 dataentry tomcat9[8088]: java.lang.NullPointerException

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.handleJsonbObjectProperties(DefaultFieldFilterService.java:835)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:584)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:572)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:343)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:585)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:572)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.buildNode(DefaultFieldFilterService.java:343)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.lambda$toCollectionNode$0(DefaultFieldFilterService.java:243)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at java.util.ArrayList.forEach(ArrayList.java:1259)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.fieldfilter.DefaultFieldFilterService.toCollectionNode(DefaultFieldFilterService.java:242)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.servlet.filter.AppOverrideFilter.doFilterInternal(AppOverrideFilter.java:176)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.webapi.filter.RequestIdentifierFilter.doFilterInternal(RequestIdentifierFilter.java:105)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

Aug 31 19:52:15 dataentry rsyslogd: action ‘action-8-builtin:omfile’ resumed (module ‘builtin:omfile’) [v8.2001.0 try https://www.rsyslog.com/e/2359 ]

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.webapi.filter.ExcludableShallowEtagHeaderFilter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:125)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.servlet.filter.HttpUrlPatternFilter.doFilter(HttpUrlPatternFilter.java:123)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry rsyslogd: action ‘action-8-builtin:omfile’ suspended (module ‘builtin:omfile’), retry 0. There should be messages before this one giving the reason for suspension. [v8.2001.0 try https://www.rsyslog.com/e/2007 ]

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:182)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:149)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.webapi.filter.CorsFilter.doFilter(CorsFilter.java:116)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.hisp.dhis.webapi.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:93)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry rsyslogd: action ‘action-8-builtin:omfile’ resumed (module ‘builtin:omfile’) [v8.2001.0 try https://www.rsyslog.com/e/2359 ]

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)

Aug 31 19:52:15 dataentry tomcat9[8088]: #011at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)