Strange data value storing problem with a Dhis2 lite installation

Hi,

I have come across a strange problem with a DHIS 2 lite install.
It is on a new database that was created by modifying the hibernate.properties file.
I have attached the database, it is really small. db name is Armenia, user is sa, and no password, just like the default.

The system works as expected and no exceptions are thrown or in the log file (where everything is normal) , but data values cannot be stored in data entry.
Basically you can enter data, switch to another month/orgunit and then back again, and the data is not there.

Data statistics also shows 0 data values.

Changes or additions to metadata works as expected.

I have taken the whole folder and tried it on other machines (BTW runs nicely off the usb stick, apart from this specific problem).

I came across a H2 database browser for firefox once, but can’t remember what is was. What is the easiest way to browse the database,
and should such a tool be packaged with the installation perhaps?

How do you suggest I debug this problem?

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897

Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.

database.7z (27.7 KB)

Hi Ola

This sounds weird. I’ll have a look.

Anyway to browse the database you should download the h2 database engine from http://www.h2database.com/html/main.html

When you run h2.sh or h2.bat it should open you a web interface from where you can connect to your database using the jdbc:h2:… url

Regards
Bob

···

2009/9/3 Ola Hodne Titlestad olatitle@gmail.com

Hi,

I have come across a strange problem with a DHIS 2 lite install.
It is on a new database that was created by modifying the hibernate.properties file.

I have attached the database, it is really small. db name is Armenia, user is sa, and no password, just like the default.

The system works as expected and no exceptions are thrown or in the log file (where everything is normal) , but data values cannot be stored in data entry.
Basically you can enter data, switch to another month/orgunit and then back again, and the data is not there.

Data statistics also shows 0 data values.

Changes or additions to metadata works as expected.

I have taken the whole folder and tried it on other machines (BTW runs nicely off the usb stick, apart from this specific problem).

I came across a H2 database browser for firefox once, but can’t remember what is was. What is the easiest way to browse the database,
and should such a tool be packaged with the installation perhaps?

How do you suggest I debug this problem?

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897

Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.


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

Hi Ola

I have confirmed that its not related to your Armenia database. Data entry works as expected on 2.0.1. Some bug has crept into 2.0.2 - maybe related to transaction management upgrade. Will do a diff and check.

Meanwhile filing bug report …

Regards
Bob

···

2009/9/3 Ola Hodne Titlestad olatitle@gmail.com

Hi,

I have come across a strange problem with a DHIS 2 lite install.
It is on a new database that was created by modifying the hibernate.properties file.

I have attached the database, it is really small. db name is Armenia, user is sa, and no password, just like the default.

The system works as expected and no exceptions are thrown or in the log file (where everything is normal) , but data values cannot be stored in data entry.
Basically you can enter data, switch to another month/orgunit and then back again, and the data is not there.

Data statistics also shows 0 data values.

Changes or additions to metadata works as expected.

I have taken the whole folder and tried it on other machines (BTW runs nicely off the usb stick, apart from this specific problem).

I came across a H2 database browser for firefox once, but can’t remember what is was. What is the easiest way to browse the database,
and should such a tool be packaged with the installation perhaps?

How do you suggest I debug this problem?

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897

Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.


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