dhis2-users team mailing list archive

[Manaf Abthul <drmanaf79@xxxxxxxxx>]

Hi,

I am on dhis2 customization on tracker for Chest clinic.I did all patient
data element and Aggregation data elements. I checked Manual aggregation
under individual records. The preview is working. And then I click Aggre
and Save button.

Then if I try to get the report, unable to generate report saying "Process
failed: Exception during execution  "

Is it bug? I am using DHIS2 Version:2.14 Build revision:13836; MySQL;
Window7; Tomcat

Please help me to solve this problem

Manaf

 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

Attachment: report.jpg
Description: JPEG image