[Bug 1518380] [NEW] upgrade to 2.21 database error and how we solved it

Public bug reported:

When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.

relevant part of the error message was:
* ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
  at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
  at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
  at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
       .....

Hope this is any usefull

** Affects: dhis2
     Importance: Undecided
         Status: New

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1518380

Title:
  upgrade to 2.21 database error and how we solved it

Status in DHIS:
  New

Bug description:
  When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
   We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.

  relevant part of the error message was:
  * ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
    at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
    at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
    at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
         .....

  Hope this is any usefull

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1518380/+subscriptions

Better is the following, fixed it in our case

UPDATE dataelement set aggregationtype = 'AVERAGE' where aggregationtype
= 'AVG';

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1518380

Title:
  upgrade to 2.21 database error and how we solved it

Status in DHIS:
  New

Bug description:
  When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
   We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.

  relevant part of the error message was:
  * ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
    at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
    at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
    at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
         .....

  Hope this is any usefull

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1518380/+subscriptions

We have the same issue however this is the error that we get:

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 org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
        at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)

Any ideas how we can fix this?

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1518380

Title:
  upgrade to 2.21 database error and how we solved it

Status in DHIS:
  New

Bug description:
  When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
   We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.

  relevant part of the error message was:
  * ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
    at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
    at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
    at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
         .....

  Hope this is any usefull

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1518380/+subscriptions

https://www.dhis2.org/221-upgrade your Value Types must match exactly,
case included what is in the Web API / data model changes

Also, please use Jira for issues going forward.

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1518380

Title:
  upgrade to 2.21 database error and how we solved it

Status in DHIS:
  New

Bug description:
  When changing the dhis.war file from 2.20 to 2.21 we received a database error message related to AVG aggregation type. We could not even go into dhis2 anymore.
   We solved it by going back to 2.20 restoring the database and doing an update sql statement on table dataelement and setting aggregationtype to 'SUM' after that we did the upgrade again to 2.21 and now it went fine.

  relevant part of the error message was:
  * ERROR 2015-11-20 16:42:02,919 java.lang.IllegalArgumentException: Unknown name value [AVG] for enum class [org.hisp.dhis.analytics.AggregationType]
    at org.hibernate.type.EnumType$NamedEnumValueMapper.fromName(EnumType.java:467)
    at org.hibernate.type.EnumType$NamedEnumValueMapper.getValue(EnumType.java:452)
    at org.hibernate.type.EnumType.nullSafeGet(EnumType.java:107)
         .....

  Hope this is any usefull

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1518380/+subscriptions