You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Anu Omotayo (Jira)" <ji...@apache.org> on 2021/03/09 10:59:00 UTC
[jira] [Created] (FINERACT-1326) Migration
V327_1__creditbureau_integration.sql failed
Anu Omotayo created FINERACT-1326:
-------------------------------------
Summary: Migration V327_1__creditbureau_integration.sql failed
Key: FINERACT-1326
URL: https://issues.apache.org/jira/browse/FINERACT-1326
Project: Apache Fineract
Issue Type: Bug
Components: Database, System
Affects Versions: 1.4.0
Reporter: Anu Omotayo
[~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
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`)
)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)