Analytics and data mart tables management ERROR

Hi,

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.

error Analy (236 KB)

image

···

**
OS - Ubuntu 12.04 LTS
DHIS2 version -2.14
build version- 13846

MySQL, Tomcat

**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

Manaf,
I could identify some error in your log file . It is sql error as follow

MySQLSyntaxErrorException: Table ‘test2.analytics_event_temp_2014_gQMONofIxW4’ doesn’t exis

Yes ,this may looks unusual table, usually in my table structure contain analytics_2011, analytics_2012 like tables.

analytics_event_temp_2014_gQMONofIxW4 like table is not seen in my tables.

Do you have such a table in your database?

···

On Tue, Apr 8, 2014 at 2:56 PM, Manaf Abthul drmanaf79@gmail.com wrote:

Hi,

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 - Ubuntu 12.04 LTS
DHIS2 version -2.14
build version- 13846

MySQL, Tomcat

**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