DHIS-live 2.12 problem

I installed DHIS-live yesterday. Contrary to my expectations from the documentation, the DB was empty, but since I intended to create a custom DB, that was no problem. I went ahead and created my org units, categories, category combos, data elements, dataset and dataset sections. I was able to create a dataset report. The only thing I was unable to do was save a new user.

Today, however, when I try to start DHIS, I get a 503 Service Unavailable. The log shows startup routines 1-3 starting but it appears that only 1 completes. There is a runtime error with the SQL statement "ALTER TABLE chart ADD CONSTRAINT char-uid-key UNIQUE(uid)" failing because "Constraint CHART_UID_KEY already exists".

Any suggestions?

Saludos, Roger

Hi Roger,

We might need to review the documents, as it seems they may be a bit misleading here. DHIS2-Live does not include the demo database, which needs to be downloaded and installed separately.

I am surprised that this particular error would cause a startup failure, as it does not seem to be fatal. Could you post the entire startup log, along with your platform, DHIS2 version, platform and database system you are using (Postgres, MySQL, H2)?

Best regardss,
Jason

···

On Thu, Jun 13, 2013 at 8:19 PM, Friedman, Roger (CDC/CGH/DGHA) (CTR) rdf4@cdc.gov wrote:

I installed DHIS-live yesterday. Contrary to my expectations from the documentation, the DB was empty, but since I intended to create a custom DB, that was no problem. I went ahead and created my org units, categories, category combos, data elements, dataset and dataset sections. I was able to create a dataset report. The only thing I was unable to do was save a new user.

Today, however, when I try to start DHIS, I get a 503 Service Unavailable. The log shows startup routines 1-3 starting but it appears that only 1 completes. There is a runtime error with the SQL statement “ALTER TABLE chart ADD CONSTRAINT char-uid-key UNIQUE(uid)” failing because “Constraint CHART_UID_KEY already exists”.

Any suggestions?

Saludos, Roger


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

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

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

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