Analytics and data mart tables management ERROR

Hi,

Still continuing this analytic and data mart problem. Still I could not solve. Please look it…

I am doing customization of DHIS2 for chest clinic on Tracker. Personal data and manual aggregation are running well. But Report getting exceptional **- Process failed: Exception during execution.
**OS - Windows 7
DHIS2 version -2.14
build version- 13859

MySQL, Tomcat

Database Name : ccd

Catalina…

** 4-01-01’ and pe.startdate <= ‘2014-12-31’ and dv.value is not null and dv.value regexp ‘^(-?[0-9]+)(.[0-9]+)?(E\d+)?$’ and ( dv.value != ‘0’ or de.aggregationtype = ‘average’ or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ccd.analytics_temp_2014
’ doesn’t exist at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)**

What is the table called 'ccd.analytics_temp_2014’

I have gone through all steps as below,

update resource tables
data administration >> resource tables

then generate report tables.

CHECKed data mart table update

Data Mart

also, under general settings, set no cache.

also under Data Administration >> Maintenance check all these and press Perform maintenance,

Maintenance

error.txt (24.5 KB)

image

···