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 11:01:00 UTC
[jira] [Updated] (FINERACT-1326) Migration
V327_1__creditbureau_integration.sql failed
[ https://issues.apache.org/jira/browse/FINERACT-1326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anu Omotayo updated FINERACT-1326:
----------------------------------
Attachment: fineract_default_schema_version.csv
> 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
> Priority: Blocker
> Attachments: fineract_default_schema_version.csv
>
>
> [~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)