UPGRADING DHIS2.30 TO DHIS2.31

[tuzo engelbert]

Hello Admins
When am upgrading one of my test instance which is currently running on DHIS2.30 to DHIS2.31 keeps getting error like the logs below

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in URL [jar:file:/usr/local/tomcat-29/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.31-SNAPSHOT.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: 

Migration V2_31_1__Migrations_for_release_v31.sql failed

--------------------------------------------------------

SQL State  : 42501

Error Code : 0

Message    : ERROR: must be owner of function generate_uid

Location   : org/hisp/dhis/db/migration/2.31/V2_31_1__Migrations_for_release_v31.sql (/usr/local/tomcat-29/file:/usr/local/tomcat-29/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.31-SNAPSHOT.jar!/org/hisp/dhis/db/migration/2.31/V2_31_1__Migrations_for_release_v31.sql)

Line       : 1

Statement  : --Function for creating uids.


Is there a way of getting this fixed ??

Thanks in advance

[Bob Jolliffe]

Hi Tuzo

Good to hear from you. I just asked Ameen who is the guru of the new
flyway functionality. He reckons that it looks like you have an
existing function called generate_uid which is not owned by your dhis2
database user. If you just drop that function and restart the
application it should recreate it afresh and with the proper
ownership.

Please try this and let us know.

Regards
Bob

> --
> You received this message because you are subscribed to the Google Groups "DHIS2 system administrators" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to dhis2-system-admini...@googlegroups.com.
> To post to this group, send email to dhis2-system-...@googlegroups.com.
> To view this discussion on the web, visit https://groups.google.com/d/msgid/dhis2-system-administrators/77c8a68a-48d4-4820-b267-466423cedb8f%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[tuzo engelbert]

Thanks, will do.