Adding Eranda Regards, Firzhan
On Fri, Aug 1, 2014 at 1:26 AM, Firzhan Naqash <firz...@wso2.com> wrote: > > > Hi, > > > When we tried to use the Ndata source in BPS we encountered with following > error[2]. Already there has been an issue also logged in Jira sometime ago > [1]. > > This error occurs when the user tried to upload a bpel package ( or Human > Task ) for the first time. When I investigated the issue I made out > following findings. > > > The flow of the operations related to committing a package in OpenJPA can > be listed like this. > > > 1. Initially OpenJPA inserts a row with sequence_Id zero and > sequence_value one in to the OpenJPA_SEQUENCE_TABLE index. ( This operation > is done to build the index structure for the first time ) > 2. There after OpenJPA closes the connection. Just before the > connection getting added to connection pool, > ConnectionRollbackOnReturnInterceptor invokes the rollback operation since > defaultAutoCommit variable is not set in the bps-datasource.xml. > Therefore the row inserted to the OpenJPA_SEQUENCE_TABLE got cleared out. > 3. Then OpenJPA tries to update the value of the sequence_value with a > generated id. But since the cached row has been rolled back by the > Interceptor, OpenJPA throws an error and aborts the commit operation. > > > How can this issue can be sorted? Are there Any possible workarounds for > this? > > [1] https://wso2.org/jira/browse/BPS-185 > > [2] > > [2014-07-31 12:45:58,630] WARN {Transaction} - Unexpected > exception from beforeCompletion; transaction will roll back > > <openjpa-2.2.0-wso2v1-r128166:129108 nonfatal user error> > org.apache.openjpa.persistence.InvalidStateException: Attempt to commit a > null javax.transaction.Transaction. Some application servers set the > transaction to null if a rollback occurs. > > at > org.apache.openjpa.kernel.BrokerImpl.setRollbackOnlyInternal(BrokerImpl.java:1654) > > > at > org.apache.openjpa.kernel.BrokerImpl.setRollbackOnly(BrokerImpl.java:1640) > > at > org.apache.openjpa.kernel.DelegatingBroker.setRollbackOnly(DelegatingBroker.java:981) > > > at > org.apache.openjpa.persistence.EntityManagerImpl.setRollbackOnly(EntityManagerImpl.java:631) > > > at > org.apache.openjpa.persistence.PersistenceExceptions$2.translate(PersistenceExceptions.java:77) > > > at > org.apache.openjpa.kernel.BrokerImpl.translateManagedCompletionException(BrokerImpl.java:2060) > > > at > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1994) > > at > org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:514) > > > at > org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:498) > > > at > org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:400) > > > at > org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:257) > > > at > org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:238) > > > at > org.apache.ode.store.jpa.DbConfStoreConnectionFactory.commitTransaction(DbConfStoreConnectionFactory.java:86) > > > at > org.wso2.carbon.bpel.core.ode.integration.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:735) > > > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > > > at java.lang.Thread.run(Thread.java:662) > > [2014-07-31 12:45:58,631] ERROR > {org.wso2.carbon.bpel.core.ode.integration.store.ProcessStoreImpl} - > DbError > > java.lang.RuntimeException: java.lang.IllegalStateException: No > transaction associated with current thread > > at > org.apache.ode.store.jpa.DbConfStoreConnectionFactory.rollbackTransaction(DbConfStoreConnectionFactory.java:97) > > > at > org.wso2.carbon.bpel.core.ode.integration.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:741) > > > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > > > at java.lang.Thread.run(Thread.java:662) > > Caused by: java.lang.IllegalStateException: No transaction associated with > current thread > > at > org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:247) > > > at > org.apache.ode.store.jpa.DbConfStoreConnectionFactory.rollbackTransaction(DbConfStoreConnectionFactory.java:95) > > > ... 6 more > > [2014-07-31 12:45:58,631] ERROR > {org.wso2.carbon.bpel.core.ode.integration.store.TenantProcessStoreImpl} - > BPEL Package deployment failed at ODE layer. Possible cause: DbError > > org.apache.ode.bpel.iapi.ContextException: DbError > > at > org.wso2.carbon.bpel.core.ode.integration.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:771) > > > at > org.wso2.carbon.bpel.core.ode.integration.store.ProcessStoreImpl.onBPELPackageDeployment(ProcessStoreImpl.java:328) > > > > > > > > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev