dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #33480
Re: [Bug 1328273] Re: Executing analytics table fails: Process failed: Exception during execution
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" <1328273@xxxxxxxxxxxxxxxxxx> </div><div>Date:13/10/2014 15:39 (GMT+01:00) </div><div>To: simon.ndira@xxxxxxxxx </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 <busoye@xxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
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
Follow ups
References