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]] Sent: 03 October 2016 15:16 To: [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> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber <http://www.tomitribe.com> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2016-10-03 11:37 GMT+02:00 Shaik Nazeer < [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 > > Thanks, > Nazeer > > -----Original Message----- > From: Romain Manni-Bucau [mailto:[email protected]] > Sent: 29 September 2016 22:34 > To: [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> | Blog < > https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog < > http://rmannibucau.wordpress.com> | Github > <https://github.com/rmannibucau> > | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber < > http://www.tomitribe.com> | JavaEE Factory <https://javaeefactory- > rmannibucau.rhcloud.com> > > 2016-09-29 14:40 GMT+02:00 Shaik Nazeer < > [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_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(AbstractPlatformTransactio > > 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(FixedDepositAccountsApiResour > > 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(WebCompone > > 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:108) > > [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:118) > > [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(AnonymousAuthenticationFilter > > .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(SecurityContextPersistence > > 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(FilterCha > > 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(StandardWrapper > > Va > > lve.java:220) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContext > > Va > > lve.java:122) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentic > > 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(StandardEngineVa > > 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(JIoEndpoi > > nt > > .java:314) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor > > .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(TaskT > > 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:2103) > > ~[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(LocalManagedRun > > 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(DBDiction > > 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(JDBCStoreManag > > 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/finer > > 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(AbstractPlatformTransactio > > 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(FixedDepositAccountsApiResour > > 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(WebCompone > > 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:108) > > ~[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:118) > > ~[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(AnonymousAuthenticationFilter > > .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(SecurityContextPersistence > > 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(FilterCha > > 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(StandardWrapper > > Va > > lve.java:220) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContext > > Va > > lve.java:122) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentic > > 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(StandardEngineVa > > 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(JIoEndpoi > > nt > > .java:314) > > [tomcat-embed-core-7.0.54.jar:7.0.54] > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor > > .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(TaskT > > 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:2103) > > ~[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(LocalManagedRun > > 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(DBDiction > > 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(JDBCStoreManag > > 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]] > > Sent: 29 September 2016 17:03 > > To: [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" > > <[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. > > > > > > > > > > > >
