Hi Petri, Thanks for your suggestion.
I don't have any data in my database. So I deleted my db and re-created them again. After that i run bootRun and the application is running fine. But I forgot to check the c_configurations table for an entry with name = custom-account-number-length, before deleting it and recreating it. Thanks, Hitesh On Sun, Nov 28, 2021 at 4:26 PM hitesh prajapati < hitesh.kams.prajap...@gmail.com> wrote: > Hi Petri, > > Thanks for your reply. I will check and let you know. > > On Sun, 28 Nov 2021, 16:21 Petri Tuomola, <petri.tuom...@gmail.com> 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 < >> hitesh.kams.prajap...@gmail.com> 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: >> java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native Method) >> java.base@11.0.12 >> /java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) >> java.base@11.0.12 >> /java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) >> java.base@11.0.12 >> /java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182) >> java.base@11.0.12 >> /java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) >> java.base@11.0.12/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: >> java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native Method) >> java.base@11.0.12 >> /java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) >> java.base@11.0.12 >> /java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) >> java.base@11.0.12 >> /java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:458) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1053) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) >> java.base@11.0.12 >> /java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) >> java.base@11.0.12/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 : -- >> >> >>