Hi Lars, all views were dropped prior to the upgrade using the maintenance functionality. PgAdmin also indicated "Views (0)" in the database. Should I delete the SQL views altogether instead of just "Drop SQL views" from the Maintenance User-Screen?
Any other potential reasons I can investigate? *Ferdie Botha* [image: cid:image003.png@01CC94C1.A071E700] *Health Information Systems Program* ----------------------------------------------- *e-mail: *fer...@hisp.org *Mobile: *082 453 5744 *Skype:* ferdie.botha.skype *Web: * http://www.hisp.org On Fri, Nov 6, 2015 at 1:30 PM, Lars Helge Øverland <larshe...@gmail.com> wrote: > Hi Ferdie, > > I guess the problem is that you have some SQL views which refer to the > dataelement table. We are changing the length of the dataelement.valuetype > column in 2.21. For that to work you need to drop all SQL views prior to > the first time you start on 2.21. This information can be found in the > upgrade notes: > > https://www.dhis2.org/221-upgrade > > Lars > > Notes > > - If you have SQL views associated with the "dataelement" and > "trackedentityattribute" tables, it is recommended to remove those views > before starting 2.21 for the first time. This to allow the upgrade routines > to change column types. You can drop all SQL views from data administration > > maintenance > Drop SQL views. You can later recreate with Create SQL > views. > > > > On Fri, Nov 6, 2015 at 11:22 AM, Ferdie Botha <fer...@hisp.org> wrote: > >> Hi, >> >> I have a VM running Ubuntu 15.10, Java OpenJDK (Latest version), Tomcat >> 8, PostgreSQL 9.4. >> >> The DHIS instance is running version 2.20. >> >> Via PGAdmin the number of Views on the db is confirmed to be 0. >> >> When upgrading to version 2.21 (by replacing the 2.20 WAR file with the >> 2.21 version), I experienced the following: >> >> I replaced the WAR file and started Tomcat - and a blank screen instead >> of the login screen resulted. >> >> I then also restarted the VM with the same end-result. (If I revert back >> to the 2.20 WAR file, everything works fine). >> >> I then created a blank test-db and started the tomcat instance - the >> standard login screen is displayed as per normal, indicating to me that the >> challenge lies with the actual db upgrade process. >> >> Comparing the Catalina log file from the problematic process to the >> test-db log, the following point of failure was picked up: >> >> TEST db catalina.out shows the adding of a default category: >> >> * INFO 2015-11-06 11:36:59,993 Executing startup routine [3 of 13, >> runlevel 3]: DataElementDefaultDimensionPopulator >> (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) >> ** INFO 2015-11-06 11:37:01,406 Added default category >> (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])* >> * INFO 2015-11-06 11:37:01,505 Executing startup routine [4 of 13, >> runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java >> [localhost-startStop-1]) >> >> The actual db catalina.out shows the following: >> >> * INFO 2015-11-06 12:10:07,281 Executing startup routine [3 of 13, >> runlevel 3]: DataElementDefaultDimensionPopulator >> (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) >> * ERROR 2015-11-06 12:10:08,106 java.lang.IllegalArgumentException: >> Unknown name value [unitInterval] for enum class >> [org.hisp.dhis.common.ValueType] >> at >> org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467) >> at <a long list follows> ........... >> ...... >> Nov 06, 2015 12:10:08 PM org.apache.catalina.core.StandardContext >> startInternal >> SEVERE: One or more listeners failed to start. Full details will be found >> in the appropriate container log file >> Nov 06, 2015 12:10:08 PM org.apache.catalina.core.StandardContext >> startInternal >> SEVERE: Context [/dhis2-1] startup failed due to previous errors >> .... >> >> >> It thus seems that the "*Added default category >> (DataElementDefaultDimensionPopulator.java"* step is failing when >> upgrading this specific 2.20 database . >> >> Any proposals/advise on how to solve this matter? >> >> Much appreciated! >> >> Kind regards >> >> -- >> >> *Ferdie Botha* >> >> >> >> [image: cid:image003.png@01CC94C1.A071E700] >> >> *Health Information Systems Program* >> >> ----------------------------------------------- >> >> *e-mail: *fer...@hisp.org >> *Mobile: *082 453 5744 >> >> *Skype:* ferdie.botha.skype >> >> *Web: * http://www.hisp.org >> >> *This message and any attachments are subject to a disclaimer published >> at http://www.hisp.org/policies.html#comms_disclaimer >> <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the >> disclaimer before opening any attachment or taking any other action in >> terms of this electronic transmission. If you cannot access the >> disclaimer, kindly send an email to disclai...@hisp.org >> <disclai...@hisp.org> and a copy will be provided to you. By replying to >> this e-mail or opening any attachment you agree to be bound by the >> provisions of the disclaimer.* >> >> _______________________________________________ >> 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 >> >> > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > http://www.dhis2.org <https://www.dhis2.org> > > -- *This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclai...@hisp.org <disclai...@hisp.org> and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.*
_______________________________________________ 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
