We are trying to customize DHIS2 for the Cancer Early Detection Clinic at the National Cancer Control programme-Sri Lanka. The primary objective is to record patient data and generate some essential reports.
We have customized the patient side (Program/Individual records) and successfully run 2 test aggregation queries by manual aggregation. Such data is saved.
But when we want to generate reports, following error appears and no records are shown on pivot tables.
2014-06-05 06:06:37Process failed: Exception during execution
I have attached the screen-print and the caltalina log file.
Version:
2.15
Build revision:
15112
Build date:
2014-06-02 02:04
User agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0
Your help will be appreciated.
ALTER TABLE *table_name* ENGINE=InnoDB;
did not work. I did it for Analytics tables.
Might have to recompile after changing the configurations..
Thanks anyway.
Neranga
<details class='elided'>
<summary title='Show trimmed content'>···</summary>
On 5 June 2014 13:15, Roshan Hewapathirana <roshanhewapathirana@gmail.com> wrote:
> I think this will help.
> [http://stackoverflow.com/questions/16896866/error-too-many-keys-specified-max-64-keys-allowed](http://stackoverflow.com/questions/16896866/error-too-many-keys-specified-max-64-keys-allowed)
> If you see the log carefully, you can see 64 indexes are created on by one from line 173 and throws run time exception when try creating 65th index.
>
> The above post says this 64 key issue is only in MyISAM.
>
> So, easiest would be to convert Anlalytics tables to InnoDB.
> [http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html](http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html)
> ```
>
>
> ALTER TABLE *table_name* ENGINE=InnoDB;
>
>
> Roshan
>
On 5 June 2014 09:21, Neranga <neranga.liyanaarachchi@gmail.com> wrote:
> Hi,
>
> We are trying to customize DHIS2 for the Cancer Early Detection Clinic at the National Cancer Control programme-Sri Lanka. The primary objective is to record **patient data** and generate some essential reports.
> We have customized the patient side (Program/Individual records) and successfully run 2 test aggregation queries by manual aggregation. Such data is saved.
>
>
> But when we want to generate reports, following error appears and no records are shown on pivot tables.
>
> 2014-06-05 06:06:37Process failed: Exception during execution 
> I have attached the screen-print and the caltalina log file.
> Version:
> 2.15
> Build revision:
> 15112
> Build date:
> 2014-06-02 02:04
> User agent:
> Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0
> Your help will be appreciated.
> Thanks in advance.
> ***L.A. Neranga Prabhath***
>
> *Trainee - MSc in Medical Informatics*
> *Postgraduate Institute of Medicine*
> *University of Colombo-Sri Lanka.*
>
> *Telephone: +94772531559*
> **
</details>
We are trying to customize DHIS2 for the Cancer Early Detection Clinic at the National Cancer Control programme-Sri Lanka. The primary objective is to record patient data and generate some essential reports.
We have customized the patient side (Program/Individual records) and successfully run 2 test aggregation queries by manual aggregation. Such data is saved.
But when we want to generate reports, following error appears and no records are shown on pivot tables.
2014-06-05 06:06:37Process failed: Exception during execution
I have attached the screen-print and the caltalina log file.
Version:
2.15
Build revision:
15112
Build date:
2014-06-02 02:04
User agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0
Your help will be appreciated.
