Blocker Description
avikg, avikganguly, avikganguly010
What is in our fineract_default.schema_version table is "V327_creditbureau_configuration.sql", there is no "V327_1_creditbureau_integration.sql" in it. I have attached a csv file containing the records in fineract_default.schema_version table.
Below is the error message we are getting when we tried to deploy Fineract.
-------------------------------------------------------------------------------------------------
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
; for Tenant DB URL: jdbc:mysql:thin://localhost:3306/fineract_default, username: root
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:415)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:311)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330)
... 148 more
Caused by: org.flywaydb.core.api.FlywayException:
Migration V327_1__creditbureau_integration.sql failed
-----------------------------------------------------
SQL State : 42S01
Error Code : 1050
Message : Table 'm_creditbureau_token' already exists
Location : sql/migrations/core_db/V327_1_creditbureau_integration.sql (/opt/tomcat/webapps/fineract-provider/WEB-INF/classes/sql/migrations/core_db/V327_1_creditbureau_integration.sql)
Line : 21
Statement : CREATE TABLE `m_creditbureau_token` (
`id` INT(128) NOT NULL AUTO_INCREMENT,
`username` varchar(128) DEFAULT NULL,
`token` MEDIUMTEXT DEFAULT NULL,
`tokenType` varchar(128) DEFAULT NULL,
`expiresIn` varchar(128) DEFAULT NULL,
`issued` varchar(128) DEFAULT NULL,
`expiryDate` DATE DEFAULT NULL,
PRIMARY KEY (`id`)
)