Data Mart-Process failed:Exception during execution

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

catalina.txt (94.2 KB)

image

···

**

​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

​

<details class='elided'>
<summary title='Show trimmed content'>&#183;&#183;&#183;</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  ![](http://localhost:8080/dhis/images/error_small.png)

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

Hi,

This issue was resolved when I moved to a newer version of MySQL 5.6.19. where the database engine is InnoDB instead of MyIASM.

Now the datamart works as intended. Pivot tables can be generated.

Neranga

···

On Jun 5, 2014 12:51 PM, “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
**