Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1326

Migration V327_1__creditbureau_integration.sql failed

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • 1.4.0
    • None
    • Database, System
    • None

    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`)
      )

      Attachments

        Activity

          People

            Unassigned Unassigned
            anmotayo Anu Omotayo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: