Data Mart problem in dhis2 version 2.11

Dear All,

We are using dhis2 version 2.11 and PosgreSql 9.2. When i am populating reports-> Analytics and Data Mart .It generate temporary table for all year from 1979 to 2014.

However, when it is coming in Populating Crostabulation table functionalists that time the application hangs and shows error in log file.

The error file and the screen short i attached here. and some portion of it is as follows.

  • INFO 2013-07-01 00:09:28,676 [Level: INFO, category: DATAMART, time: Mon Jul
    01 00:09:28 BDT 2013, message: Populating crosstabulation table] (InMemoryNotifi
    er.java [taskScheduler-1])
    Exception in thread "org.springframework.scheduling.quartz.SchedulerFactoryBean#

1_QuartzSchedulerThread" Exception in thread “http-apr-8085-exec-8” Exception in
thread “ContainerBackgroundProcessor[StandardEngine[Catalina]]” java.lang.OutOf
MemoryError: Java heap space

java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Unknown Source)

Analytics and Data Mart Bug.txt (10.7 KB)

Analytics and Data Mart _Prob Screen Short.docx (508 KB)

···

Thanks to all of you.

Fatema Uddin ----------------------------------------

Technical Advisor HIS

Priority Area Health

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone: +880 2 966 53 13

Fax: +880 2 966 53 14

Hi Fatema,
This is not a problem with DHIS2 per se, but rather with the setup of your server. You will need to increase the memory available to Java. There is a quite detailed section in the implementers manual on this here.

This issue has been discussed numerous times on this list as well, so if you search the achives, you may find some tips there as well.

Best regards,

Jason

···

On Mon, Jul 1, 2013 at 2:08 AM, Uddin Fatema fatemacse@gmail.com wrote:

Dear All,

We are using dhis2 version 2.11 and PosgreSql 9.2. When i am populating reports-> Analytics and Data Mart .It generate temporary table for all year from 1979 to 2014.

However, when it is coming in Populating Crostabulation table functionalists that time the application hangs and shows error in log file.

The error file and the screen short i attached here. and some portion of it is as follows.

  • INFO 2013-07-01 00:09:28,676 [Level: INFO, category: DATAMART, time: Mon Jul
    01 00:09:28 BDT 2013, message: Populating crosstabulation table] (InMemoryNotifi
    er.java [taskScheduler-1])
    Exception in thread "org.springframework.scheduling.quartz.SchedulerFactoryBean#

1_QuartzSchedulerThread" Exception in thread “http-apr-8085-exec-8” Exception in
thread “ContainerBackgroundProcessor[StandardEngine[Catalina]]” java.lang.OutOf
MemoryError: Java heap space

java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Unknown Source)

Thanks to all of you.

Fatema Uddin ----------------------------------------

Technical Advisor HIS

Priority Area Health

Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH

House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

Office location:

Monitoring & Evaluation Unit

Ministry of Health and Family Welfare

Janashankha Bhaban (2nd Floor), Azimpur

Dhaka 1205, Bangladesh

Phone: +880 2 966 53 13

Fax: +880 2 966 53 14


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp