You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Shaik Nazeer <na...@confluxtechnologies.com> on 2016/10/03 09:37:26 UTC
RE: [OpenJPA] Issue with Entity Delete - Need help
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:rmannibucau@gmail.com]
Sent: 29 September 2016 22:34
To: dev@openjpa.apache.org
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 <
nazeer.shaik@confluxtechnologies.com>:
> 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_open
> 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:418
> ) ~[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(AbstractPlatformTransactionM
> 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(FixedDepositAccountsApiResource
> .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.jav
> 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(WebComponent
> .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:201)
> [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(SecurityContextPersistenceFi
> 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(FilterChain
> 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(StandardWrapperVa
> lve.java:220)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> lve.java:122)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticat
> 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(StandardEngineValv
> e.java:116)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :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(JIoEndpoint
> .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(TaskThr
> 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.java
> :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(LocalManagedRunti
> 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.jav
> 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:4988
> )
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionar
> 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(JDBCStoreManager
> .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/finerac
> 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:418
> ) ~[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(AbstractPlatformTransactionM
> 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(FixedDepositAccountsApiResource
> .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.jav
> 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(WebComponent
> .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:201)
> ~[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(SecurityContextPersistenceFi
> 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(FilterChain
> 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(StandardWrapperVa
> lve.java:220)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> lve.java:122)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticat
> 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(StandardEngineValv
> e.java:116)
> [tomcat-embed-core-7.0.54.jar:7.0.54]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :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(JIoEndpoint
> .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(TaskThr
> 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.java
> :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(LocalManagedRunti
> 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.jav
> 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:4988
> )
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionar
> 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(JDBCStoreManager
> .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:rmannibucau@gmail.com]
> Sent: 29 September 2016 17:03
> To: dev@openjpa.apache.org
> 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"
> <na...@confluxtechnologies.com> 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.
> >
>
>
>
RE: [OpenJPA] Issue with Entity Delete - Need help
Posted by Shaik Nazeer <na...@confluxtechnologies.com>.
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:rmannibucau@gmail.com]
Sent: 03 October 2016 15:34
To: dev@openjpa.apache.org
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 <
<ma...@confluxtechnologies.com> nazeer.shaik@confluxtechnologies.com>:
> 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 [ <ma...@gmail.com> mailto:rmannibucau@gmail.com]
> Sent: 03 October 2016 15:16
> To: <ma...@openjpa.apache.org> dev@openjpa.apache.org
> 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 <
> <ma...@confluxtechnologies.com> nazeer.shaik@confluxtechnologies.com>:
>
> > 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 [ <ma...@gmail.com> mailto:rmannibucau@gmail.com]
> > Sent: 29 September 2016 22:34
> > To: <ma...@openjpa.apache.org> dev@openjpa.apache.org
> > 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 <
> > <ma...@confluxtechnologies.com> nazeer.shaik@confluxtechnologies.com>:
> >
> > > 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 [ <ma...@gmail.com> mailto:rmannibucau@gmail.com]
> > > Sent: 29 September 2016 17:03
> > > To: <ma...@openjpa.apache.org> dev@openjpa.apache.org
> > > 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"
> > > < <ma...@confluxtechnologies.com> nazeer.shaik@confluxtechnologies.com> 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.
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
Re: [OpenJPA] Issue with Entity Delete - Need help
Posted by Romain Manni-Bucau <rm...@gmail.com>.
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> | 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 12:00 GMT+02:00 Shaik Nazeer <
nazeer.shaik@confluxtechnologies.com>:
> 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:rmannibucau@gmail.com]
> Sent: 03 October 2016 15:16
> To: dev@openjpa.apache.org
> 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 <
> nazeer.shaik@confluxtechnologies.com>:
>
> > 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:rmannibucau@gmail.com]
> > Sent: 29 September 2016 22:34
> > To: dev@openjpa.apache.org
> > 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 <
> > nazeer.shaik@confluxtechnologies.com>:
> >
> > > 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:rmannibucau@gmail.com]
> > > Sent: 29 September 2016 17:03
> > > To: dev@openjpa.apache.org
> > > 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"
> > > <na...@confluxtechnologies.com> 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.
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
RE: [OpenJPA] Issue with Entity Delete - Need help
Posted by Shaik Nazeer <na...@confluxtechnologies.com>.
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:rmannibucau@gmail.com]
Sent: 03 October 2016 15:16
To: dev@openjpa.apache.org
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 <
nazeer.shaik@confluxtechnologies.com>:
> 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:rmannibucau@gmail.com]
> Sent: 29 September 2016 22:34
> To: dev@openjpa.apache.org
> 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 <
> nazeer.shaik@confluxtechnologies.com>:
>
> > 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:rmannibucau@gmail.com]
> > Sent: 29 September 2016 17:03
> > To: dev@openjpa.apache.org
> > 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"
> > <na...@confluxtechnologies.com> 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.
> > >
> >
> >
> >
>
>
>
Re: [OpenJPA] Issue with Entity Delete - Need help
Posted by Romain Manni-Bucau <rm...@gmail.com>.
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 <
nazeer.shaik@confluxtechnologies.com>:
> 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:rmannibucau@gmail.com]
> Sent: 29 September 2016 22:34
> To: dev@openjpa.apache.org
> 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 <
> nazeer.shaik@confluxtechnologies.com>:
>
> > 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_open
> > 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:418
> > ) ~[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(AbstractPlatformTransactionM
> > 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(FixedDepositAccountsApiResource
> > .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.jav
> > 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(WebComponent
> > .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:201)
> > [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(SecurityContextPersistenceFi
> > 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(FilterChain
> > 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(StandardWrapperVa
> > lve.java:220)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> > lve.java:122)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticat
> > 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(StandardEngineValv
> > e.java:116)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> > :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(JIoEndpoint
> > .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(TaskThr
> > 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.java
> > :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(LocalManagedRunti
> > 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.jav
> > 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:4988
> > )
> > ~[openjpa-all-2.4.1.jar:2.4.1]
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionar
> > 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(JDBCStoreManager
> > .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/finerac
> > 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:418
> > ) ~[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(AbstractPlatformTransactionM
> > 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(FixedDepositAccountsApiResource
> > .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.jav
> > 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(WebComponent
> > .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:201)
> > ~[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(SecurityContextPersistenceFi
> > 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(FilterChain
> > 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(StandardWrapperVa
> > lve.java:220)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> > lve.java:122)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticat
> > 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(StandardEngineValv
> > e.java:116)
> > [tomcat-embed-core-7.0.54.jar:7.0.54]
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> > :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(JIoEndpoint
> > .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(TaskThr
> > 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.java
> > :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(LocalManagedRunti
> > 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.jav
> > 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:4988
> > )
> > ~[openjpa-all-2.4.1.jar:2.4.1]
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionar
> > 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(JDBCStoreManager
> > .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:rmannibucau@gmail.com]
> > Sent: 29 September 2016 17:03
> > To: dev@openjpa.apache.org
> > 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"
> > <na...@confluxtechnologies.com> 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.
> > >
> >
> >
> >
>
>
>