dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Cleared the cache but same error results as the previous post.
On Oct 13, 2014 11:29 AM, "Jason Pickering" <jason.p.pickering@xxxxxxxxx>
wrote:

> I did not try, but will now. Here is the error report.
>
> nalytics table process failed, please check the logs. Message: Exception
> during execution Cause: java.util.concurrent.ExecutionException:
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
> grammar [insert into analytics_event_temp_2012_XPwePtbNCSB
> ("U3eQda5XlA2","mYvlji093BS","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","yearly","financialapril","financialjuly","financialoct","lrbkrnNd1Gz","XJgv2HwHfSX","hAQiDxyXEUz","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","psi","ps","executiondate","longitude","latitude","ou","ouname","oucode","tei")
> select
> ougs."U3eQda5XlA2",ougs."mYvlji093BS",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",dps."daily",dps."weekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",(select
> value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69892)
> as "lrbkrnNd1Gz",(select value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69894)
> as "XJgv2HwHfSX",(select value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69887)
> as "hAQiDxyXEUz",(select value from trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as
> "kcMTeJgLr51",psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,
> ou.name,ou.code,tei.uid from programstageinstance psi left join
> _organisationunitgroupsetstructure ougs on
> psi.organisationunitid=ougs.organisationunitid 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 trackedentityinstance tei on
> pi.trackedentityinstanceid=tei.trackedentityinstanceid 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 >= '2012-01-01' and psi.executiondate <=
> '2012-12-31' and pr.programid=69888 and psi.organisationunitid is not null
> and psi.executiondate is not null]; nested exception is
> org.postgresql.util.PSQLException: ERROR: relation
> "analytics_event_temp_2012_xpweptbncsb" does not exist
> Position: 13
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:188)
> at
> org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
> at
> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:212)
> at
> org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:121)
> at
> org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:151)
> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
> at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
> at
> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: org.springframework.jdbc.BadSqlGrammarException:
> StatementCallback; bad SQL grammar [insert into
> analytics_event_temp_2012_XPwePtbNCSB
> ("U3eQda5XlA2","mYvlji093BS","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","yearly","financialapril","financialjuly","financialoct","lrbkrnNd1Gz","XJgv2HwHfSX","hAQiDxyXEUz","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kdstuCyxFmJ","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","kcMTeJgLr51","psi","ps","executiondate","longitude","latitude","ou","ouname","oucode","tei")
> select
> ougs."U3eQda5XlA2",ougs."mYvlji093BS",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",dps."daily",dps."weekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",(select
> value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69892)
> as "lrbkrnNd1Gz",(select value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69894)
> as "XJgv2HwHfSX",(select value from trackedentitydatavalue where
> programstageinstanceid=psi.programstageinstanceid and dataelementid=69887)
> as "hAQiDxyXEUz",(select value from trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5292) as "kdstuCyxFmJ",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as "kcMTeJgLr51",(select value from
> trackedentityattributevalue where
> trackedentityinstanceid=pi.trackedentityinstanceid and
> trackedentityattributeid=5293) as
> "kcMTeJgLr51",psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,
> ou.name,ou.code,tei.uid from programstageinstance psi left join
> _organisationunitgroupsetstructure ougs on
> psi.organisationunitid=ougs.organisationunitid 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 trackedentityinstance tei on
> pi.trackedentityinstanceid=tei.trackedentityinstanceid 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 >= '2012-01-01' and psi.executiondate <=
> '2012-12-31' and pr.programid=69888 and psi.organisationunitid is not null
> and psi.executiondate is not null]; nested exception is
> org.postgresql.util.PSQLException: ERROR: relation
> "analytics_event_temp_2012_xpweptbncsb" 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:188)
> at sun.reflect.GeneratedMethodAccessor938.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.run(FutureTask.java:262)
> ... 1 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "analytics_event_temp_2012_xpweptbncsb" 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)
> ... 11 more
>
> On Mon, Oct 13, 2014 at 5:27 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
> wrote:
>
>> Sure.. From the logs in the bug report it says "patientidentifier where
>> patientid=pi.patientid and patientidentifiertypeid=7" indicating that the
>> server is still on 2.14.
>>
>> Would be good with a separate report for your issue. Did you try clearing
>> cache from data admin> caching?
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>