dhis2-users team mailing list archive

[Tony Iha <tonyiha@xxxxxxxxx>]

Could anyone point me to some notes on how to do a smooth upgrade from 2.14
to 2.15

*My steps.*
1. I downloaded the latest stable version of 2.15
Version:2.15Build revision:15074Build date:2014-05-25 20:19
2. Took a sql dump of 2.14 from postgres
3. I stopped and undeployed 2.14 from TomCat Web Application Manager
4. On a test server created my new dhis database from my 2.14 dump (process
completed successful)
5. Run the upgrade script *rename-patient-to-trackedentity.sql *got the
following errors (dhis217.txt).
6. Restarted tomcat and postgtes and can run dhis2 properly with user admin

Issues:
-My OU structure has disappeared from the front end
-Users are not visible only default user is available.

>From the backend i can still view the users table with all users from 2.14

Kindly help

-- 
Tony Iha Kazungu
ICT Practitioner
Emails: tonyiha@xxxxxxxxx, me@xxxxxxxxxxx
Linkedin : ke.linkedin.com/in/tonyiha/
Skpe: tkazungu

C:\Program Files\PostgreSQL\9.2\bin>
C:\Program Files\PostgreSQL\9.2\bin>psql -d dhis -U dhis -f C:\Users\TKazungu\Downloads\rename-patient-to-trackeden
tity.sql
Password for user dhis:
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:4: ERROR:  syntax error at or near ""
LINE 1: 
        ^
DROP TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:6: ERROR:  table "patientaggregatereportmember
s" does not exist
DROP TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:8: ERROR:  cannot drop table patientaggregater
eport because other objects depend on it
DETAIL:  constraint fk_patientaggregatereportid_dimensions on table patientaggregatereport_dimension depends on tab
le patientaggregatereport
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:10: ERROR:  column "patienttabularreportid" of
 relation "programstage_dataelements" does not exist
DROP TABLE
DROP TABLE
DROP TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:14: ERROR:  table "patienttabularreportmembers
" does not exist
DROP TABLE
DROP TABLE
DROP TABLE
ALTER TABLE
DROP TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:41: ERROR:  constraint "patientattribute_code_
key" for table "trackedentityattribute" does not exist
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:42: ERROR:  constraint "patientattribute_name_
key" for table "trackedentityattribute" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:49: ERROR:  constraint "patientattributegroup_
code_key" for table "trackedentityattributegroup" does not exist
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:50: ERROR:  constraint "patientattributegroup_
name_key" for table "trackedentityattributegroup" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:68: ERROR:  table "patientregistrationform_att
ributes" does not exist
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:69: ERROR:  table "patientregistrationform_fix
edattributes" does not exist
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:70: ERROR:  table "patientregistrationform_ide
ntifiertypes" does not exist
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:71: ERROR:  table "patientregistrationform_att
ributes" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:C:/Users/TKazungu/Downloads/rename-patient-to-trackedentity.sql:133: ERROR:  table "patientmobilesetting" does
 not exist

C:\Program Files\PostgreSQL\9.2\bin>