as `p31Cc1hzVET`,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.p rogramstageid=ps.programstageid left join program pr on pi.programid=pr.programi d left join patient pa on pi.patientid=pa.patientid left join organisationunit o u on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ou s on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructur e dps on psi.executiondate=dps.dateperiod where psi.executiondate >= '2014-01-01 ' and psi.executiondate <= '2014-12-31' and pr.programid=3 and psi.organisationu nitid is not null and psi.executiondate is not null]; nested exception is com.my sql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis6.analytics_even t_temp_2014_gqmonofixw4' doesn't exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d oTranslate(SQLErrorCodeSQLExceptionTranslator.java:237) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat or.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.populate TableAsync(JdbcEventAnalyticsTableManager.java:178) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti on(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo inpoint(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(Unknown Source) ... 1 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhi s6.analytics_event_temp_2014_gqmonofixw4' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) 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