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 <[email protected]> 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 <[email protected]> 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>* >> >> > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
