DHIS2 analytics table returns empty

j2yemi · 14 October 2015 12:34

Dear Team,
Upgrading to dhis2.20 is returning empty rows in the analytics_20xx.

The logs shows

WARN 2015-10-10 11:40:15,779 Duplicate object: [Data element: 584 option combo: 486 period: 795 org unit: 51 org unit group: 0 value: 55.0] (AbstractBatchHandler.java [SimpleAsyncTaskExecutor-72])
WARN 2015-10-10 11:40:15,779 Duplicate object: [Data element: 584 option combo: 488 period: 795 org unit: 51 org unit group: 0 value: 12.0] (AbstractBatchHandler.java [SimpleAsyncTaskExecutor-72])
WARN 2015-10-10 11:40:15,779 Duplicate object: [Data element: 574 option combo: 485 period: 795 org unit: 51 org unit group: 0 value: 24.0] (AbstractBatchHandler.java [SimpleAsyncTaskExecutor-72])
WARN 2015-10-10 11:40:15,779 Duplicate object: [Data element: 573 option combo: 487 period: 795 org unit: 51 org unit group: 0 value: 77.0] (AbstractBatchHandler.java [SimpleAsyncTaskExecutor-72])
WARN 2015-10-10 11:40:15,779 Duplicate object: [Data element: 574 option combo: 486 period: 795 org unit: 51 org unit group: 0 value: 28.0] (AbstractBatchHandler.java [SimpleAsyncTaskExecutor-72])

I set all the dataelement to default then i have the WARN in the log

WARN 2015-10-13 14:45:25,591 Ignoring category combo, not valid: [IdentifiableObject: id=‘14’, uid=‘JKlMSbFzlum’, code=‘null’, name=‘default’, created=‘Mon Mar 17 11:25:58 WAT 2014’, lastUpdated=‘Tue Oct 13 14:34:48 WAT 2015’, class=‘class org.hisp.dhis.dataelement.DataElementCategoryCombo"’] (DefaultResourceTableService.java [taskScheduler-2])

I installed a fresh 2.20 version and created a sample data and the analytics_2015 successfully generated.

I found out that the fresh 2.20 version has _categorystructure with 4 columns and the old one has 2 columns.

As at this moment the old version is not generating the analytics_20xx even though it is successful the tables are empty.

Any idea pls…

Tools