org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryDao' defined in class path resource [com/otr/sufd/core/dao/dict/daoInstances.xml]: Cannot resolve reference to bean 'dictionaryHibernateSessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseMigrate' defined in class path resource [com/otr/sufd/server/startup/hibernateInitContext.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration ufos.8.21.0.122.056.1__func.sql failed
------------------------------------------------
SQL State  : 42804
Error Code : 0
Message    : ERROR: column "issentuserfromlist" cannot be cast automatically to type boolean
  Hint: You might need to specify "USING issentuserfromlist::boolean".
  Where: SQL statement "ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN"
PL/pgSQL function inline_code_block line 8 at EXECUTE
Location   : /oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql (/oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql)
Line       : 2
Statement  : do $$
declare
  v_c numeric(3);
begin
 select 1 into strict v_c from pg_tables where upper(tablename)=upper('DC_UFOCC_MAILRULE');
  begin
   select 1 into strict v_c from information_schema.columns where upper(table_name)=upper('DC_UFOCC_MAILRULE') and upper(column_name)=upper('ISSENTUSERFROMLIST');
    execute 'ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN';
 	exception when no_data_found then null;
 end;
 exception when no_data_found then null;
end$$

	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:329)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
	at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
	at com.otr.sufd.server.startup.CustomCodeContextLoaderListener.access$101(CustomCodeContextLoaderListener.java:46)
	at com.otr.sufd.server.startup.CustomCodeContextLoaderListener$2.run(CustomCodeContextLoaderListener.java:137)
	at java.lang.Thread.run(Thread.java:745)
	at com.otr.sufd.server.startup.CustomCodeContextLoaderListener.contextInitialized(CustomCodeContextLoaderListener.java:158)
	at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
	at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
	at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1868)
	at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3154)
	at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
	at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
	at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
	at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
	at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
	at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
	at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:671)
	at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
	at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
	at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
	at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
	at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
	at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
	at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
	at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
	at weblogic.deploy.internal.targetserver.operations.StartOperation.doCommit(StartOperation.java:149)
	at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
	at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
	at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
	at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
	at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:195)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:13)
	at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:68)
	at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseMigrate' defined in class path resource [com/otr/sufd/server/startup/hibernateInitContext.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration ufos.8.21.0.122.056.1__func.sql failed
------------------------------------------------
SQL State  : 42804
Error Code : 0
Message    : ERROR: column "issentuserfromlist" cannot be cast automatically to type boolean
  Hint: You might need to specify "USING issentuserfromlist::boolean".
  Where: SQL statement "ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN"
PL/pgSQL function inline_code_block line 8 at EXECUTE
Location   : /oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql (/oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql)
Line       : 2
Statement  : do $$
declare
  v_c numeric(3);
begin
 select 1 into strict v_c from pg_tables where upper(tablename)=upper('DC_UFOCC_MAILRULE');
  begin
   select 1 into strict v_c from information_schema.columns where upper(table_name)=upper('DC_UFOCC_MAILRULE') and upper(column_name)=upper('ISSENTUSERFROMLIST');
    execute 'ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN';
 	exception when no_data_found then null;
 end;
 exception when no_data_found then null;
end$$

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
	... 57 more
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration ufos.8.21.0.122.056.1__func.sql failed
------------------------------------------------
SQL State  : 42804
Error Code : 0
Message    : ERROR: column "issentuserfromlist" cannot be cast automatically to type boolean
  Hint: You might need to specify "USING issentuserfromlist::boolean".
  Where: SQL statement "ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN"
PL/pgSQL function inline_code_block line 8 at EXECUTE
Location   : /oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql (/oracle/sufd-server/sql-migrations/ufos.8.21.0.122.056.1__func.sql)
Line       : 2
Statement  : do $$
declare
  v_c numeric(3);
begin
 select 1 into strict v_c from pg_tables where upper(tablename)=upper('DC_UFOCC_MAILRULE');
  begin
   select 1 into strict v_c from information_schema.columns where upper(table_name)=upper('DC_UFOCC_MAILRULE') and upper(column_name)=upper('ISSENTUSERFROMLIST');
    execute 'ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN';
 	exception when no_data_found then null;
 end;
 exception when no_data_found then null;
end$$

	at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
	at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
	at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:352)
	at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.java:47)
	at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigrate.java:308)
	at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
	at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:305)
	at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.java:47)
	at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:230)
	at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:173)
	at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
	at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:173)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
	at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
	at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
	at com.otr.sufd.server.startup.AutoConfigurableFlyway.migrate(AutoConfigurableFlyway.java:74)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1638)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1579)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
	... 70 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "issentuserfromlist" cannot be cast automatically to type boolean
  Hint: You might need to specify "USING issentuserfromlist::boolean".
  Where: SQL statement "ALTER TABLE DC_UFOCC_MAILRULE ALTER COLUMN ISSENTUSERFROMLIST TYPE BOOLEAN"
PL/pgSQL function inline_code_block line 8 at EXECUTE
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
	at weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
	at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
	at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
	... 93 more