← Back to team overview

dhis2-devs team mailing list archive

DHIS2 analytics table returns empty

 

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
* Postgresql
* Tomcat 7.0
* jdk 1.8.0_1xxx
* Firefox, Chrome