Hi Romain, Thank you very much for your time. Looks like, I am facing the same issue mentioned in the following JIRA issue. Any plans to resolve this?
https://issues.apache.org/jira/browse/OPENJPA-39 Thanks, Nazeer -----Original Message----- From: Romain Manni-Bucau [mailto:[email protected]] Sent: 29 September 2016 22:34 To: [email protected] Subject: Re: [OpenJPA] Issue with Entity Delete - Need help Didnt manage to reproduce with the build of provider but your exception is more an actual error with the DB state ( Cannot delete or update a parent row: a foreign key constraint fails) than a state issue To move forward the best is to isolate the issue in a smaller sample you can share on github or any public repo. Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber <http://www.tomitribe.com> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2016-09-29 14:40 GMT+02:00 Shaik Nazeer < [email protected]>: > Hi Romain, > > We don't travis CI configured for our repository. But it is easy to > configure the project locally. > Changes are available in the following branch. Instructions to run > integration tests are mentioned README.md > https://github.com/nazeer1100126/incubator-fineract/tree/fineract_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:[email protected]] > Sent: 29 September 2016 17:03 > To: [email protected] > Subject: Re: [OpenJPA] Issue with Entity Delete - Need help > > Do you have a failing unit test on github reproducing it? > > Le 29 sept. 2016 12:35, "nazeer" > <[email protected]> a écrit : > > > Hi all, > > > > I have verified and entity is not detached one. > > > > Thanks, > > Nazeer > > > > > > > > -- > > View this message in context: http://openjpa.208410.n2. > > nabble.com/OpenJPA-Issue-with-Entity-Delete-Need-help- > > tp7589735p7589738.html > > Sent from the OpenJPA Developers mailing list archive at Nabble.com. > > > > >
