dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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 <ferdie@xxxxxxxx> 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:  *ferdie@xxxxxxxx
> *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 disclaimer@xxxxxxxx
> <disclaimer@xxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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>