Hi Romain,
We tried with null FK. But it didn't work. We can't manually cascade delete operation in our application. By adding OpenJPA specific annotation @ForeignKey(deleteAction=ForeignKeyAction.CASCADE) to all child entities we don't find any foreign key constraint issue. With this the order of the SQL statements are proper. For now we are going ahead with this approach. Thanks again, Nazeer -----Original Message----- From: Romain Manni-Bucau [mailto:[email protected]] Sent: 03 October 2016 15:34 To: [email protected] Subject: Re: [OpenJPA] Issue with Entity Delete - Need help either ensuring the FK is nullable or sadly do the cascade manually Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog < <https://blog-rmannibucau.rhcloud.com> https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog < <http://rmannibucau.wordpress.com> http://rmannibucau.wordpress.com> | Github < <https://github.com/rmannibucau> https://github.com/rmannibucau> | LinkedIn < <https://www.linkedin.com/in/rmannibucau> https://www.linkedin.com/in/rmannibucau> | Tomitriber < <http://www.tomitribe.com> http://www.tomitribe.com> | JavaEE Factory < <https://javaeefactory-rmannibucau.rhcloud.com> https://javaeefactory-rmannibucau.rhcloud.com> 2016-10-03 12:00 GMT+02:00 Shaik Nazeer < <mailto:[email protected]> [email protected]>: > Hi Romain, > > Thanks again for your time. Let me know the approaches I should take > to resolve this issue. I will give a try. > > Thanks, > Nazeer > > -----Original Message----- > From: Romain Manni-Bucau [ <mailto:[email protected]> > mailto:[email protected]] > Sent: 03 October 2016 15:16 > To: <mailto:[email protected]> [email protected] > Subject: Re: [OpenJPA] Issue with Entity Delete - Need help > > aren't the workaround(s) doable for you? > > > Romain Manni-Bucau > @rmannibucau < <https://twitter.com/rmannibucau> > https://twitter.com/rmannibucau> | Blog < > <https://blog-rmannibucau.rhcloud.com> https://blog-rmannibucau.rhcloud.com> > | Old Wordpress Blog < > <http://rmannibucau.wordpress.com> http://rmannibucau.wordpress.com> | > Github > < <https://github.com/rmannibucau> https://github.com/rmannibucau> > | LinkedIn < <https://www.linkedin.com/in/rmannibucau> > https://www.linkedin.com/in/rmannibucau> | Tomitriber < > <http://www.tomitribe.com> http://www.tomitribe.com> | JavaEE Factory > <https://javaeefactory- > rmannibucau.rhcloud.com> > > 2016-10-03 11:37 GMT+02:00 Shaik Nazeer < > <mailto:[email protected]> > [email protected]>: > > > Hi Romain, > > > > Thank you very much for your time. Looks like, I am facing the same > > issue mentioned in the following JIRA issue. Any plans to resolve this? > > > > <https://issues.apache.org/jira/browse/OPENJPA-39> > > https://issues.apache.org/jira/browse/OPENJPA-39 > > > > Thanks, > > Nazeer > > > > -----Original Message----- > > From: Romain Manni-Bucau [ <mailto:[email protected]> > > mailto:[email protected]] > > Sent: 29 September 2016 22:34 > > To: <mailto:[email protected]> [email protected] > > Subject: Re: [OpenJPA] Issue with Entity Delete - Need help > > > > Didnt manage to reproduce with the build of provider but your > > exception is more an actual error with the DB state ( Cannot delete > > or update a parent > > row: a foreign key constraint fails) than a state issue > > > > To move forward the best is to isolate the issue in a smaller sample > > you can share on github or any public repo. > > > > > > Romain Manni-Bucau > > @rmannibucau < <https://twitter.com/rmannibucau> > > https://twitter.com/rmannibucau> | Blog < > > <https://blog-rmannibucau.rhcloud.com> > > https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog < > > <http://rmannibucau.wordpress.com> http://rmannibucau.wordpress.com> | > > Github > > < <https://github.com/rmannibucau> https://github.com/rmannibucau> > > | LinkedIn < <https://www.linkedin.com/in/rmannibucau> > > https://www.linkedin.com/in/rmannibucau> | Tomitriber < > > <http://www.tomitribe.com> http://www.tomitribe.com> | JavaEE Factory > > <https://javaeefactory- > > rmannibucau.rhcloud.com> > > > > 2016-09-29 14:40 GMT+02:00 Shaik Nazeer < > > <mailto:[email protected]> > > [email protected]>: > > > > > Hi Romain, > > > > > > We don't travis CI configured for our repository. But it is easy > > > to configure the project locally. > > > Changes are available in the following branch. Instructions to run > > > integration tests are mentioned README.md > > > <https://github.com/nazeer1100126/incubator-fineract/tree/fineract_> > > > https://github.com/nazeer1100126/incubator-fineract/tree/fineract_ > > > op > > > en > > > jpa > > > > > > One of the failed test case produces the following output. > > > > > > 17:40:54.597 [http-bio-8443-exec-23] ERROR > > > c.s.j.s.container.ContainerResponse > > > - The RuntimeException could not be mapped to a response, > > > re-throwing to the HTTP container > > > org.springframework.orm.jpa.JpaSystemException: The transaction > > > has been rolled back. See the nested exceptions for details on > > > the errors that occurred.; nested exception is > > > <openjpa-2.4.1-r422266:1730418 fatal general > > > error> org.apache.openjpa.persistence.PersistenceException: The > > > transaction has been rolled back. See the nested exceptions for > > > details on the errors that occurred. > > > FailedObject: org.apache.fineract.portfolio.savings.domain. > > > DepositAccountInterestRateChart-79 > > > at org.springframework.orm.jpa.EntityManagerFactoryUtils. > > > convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java > > > :4 > > > 18 > > > ) ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.orm.jpa.DefaultJpaDialect. > > > translateExceptionIfPossible(DefaultJpaDialect.java:122) > > > ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at > > > org.springframework.orm.jpa.JpaTransactionManager.doCommit( > > > JpaTransactionManager.java:519) ~[spring-orm-4.0.7.RELEASE. > > > jar:4.0.7.RELEASE] > > > at org.springframework.transaction.support. > > > AbstractPlatformTransactionManager.processCommit( > > > AbstractPlatformTransactionManager.java:757) > > > ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.transaction.support. > > > AbstractPlatformTransactionManager.commit(AbstractPlatformTransact > > > io > > > nM > > > anager.java:726) ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionAspectSupport.commitTransactionAfterReturnin > > > g(TransactionAspectSupport.java:478) ~[spring-tx-4.0.7.RELEASE.jar: > > > 4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionAspectSupport.invokeWithinTransaction( > > > TransactionAspectSupport.java:272) ~[spring-tx-4.0.7.RELEASE.jar: > > > 4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionInterceptor.invoke(TransactionInterceptor.java:95) > > > ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.aop.framework. > ReflectiveMethodInvocation. > > > proceed(ReflectiveMethodInvocation.java:179) > ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at org.springframework.aop.framework.JdkDynamicAopProxy. > > > invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at com.sun.proxy.$Proxy209.processAndLogCommand(Unknown > > > Source) ~[na:na] > > > at org.apache.fineract.commands.service. > > > PortfolioCommandSourceWritePlatformServiceImpl.logCommandSource( > > > PortfolioCommandSourceWritePlatformServiceImpl.java:98) ~[ > > > PortfolioCommandSourceWritePlatformServiceImpl.class:na] > > > at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown > > > Source) ~[na:na] > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > > > DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_72] > > > at java.lang.reflect.Method.invoke(Method.java:498) > > ~[na:1.8.0_72] > > > at org.springframework.aop.support.AopUtils. > > > invokeJoinpointUsingReflection(AopUtils.java:317) > > > ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] > > > at org.springframework.aop.framework.JdkDynamicAopProxy. > > > invoke(JdkDynamicAopProxy.java:201) ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at com.sun.proxy.$Proxy210.logCommandSource(Unknown > > > Source) ~[na:na] > > > at org.apache.fineract.portfolio.savings.api. > > > FixedDepositAccountsApiResource.delete(FixedDepositAccountsApiReso > > > ur > > > ce > > > .java:326) ~[FixedDepositAccountsApiResource.class:na] > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > > > Method) ~[na:1.8.0_72] > > > at sun.reflect.NativeMethodAccessorImpl.invoke( > > > NativeMethodAccessorImpl.java:62) ~[na:1.8.0_72] > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > > > DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_72] > > > at java.lang.reflect.Method.invoke(Method.java:498) > > ~[na:1.8.0_72] > > > at > > > com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke( > > > JavaMethodInvokerFactory.java:60) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.model.method.dispatch. > > > AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch( > > > AbstractResourceMethodDispatchProvider.java:185) > > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.model.method.dispatch. > > > ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher > > > .j > > > av > > > a:75) > > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.HttpMethodRule. > > > accept(HttpMethodRule.java:302) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.RightHandPathRule. > > > accept(RightHandPathRule.java:147) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.ResourceClassRule. > > > accept(ResourceClassRule.java:108) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.RightHandPathRule. > > > accept(RightHandPathRule.java:147) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules. > RootResourceClassesRule. > > > accept(RootResourceClassesRule.java:84) ~[jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.server.impl.application.WebApplicationImpl._ > > > handleRequest(WebApplicationImpl.java:1511) > > [jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.server.impl.application.WebApplicationImpl._ > > > handleRequest(WebApplicationImpl.java:1442) > > [jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.application.WebApplicationImpl. > > > handleRequest(WebApplicationImpl.java:1391) > > [jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.application.WebApplicationImpl. > > > handleRequest(WebApplicationImpl.java:1381) > > [jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.spi.container.servlet.WebComponent.service(WebCompo > > > ne > > > nt > > > .java:416) > > > [jersey-servlet-1.17.jar:1.17] > > > at com.sun.jersey.spi.container.servlet.ServletContainer. > > > service(ServletContainer.java:538) [jersey-servlet-1.17.jar:1.17] > > > at com.sun.jersey.spi.container.servlet.ServletContainer. > > > service(ServletContainer.java:716) [jersey-servlet-1.17.jar:1.17] > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:303) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:10 > > > 8) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java: > > > 84 > > > ) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:11 > > > 8) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java: > > > 84 > > > ) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access. > > > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: > > > 11 > > > 3) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.authentication. > > > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilt > > > er > > > .j > > > ava:113) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.servletapi. > > > SecurityContextHolderAwareRequestFilter.doFilter( > > > SecurityContextHolderAwareRequestFilter.java:154) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.context.request.async. > > > WebAsyncManagerIntegrationFilter.doFilterInternal( > > > WebAsyncManagerIntegrationFilter.java:50) [spring-security-web-3.2.5. > > > RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.web.filter.OncePerRequestFilter. > > > doFilter(OncePerRequestFilter.java:107) [spring-web-4.0.8.RELEASE.jar: > > > 4.0.8.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.authentication.www. > > > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java: > > > 20 > > > 1) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.fineract.infrastructure.security.filter. > > > TenantAwareBasicAuthenticationFilter.doFilter( > > > TenantAwareBasicAuthenticationFilter.java:150) [ > > > TenantAwareBasicAuthenticationFilter.class:na] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.context. > > > SecurityContextPersistenceFilter.doFilter(SecurityContextPersisten > > > ce > > > Fi > > > lter.java:87) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.channel. > > > ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy. > > > doFilterInternal(FilterChainProxy.java:192) > [spring-security-web-3.2.5. > > > RELEASE.jar:3.2.5.RELEASE] > > > at > > > org.springframework.security.web.FilterChainProxy.doFilter(FilterC > > > ha > > > in > > > Proxy.java:160) [spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > doFilter(ErrorPageFilter.java:108) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > access$000(ErrorPageFilter.java:58) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter$1. > > > doFilterInternal(ErrorPageFilter.java:87) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.web.filter.OncePerRequestFilter. > > > doFilter(OncePerRequestFilter.java:107) [spring-web-4.0.8.RELEASE.jar: > > > 4.0.8.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > doFilter(ErrorPageFilter.java:100) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > > er > > > Va > > > lve.java:220) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > > xt > > > Va > > > lve.java:122) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authent > > > ic > > > at > > > orBase.java:501) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve. > > > ja > > > va:171) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve. > > > ja > > > va:102) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > > Va > > > lv > > > e.java:116) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter. > > > ja > > > va > > > :408) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.coyote.http11.AbstractHttp11Processor.process( > > > AbstractHttp11Processor.java:1040) [tomcat-embed-core-7.0.54.jar: > 7.0.54] > > > at org.apache.coyote.AbstractProtocol$ > AbstractConnectionHandler. > > > process(AbstractProtocol.java:607) [tomcat-embed-core-7.0.54.jar: > 7.0.54] > > > at > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndp > > > oi > > > nt > > > .java:314) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut > > > or > > > .j > > > ava:1142) > > > [na:1.8.0_72] > > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor. > > > java:617) > > > [na:1.8.0_72] > > > at > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(Tas > > > kT > > > hr > > > ead.java:61) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72] > > > Caused > > > by: org.apache.openjpa.persistence.PersistenceException: The > > > transaction has been rolled back. See the nested exceptions for > > > details on the errors that occurred. > > > at > > > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl. > > > ja > > > va > > > :2368) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:210 > > > 3) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java: > > > 2021) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedR > > > un > > > ti > > > me.java:81) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker > > > .j > > > av > > > a:932) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.persistence.EntityManagerImpl. > > > commit(EntityManagerImpl.java:571) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.springframework.orm.jpa.JpaTransactionManager.doCommit( > > > JpaTransactionManager.java:515) ~[spring-orm-4.0.7.RELEASE. > > > jar:4.0.7.RELEASE] > > > ... 87 common frames omitted Caused by: > > > org.apache.openjpa.persistence.EntityExistsException: > > > Cannot delete or update a parent row: a foreign key constraint > > > fails > > > (`mifostenant-default`.`m_savings_account_interest_rate_slab`, > > > CONSTRAINT `FKSAIRS00000000000001` FOREIGN KEY > > > (`savings_account_interest_rate_chart_id`) > > > REFERENCES `m_savings_account_interest_r) {prepstmnt 385129669 > > > DELETE FROM m_savings_account_interest_rate_chart WHERE id = ? > > > [params=?]} [code=1451, state=23000] > > > at > > > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java: > > > 49 > > > 88 > > > ) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDicti > > > on > > > ar > > > y.java:4963) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java: > > > 133) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java: > > > 75) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushAndUpdate(PreparedStatementManagerImpl.java:144) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManag > > > erImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79 > > > ) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushInternal(PreparedStatementManagerImpl.java:100) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flush(PreparedStatementManagerImpl.java:88) > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush( > > > ConstraintUpdateManager.java:550) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush( > > > ConstraintUpdateManager.java:120) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManage > > > r.flush(BatchingConstraintUpdateManager.java:59) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager. > > > flush(AbstractUpdateManager.java:104) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager. > > > flush(AbstractUpdateManager.java:77) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreMan > > > ag > > > er > > > .java:731) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.kernel.DelegatingStoreManager.flush( > > > DelegatingStoreManager.java:131) ~[openjpa-all-2.4.1.jar:2.4.1] > > > ... 95 common frames omitted Caused by: > > > org.apache.openjpa.lib.jdbc.ReportingSQLException: Cannot delete > > > or update a parent row: a foreign key constraint fails > > > (`mifostenant-default`.`m_savings_account_interest_rate_slab`, > > > CONSTRAINT `FKSAIRS00000000000001` FOREIGN KEY > > > (`savings_account_interest_rate_chart_id`) > > > REFERENCES `m_savings_account_interest_r) {prepstmnt 385129669 > > > DELETE FROM m_savings_account_interest_rate_chart WHERE id = ? > > > [params=?]} [code=1451, state=23000] > > > at > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap( > > > LoggingConnectionDecorator.java:218) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap( > > > LoggingConnectionDecorator.java:194) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator. > > > access$1000(LoggingConnectionDecorator.java:58) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$ > > > LoggingConnection$LoggingPreparedStatement.executeUpdate( > > > LoggingConnectionDecorator.java:1133) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement. > > > executeUpdate(DelegatingPreparedStatement.java:275) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$ > > > CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1791) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > executeUpdate(PreparedStatementManagerImpl.java:268) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushAndUpdate(PreparedStatementManagerImpl.java:119) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > ... 105 common frames omitted > > > 17:40:54.707 [http-bio-8443-exec-23] INFO o.a.f.i.s.f. > > > TenantAwareBasicAuthenticationFilter - {"startTime":1475151054205," > > > totalTime":501,"method":"DELETE","url":"https://localhost:8443/fin > > > er > > > ac > > > t- provider/api/v1/fixeddepositaccounts/155","parameters":{" > > > tenantIdentifier":["default"]}} > > > 17:40:54.717 [http-bio-8443-exec-23] ERROR > > > o.s.boot.context.web.ErrorPageFilter > > > - Forwarding to error page from request > > > [/api/v1/fixeddepositaccounts/155] > > > due to exception [The transaction has been rolled back. See the > > > nested exceptions for details on the errors that occurred.; nested > > > exception is > > > <openjpa-2.4.1-r422266:1730418 fatal general error> org.apache.openjpa. > > > persistence.PersistenceException: The transaction has been rolled > back. > > > See the nested exceptions for details on the errors that occurred. > > > FailedObject: org.apache.fineract.portfolio.savings.domain. > > > DepositAccountInterestRateChart-79] > > > org.springframework.orm.jpa.JpaSystemException: The transaction > > > has been rolled back. See the nested exceptions for details on > > > the errors that occurred.; nested exception is > > > <openjpa-2.4.1-r422266:1730418 fatal general > > > error> org.apache.openjpa.persistence.PersistenceException: The > > > transaction has been rolled back. See the nested exceptions for > > > details on the errors that occurred. > > > FailedObject: org.apache.fineract.portfolio.savings.domain. > > > DepositAccountInterestRateChart-79 > > > at org.springframework.orm.jpa.EntityManagerFactoryUtils. > > > convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java > > > :4 > > > 18 > > > ) ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.orm.jpa.DefaultJpaDialect. > > > translateExceptionIfPossible(DefaultJpaDialect.java:122) > > > ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at > > > org.springframework.orm.jpa.JpaTransactionManager.doCommit( > > > JpaTransactionManager.java:519) ~[spring-orm-4.0.7.RELEASE. > > > jar:4.0.7.RELEASE] > > > at org.springframework.transaction.support. > > > AbstractPlatformTransactionManager.processCommit( > > > AbstractPlatformTransactionManager.java:757) > > > ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.transaction.support. > > > AbstractPlatformTransactionManager.commit(AbstractPlatformTransact > > > io > > > nM > > > anager.java:726) ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionAspectSupport.commitTransactionAfterReturnin > > > g(TransactionAspectSupport.java:478) ~[spring-tx-4.0.7.RELEASE.jar: > > > 4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionAspectSupport.invokeWithinTransaction( > > > TransactionAspectSupport.java:272) ~[spring-tx-4.0.7.RELEASE.jar: > > > 4.0.7.RELEASE] > > > at org.springframework.transaction.interceptor. > > > TransactionInterceptor.invoke(TransactionInterceptor.java:95) > > > ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] > > > at org.springframework.aop.framework. > ReflectiveMethodInvocation. > > > proceed(ReflectiveMethodInvocation.java:179) > ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at org.springframework.aop.framework.JdkDynamicAopProxy. > > > invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at com.sun.proxy.$Proxy209.processAndLogCommand(Unknown > > > Source) ~[na:na] > > > at org.apache.fineract.commands.service. > > > PortfolioCommandSourceWritePlatformServiceImpl.logCommandSource( > > > PortfolioCommandSourceWritePlatformServiceImpl.java:98) ~[ > > > PortfolioCommandSourceWritePlatformServiceImpl.class:na] > > > at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown > > > Source) ~[na:na] > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > > > DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_72] > > > at java.lang.reflect.Method.invoke(Method.java:498) > > ~[na:1.8.0_72] > > > at org.springframework.aop.support.AopUtils. > > > invokeJoinpointUsingReflection(AopUtils.java:317) > > > ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] > > > at org.springframework.aop.framework.JdkDynamicAopProxy. > > > invoke(JdkDynamicAopProxy.java:201) ~[spring-aop-4.0.8.RELEASE. > > > jar:4.0.8.RELEASE] > > > at com.sun.proxy.$Proxy210.logCommandSource(Unknown > > > Source) ~[na:na] > > > at org.apache.fineract.portfolio.savings.api. > > > FixedDepositAccountsApiResource.delete(FixedDepositAccountsApiReso > > > ur > > > ce > > > .java:326) ~[FixedDepositAccountsApiResource.class:na] > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > > > Method) ~[na:1.8.0_72] > > > at sun.reflect.NativeMethodAccessorImpl.invoke( > > > NativeMethodAccessorImpl.java:62) ~[na:1.8.0_72] > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > > > DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_72] > > > at java.lang.reflect.Method.invoke(Method.java:498) > > ~[na:1.8.0_72] > > > at > > > com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke( > > > JavaMethodInvokerFactory.java:60) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.model.method.dispatch. > > > AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch( > > > AbstractResourceMethodDispatchProvider.java:185) > > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.model.method.dispatch. > > > ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher > > > .j > > > av > > > a:75) > > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.HttpMethodRule. > > > accept(HttpMethodRule.java:302) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.RightHandPathRule. > > > accept(RightHandPathRule.java:147) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.ResourceClassRule. > > > accept(ResourceClassRule.java:108) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules.RightHandPathRule. > > > accept(RightHandPathRule.java:147) ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.uri.rules. > RootResourceClassesRule. > > > accept(RootResourceClassesRule.java:84) ~[jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.server.impl.application.WebApplicationImpl._ > > > handleRequest(WebApplicationImpl.java:1511) > > ~[jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.server.impl.application.WebApplicationImpl._ > > > handleRequest(WebApplicationImpl.java:1442) > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.application.WebApplicationImpl. > > > handleRequest(WebApplicationImpl.java:1391) > > ~[jersey-server-1.17.jar:1.17] > > > at com.sun.jersey.server.impl.application.WebApplicationImpl. > > > handleRequest(WebApplicationImpl.java:1381) > > ~[jersey-server-1.17.jar:1.17] > > > at > > > com.sun.jersey.spi.container.servlet.WebComponent.service(WebCompo > > > ne > > > nt > > > .java:416) > > > ~[jersey-servlet-1.17.jar:1.17] > > > at com.sun.jersey.spi.container.servlet.ServletContainer. > > > service(ServletContainer.java:538) ~[jersey-servlet-1.17.jar:1.17] > > > at com.sun.jersey.spi.container.servlet.ServletContainer. > > > service(ServletContainer.java:716) ~[jersey-servlet-1.17.jar:1.17] > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > > > ~[tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:303) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:10 > > > 8) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java: > > > 84 > > > ) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:11 > > > 8) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.intercept. > > > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java: > > > 84 > > > ) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access. > > > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: > > > 11 > > > 3) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.authentication. > > > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilt > > > er > > > .j > > > ava:113) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.servletapi. > > > SecurityContextHolderAwareRequestFilter.doFilter( > > > SecurityContextHolderAwareRequestFilter.java:154) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.context.request.async. > > > WebAsyncManagerIntegrationFilter.doFilterInternal( > > > WebAsyncManagerIntegrationFilter.java:50) ~[spring-security-web-3.2.5. > > > RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.web.filter.OncePerRequestFilter. > > > doFilter(OncePerRequestFilter.java:107) [spring-web-4.0.8.RELEASE.jar: > > > 4.0.8.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.authentication.www. > > > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java: > > > 20 > > > 1) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.fineract.infrastructure.security.filter. > > > TenantAwareBasicAuthenticationFilter.doFilter( > > > TenantAwareBasicAuthenticationFilter.java:150) ~[ > > > TenantAwareBasicAuthenticationFilter.class:na] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.context. > > > SecurityContextPersistenceFilter.doFilter(SecurityContextPersisten > > > ce > > > Fi > > > lter.java:87) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.access.channel. > > > ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy$ > > > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > > ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.springframework.security.web.FilterChainProxy. > > > doFilterInternal(FilterChainProxy.java:192) > ~[spring-security-web-3.2.5. > > > RELEASE.jar:3.2.5.RELEASE] > > > at > > > org.springframework.security.web.FilterChainProxy.doFilter(FilterC > > > ha > > > in > > > Proxy.java:160) ~[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > doFilter(ErrorPageFilter.java:108) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > access$000(ErrorPageFilter.java:58) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter$1. > > > doFilterInternal(ErrorPageFilter.java:87) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.springframework.web.filter.OncePerRequestFilter. > > > doFilter(OncePerRequestFilter.java:107) [spring-web-4.0.8.RELEASE.jar: > > > 4.0.8.RELEASE] > > > at org.springframework.boot.context.web.ErrorPageFilter. > > > doFilter(ErrorPageFilter.java:100) [spring-boot-1.1.6.RELEASE. > > > jar:1.1.6.RELEASE] > > > at org.apache.catalina.core.ApplicationFilterChain. > > > internalDoFilter(ApplicationFilterChain.java:241) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:208) [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > > er > > > Va > > > lve.java:220) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > > xt > > > Va > > > lve.java:122) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authent > > > ic > > > at > > > orBase.java:501) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve. > > > ja > > > va:171) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve. > > > ja > > > va:102) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > > Va > > > lv > > > e.java:116) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter. > > > ja > > > va > > > :408) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > org.apache.coyote.http11.AbstractHttp11Processor.process( > > > AbstractHttp11Processor.java:1040) [tomcat-embed-core-7.0.54.jar: > 7.0.54] > > > at org.apache.coyote.AbstractProtocol$ > AbstractConnectionHandler. > > > process(AbstractProtocol.java:607) [tomcat-embed-core-7.0.54.jar: > 7.0.54] > > > at > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndp > > > oi > > > nt > > > .java:314) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut > > > or > > > .j > > > ava:1142) > > > [na:1.8.0_72] > > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor. > > > java:617) > > > [na:1.8.0_72] > > > at > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(Tas > > > kT > > > hr > > > ead.java:61) > > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72] > > > Caused > > > by: org.apache.openjpa.persistence.PersistenceException: The > > > transaction has been rolled back. See the nested exceptions for > > > details on the errors that occurred. > > > at > > > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl. > > > ja > > > va > > > :2368) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:210 > > > 3) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java: > > > 2021) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedR > > > un > > > ti > > > me.java:81) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker > > > .j > > > av > > > a:932) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.persistence.EntityManagerImpl. > > > commit(EntityManagerImpl.java:571) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.springframework.orm.jpa.JpaTransactionManager.doCommit( > > > JpaTransactionManager.java:515) ~[spring-orm-4.0.7.RELEASE. > > > jar:4.0.7.RELEASE] > > > ... 87 common frames omitted Caused by: > > > org.apache.openjpa.persistence.EntityExistsException: > > > Cannot delete or update a parent row: a foreign key constraint > > > fails > > > (`mifostenant-default`.`m_savings_account_interest_rate_slab`, > > > CONSTRAINT `FKSAIRS00000000000001` FOREIGN KEY > > > (`savings_account_interest_rate_chart_id`) > > > REFERENCES `m_savings_account_interest_r) {prepstmnt 385129669 > > > DELETE FROM m_savings_account_interest_rate_chart WHERE id = ? > > > [params=?]} [code=1451, state=23000] > > > at > > > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java: > > > 49 > > > 88 > > > ) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDicti > > > on > > > ar > > > y.java:4963) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java: > > > 133) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java: > > > 75) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushAndUpdate(PreparedStatementManagerImpl.java:144) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManag > > > erImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79 > > > ) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushInternal(PreparedStatementManagerImpl.java:100) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flush(PreparedStatementManagerImpl.java:88) > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush( > > > ConstraintUpdateManager.java:550) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush( > > > ConstraintUpdateManager.java:120) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManage > > > r.flush(BatchingConstraintUpdateManager.java:59) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager. > > > flush(AbstractUpdateManager.java:104) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager. > > > flush(AbstractUpdateManager.java:77) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreMan > > > ag > > > er > > > .java:731) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.kernel.DelegatingStoreManager.flush( > > > DelegatingStoreManager.java:131) ~[openjpa-all-2.4.1.jar:2.4.1] > > > ... 95 common frames omitted Caused by: > > > org.apache.openjpa.lib.jdbc.ReportingSQLException: Cannot delete > > > or update a parent row: a foreign key constraint fails > > > (`mifostenant-default`.`m_savings_account_interest_rate_slab`, > > > CONSTRAINT `FKSAIRS00000000000001` FOREIGN KEY > > > (`savings_account_interest_rate_chart_id`) > > > REFERENCES `m_savings_account_interest_r) {prepstmnt 385129669 > > > DELETE FROM m_savings_account_interest_rate_chart WHERE id = ? > > > [params=?]} [code=1451, state=23000] > > > at > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap( > > > LoggingConnectionDecorator.java:218) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at > > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap( > > > LoggingConnectionDecorator.java:194) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator. > > > access$1000(LoggingConnectionDecorator.java:58) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$ > > > LoggingConnection$LoggingPreparedStatement.executeUpdate( > > > LoggingConnectionDecorator.java:1133) ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement. > > > executeUpdate(DelegatingPreparedStatement.java:275) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$ > > > CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1791) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > executeUpdate(PreparedStatementManagerImpl.java:268) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > at org.apache.openjpa.jdbc.kernel. > PreparedStatementManagerImpl. > > > flushAndUpdate(PreparedStatementManagerImpl.java:119) > > > ~[openjpa-all-2.4.1.jar:2.4.1] > > > ... 105 common frames omitted > > > 17:40:54.818 [http-bio-8443-exec-23] INFO > > > o.s.web.servlet.DispatcherServlet > > > - FrameworkServlet 'dispatcherServlet': initialization started > > > 17:40:54.875 [http-bio-8443-exec-23] INFO > > > o.s.web.servlet.DispatcherServlet > > > - FrameworkServlet 'dispatcherServlet': initialization completed > > > in > > > 56 ms > > > > > > Thanks, > > > Nazeer > > > > > > -----Original Message----- > > > From: Romain Manni-Bucau [ <mailto:[email protected]> > > > mailto:[email protected]] > > > Sent: 29 September 2016 17:03 > > > To: <mailto:[email protected]> [email protected] > > > Subject: Re: [OpenJPA] Issue with Entity Delete - Need help > > > > > > Do you have a failing unit test on github reproducing it? > > > > > > Le 29 sept. 2016 12:35, "nazeer" > > > < <mailto:[email protected]> > > > [email protected]> a écrit : > > > > > > > Hi all, > > > > > > > > I have verified and entity is not detached one. > > > > > > > > Thanks, > > > > Nazeer > > > > > > > > > > > > > > > > -- > > > > View this message in context: http://openjpa.208410.n2. > > > > nabble.com/OpenJPA-Issue-with-Entity-Delete-Need-help- > > > > tp7589735p7589738.html > > > > Sent from the OpenJPA Developers mailing list archive at Nabble.com. > > > > > > > > > > > > > > > > > > > > > >
