Upgrade dhis2 2.33.3 to 2.36.3

Support - Assistance technique
1

Hello Teams,
I need help for upgrading my server dhis2 2.33.3 to 2.36.3.
After upgrading I have the message error on the log.

thanks,

    ... 28 more

Aug 06, 2021 7:16:12 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener]
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘webMvcConfig’: Unsatisfied dependency expressed through field ‘userSettingService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingService’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/DefaultUserSettingService.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1415)

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingService’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/DefaultUserSettingService.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:229)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1356)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1206)
    ... 28 more

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:229)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1356)
    ... 41 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1788)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:609)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1914)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1856)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1784)
    ... 68 more

Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:28)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:67)
    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:434)
    ... 90 more

Caused by: org.postgresql.util.PSQLException: ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
… 98 more

Aug 06, 2021 7:16:12 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [org.hisp.dhis.system.startup.StartupListener]
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘webMvcConfig’: Unsatisfied dependency expressed through field ‘userSettingService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingService’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/DefaultUserSettingService.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingService’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/DefaultUserSettingService.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:229)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1356)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1206)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:571)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531)

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.user.UserSettingStore’ defined in URL [jar:file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-service-core-2.36.3.jar!/org/hisp/dhis/user/hibernate/HibernateUserSettingStore.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:229)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1356)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1206)
    ... 41 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in class path resource [org/hisp/dhis/db/migration/config/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1788)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:609)
    ... 55 more

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1914)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1856)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1784)
… 68 more
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql failed

SQL State : 0A000
Error Code : 0
Message : ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
Location : org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql (/home/dh/file:/var/lib/dhis2/dhis/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.36.3.jar!/org/hisp/dhis/db/migration/2.35/V2_35_21__Modify_id_in_trackedentityattributevalueaudit_to_bigint.sql)
Line : 1
Statement : – trackedentityattributevalueaudit primary kee to bigint
alter table trackedentityattributevalueaudit alter column trackedentityattributevalueauditid type bigint

    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:273)
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:218)
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:82)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.access$000(SqlMigrationExecutor.java:32)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:70)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:67)
    at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:28)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:67)
    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:434)
    ... 90 more

Caused by: org.postgresql.util.PSQLException: ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:241)
at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:206)
… 98 more

2

Hello @Sokhna

Caused by: org.postgresql.util.PSQLException: ERROR: cannot alter type of a column used by a view or rule
Detail: rule RETURN on view trackedentityattributevalueaudit depends on column “trackedentityattributevalueauditid”

it seems that the problem comes from the SQL views. You have to delete them before upgrade.

You can read this topic for more information Upgrading from 2.30 to 2.31dev(CI server)

Regards;

4

Hello @didate
I did the DROP SQL VIEWS before the UPGRADE. with Data Administration → Maintenance, then select “Drop SQL Views”

My solution:

1- Install pgAdmin4 on the server to access the dhis2 2.33.3 database
2-Go to Schemas then to Views and do a ‘DROP CASCADE’ to all the views I had created
3- Deploy the war 2.36.3 on the dhis instance DHIS2

2 Likes
5

Hello @Sokhna , Thank you for the feedback.

You could use psql command line without installing pgadmin.

Happy for you.

2 Likes