Attached the catalina log. Till now - I have a 2.20 db running perfectly. * I then used the Data Administration/Maintenance option and selected "Drop SQL Views". * After the maintenance was performed, I verified in PgAdmin that no views exist in the db. * I now replaced the 2.20 WAR with a 2.21 WAR * I started Tomcat using the startup.sh script.
Attached is the catalina.out log file created by the process (I deleted the log before I started the 2.21 process). (Note - 2.21 using a blank db works fine...) Please advise. *Ferdie Botha* [image: cid:[email protected]] *Health Information Systems Program* ----------------------------------------------- *e-mail: *[email protected] *Mobile: *082 453 5744 *Skype:* ferdie.botha.skype *Web: * http://www.hisp.org On Fri, Nov 13, 2015 at 11:55 AM, Lars Helge Øverland <[email protected]> wrote: > Hi Ferdie, > > okay. Are you getting the same error this time or another one? Do you > think you could post the output to the Tomcat log from when you started > last time? > > Lars > > On Fri, Nov 13, 2015 at 9:25 AM, Ferdie Botha <[email protected]> wrote: > >> 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:[email protected]] >> >> *Health Information Systems Program* >> >> ----------------------------------------------- >> >> *e-mail: *[email protected] >> *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 <[email protected]> >> 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 <[email protected]> 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:[email protected]] >>>> >>>> *Health Information Systems Program* >>>> >>>> ----------------------------------------------- >>>> >>>> *e-mail: *[email protected] >>>> *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 [email protected] >>>> <[email protected]> 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 : [email protected] >>>> 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 [email protected] >> <[email protected]> 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.* >> > > > > -- > 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 [email protected] <[email protected]> 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.*
catalina.out.221-err
Description: Binary data
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
