dhis2-users team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

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@xxxxxxxxx> 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
>  Data mart tables update
>
> also, under general settings, set no cache.
> also under Data Administration >> Maintenance check all these and press
> Perform maintenance,
> Maintenance
>
>  Clear analytics tables
>
>  Clear data mart
>
>  Rebuild data mart index
>
>  Clear zero values
>
>  Clear data set completeness
>
>  Prune periods
>
>  Update category option combinations
>
>
>