dhis2-users team mailing list archive

[Neranga <neranga.liyanaarachchi@xxxxxxxxx>]

​Hi,

Thanks for the reply.
Unfortunately,

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


On 5 June 2014 13:15, Roshan Hewapathirana <roshanhewapathirana@xxxxxxxxx>
wrote:

> I think this will help.
>
> 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
>
> ​​
> ​​
> ALTER TABLE *table_name* ENGINE=InnoDB;
>
>
>
> Roshan
>
>
>
> On 5 June 2014 09:21, Neranga <neranga.liyanaarachchi@xxxxxxxxx> 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.15Build revision:15112Build date:2014-06-02 02:04User 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 <%2B94772531559>*
>>
>>
>
>