Hi Petri, Thanks for your reply. I will check and let you know.
On Sun, 28 Nov 2021, 16:21 Petri Tuomola, <[email protected]> wrote: > Hi - can you check if your table c_configurations already has an entry > with name = custom-account-number-length? > > For some reason it seems Flyway is trying to insert a config entry that is > already there. Perhaps a previous startup failed? > > If the record is there, then remove that row and retry… > > Regards > Petri > > On 28 Nov 2021, at 18:26, hitesh prajapati < > [email protected]> wrote: > > Hi All, > > I have taken the latest develop branch from community and run bootRun. The > last commit > > > https://github.com/apache/fineract/commit/8dc5789607dfa51a9186e1971998550df8e85374 > > But the fineract application is failing while starting. Lookslike some > issue with > sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql > > Below the error, I am getting > > 2021-11-28 15:48:13.797 INFO 19340 --- [ main] > org.apache.fineract.ServerApplication : Starting ServerApplication using > Java 11.0.12 on DESKTOP-92RI6NG with PID 19340 > (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main > started by hites in D:\Work\fineract\source\fineract\fineract-provider) > 2021-11-28 15:48:13.797 INFO 19340 --- [ main] > org.apache.fineract.ServerApplication : No active profile set, falling > back to default profiles: basicauth > 2021-11-28 15:48:21.279 INFO 19340 --- [ main] > o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): > 8080 (http) 8443 (https) > 2021-11-28 15:48:22.950 WARN 19340 --- [ main] > o.f.core.internal.command.DbMigrate : outOfOrder mode is active. > Migration of schema `fineract_tenants` may not be reproducible. > 2021-11-28 15:48:23.963 WARN 19340 --- [ main] > o.f.core.internal.command.DbMigrate : outOfOrder mode is active. > Migration of schema `fineract_default` may not be reproducible. > 2021-11-28 15:48:24.007 WARN 19340 --- [ main] > o.d.jdbc.internal.mysql.MySQLProtocol : Could not execute query > org.drizzle.jdbc.internal.common.query.DrizzleQuery@4e4af370: Duplicate > entry 'custom-account-number-length' for key 'name_UNIQUE' > 2021-11-28 15:48:24.039 ERROR 19340 --- [ main] > o.f.core.internal.command.DbMigrate : Migration of schema > `fineract_default` to version "378 - configuration for variable length > acoountNumber" failed! Please restore backups and roll back database and > code! > 2021-11-28 15:48:24.097 ERROR 19340 --- [ main] > o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. > Exception: > org.springframework.beans.factory.UnsatisfiedDependencyException. Message: > Error creating bean with name 'securityConfig': Unsatisfied dependency > expressed through field 'userDetailsService'; nested exception is > org.springframework.beans.factory.UnsatisfiedDependencyException: Error > creating bean with name 'userDetailsService': Unsatisfied dependency > expressed through field 'platformUserRepository'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'appUserRepository' defined in > org.apache.fineract.useradministration.domain.AppUserRepository defined in > @EnableJpaRepositories declared on PersistenceConfig: Cannot create inner > bean '(inner bean)#6f17dd06' of type > [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean > property 'entityManager'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name '(inner bean)#6f17dd06': Cannot resolve reference to bean > 'entityManagerFactory' while setting constructor argument; nested exception > is org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'tenantDatabaseUpgradeService': Invocation of init method > failed; nested exception is org.flywaydb.core.api.FlywayException: > Migration V378__configuration_for_variable_length_acoountNumber.sql failed > -------------------------------------------------------------------------- > SQL State : 23000 > Error Code : 1062 > Message : Duplicate entry 'custom-account-number-length' for key > 'name_UNIQUE' > Location : > sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql > (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main\sql\migrations\core_db\V378__configuration_for_variable_length_acoountNumber.sql) > Line : 20 > Statement : -- > -- Licensed to the Apache Software Foundation (ASF) under one > -- or more contributor license agreements. See the NOTICE file > -- distributed with this work for additional information > -- regarding copyright ownership. The ASF licenses this file > -- to you under the Apache License, Version 2.0 (the > -- "License"); you may not use this file except in compliance > -- with the License. You may obtain a copy of the License at > -- > -- http://www.apache.org/licenses/LICENSE-2.0 > -- > -- Unless required by applicable law or agreed to in writing, > -- software distributed under the License is distributed on an > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > -- KIND, either express or implied. See the License for the > -- specific language governing permissions and limitations > -- under the License. > -- > > INSERT INTO c_configuration ( name, description) VALUES ( > 'custom-account-number-length', 'if enabled, the value if this > configuration will set accounnumber length') > ; for Tenant DB URL: jdbc:mysql:thin://localhost:3306/fineract_default, > username: root > 2021-11-28 15:48:24.134 WARN 19340 --- [ main] > o.a.c.loader.WebappClassLoaderBase : The web application > [fineract-provider] appears to have started a thread named [HikariPool-1 > housekeeper] but has failed to stop it. This is very likely to create a > memory leak. Stack trace of thread: > [email protected]/jdk.internal.misc.Unsafe.park(Native Method) > [email protected] > /java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) > [email protected] > /java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) > [email protected] > /java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182) > [email protected] > /java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899) > [email protected] > /java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054) > [email protected] > /java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) > [email protected] > /java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) > [email protected]/java.lang.Thread.run(Thread.java:829) > 2021-11-28 15:48:24.134 WARN 19340 --- [ main] > o.a.c.loader.WebappClassLoaderBase : The web application > [fineract-provider] appears to have started a thread named [HikariPool-1 > connection adder] but has failed to stop it. This is very likely to create > a memory leak. Stack trace of thread: > [email protected]/jdk.internal.misc.Unsafe.park(Native Method) > [email protected] > /java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) > [email protected] > /java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) > [email protected] > /java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:458) > [email protected] > /java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1053) > [email protected] > /java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) > [email protected] > /java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) > [email protected]/java.lang.Thread.run(Thread.java:829) > 2021-11-28 15:48:24.142 WARN 19340 --- [ main] > ConfigServletWebServerApplicationContext : Exception encountered during > context initialization - cancelling refresh attempt: > org.springframework.context.ApplicationContextException: Unable to start > web server; nested exception is > org.springframework.boot.web.server.WebServerException: Unable to start > embedded Tomcat > 2021-11-28 15:48:24.191 ERROR 19340 --- [ main] > o.s.boot.SpringApplication : Application run failed > > org.springframework.context.ApplicationContextException: Unable to start > web server; nested exception is > org.springframework.boot.web.server.WebServerException: Unable to start > embedded Tomcat > at > org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:163) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:577) > at > org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) > at > org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) > at > org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412) > at > org.springframework.boot.SpringApplication.run(SpringApplication.java:302) > at > org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) > at org.apache.fineract.ServerApplication.main(ServerApplication.java:58) > Caused by: org.springframework.boot.web.server.WebServerException: Unable > to start embedded Tomcat > at > org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:142) > at > org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104) > at > org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:473) > at > org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:206) > at > org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:182) > at > org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:160) > ... 7 common frames omitted > Caused by: > org.springframework.beans.factory.UnsatisfiedDependencyException: Error > creating bean with name 'securityConfig': Unsatisfied dependency expressed > through field 'userDetailsService'; nested exception is > org.springframework.beans.factory.UnsatisfiedDependencyException: Error > creating bean with name 'userDetailsService': Unsatisfied dependency > expressed through field 'platformUserRepository'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'appUserRepository' defined in > org.apache.fineract.useradministration.domain.AppUserRepository defined in > @EnableJpaRepositories declared on PersistenceConfig: Cannot create inner > bean '(inner bean)#6f17dd06' of type > [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean > property 'entityManager'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name '(inner bean)#6f17dd06': Cannot resolve reference to bean > 'entityManagerFactory' while setting constructor argument; nested exception > is org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'tenantDatabaseUpgradeService': Invocation of init method > failed; nested exception is org.flywaydb.core.api.FlywayException: > Migration V378__configuration_for_variable_length_acoountNumber.sql failed > -------------------------------------------------------------------------- > SQL State : 23000 > Error Code : 1062 > Message : Duplicate entry 'custom-account-number-length' for key > 'name_UNIQUE' > Location : > sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql > (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main\sql\migrations\core_db\V378__configuration_for_variable_length_acoountNumber.sql) > Line : 20 > Statement : -- > > >
