dhis2-devs team mailing list archive

[Simon Ndira <simon.ndira@xxxxxxxxx>]

Public bug reported:

In version 2.14, I am running tracker. When I try executing analytics table, I get the following error:
'Process failed. Exeception during execution'.


Here is an extraction from the last lines in catalina.out that could help in error identification:

patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",(select identifier from patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",(select identifier from patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= '2011-01-01' and psi.executiondate <= '2011-12-31' and pr.programid=68 and psi.organisationunitid is not null and psi.executiondate is not null]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_event_temp_2011_q3p6c4bgq7o" does not exist
  Position: 13
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
	at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTableAsync(JdbcEventAnalyticsTableManager.java:178)
	at sun.reflect.GeneratedMethodAccessor1602.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	... 1 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_event_temp_2011_q3p6c4bgq7o" does not exist
  Position: 13
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 12 more

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1328273

Title:
  Executing analytics table fails: Process failed: Exception during
  execution

Status in DHIS 2:
  New

Bug description:
  In version 2.14, I am running tracker. When I try executing analytics table, I get the following error:
  'Process failed. Exeception during execution'.

  
  Here is an extraction from the last lines in catalina.out that could help in error identification:

  patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",(select identifier from patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",(select identifier from patientidentifier where patientid=pi.patientid and patientidentifiertypeid=71) as "iEoIwcIBRFB",psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= '2011-01-01' and psi.executiondate <= '2011-12-31' and pr.programid=68 and psi.organisationunitid is not null and psi.executiondate is not null]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_event_temp_2011_q3p6c4bgq7o" does not exist
    Position: 13
  	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
  	at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTableAsync(JdbcEventAnalyticsTableManager.java:178)
  	at sun.reflect.GeneratedMethodAccessor1602.invoke(Unknown Source)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  	at java.lang.reflect.Method.invoke(Method.java:606)
  	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
  	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  	... 1 more
  Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_event_temp_2011_q3p6c4bgq7o" does not exist
    Position: 13
  	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
  	at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
  	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  	... 12 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1328273/+subscriptions