Hi Jason, Migration to 2.16 allows for execution of analytics. However pruning periods and running auto aggregate query builder are still challenging. I suggest you migrate to 2.16 first in test then in production. You should be fine. Hope this helps. Simon.
Sent from Samsung Mobile <div>-------- Original message --------</div><div>From: "jason.p.pickering" <1328...@bugs.launchpad.net> </div><div>Date:13/10/2014 15:39 (GMT+01:00) </div><div>To: simon.nd...@ehmis.org </div><div>Cc: </div><div>Subject: Re: [Dhis2-devs] [Bug 1328273] Re: Executing analytics table fails: Process failed: Exception during execution </div><div> </div>I am having the same issue on a newly upgraded 2.16 instance. On Mon, Oct 13, 2014 at 11:51 AM, Adebusoye Anifalaje <bus...@hisp.org> wrote: > Hi Simon, > > Did you get a solution to this problem? > > If yes, could you please share? > > Regards, > Busoye > > -- > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 -- You received this bug notification because you are subscribed to the bug report. 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 -- 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 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
