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