cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Integration Builder Error While Opening Integrated Configuration

buddhika_krishantha
Active Participant

on ‎02-24-2016 11:43 AM

0 Kudos

Hi Friends,

I'm working with SAP Netweaver process integration 7.50. I'm getting following exception while opening integrated configuration in integration builder.

       " javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 5142 ) in rollback.

com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 5142 ) in rollback.

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1465)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.commitSecondPhase(TXR_TransactionImpl.java:777)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.commit(TXR_TransactionImpl.java:1152)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionManagerImpl.commit(TXR_TransactionManagerImpl.java:333)

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$Required.exit(TransactionAttributeHandler.java:284)

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.exit(TransactionAttributeHandler.java:115)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:58)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:191)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:23)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:172)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:99)

at com.sun.proxy.$Proxy1702.read(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:241)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:483)

at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:83)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:72)

at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:43)

at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:1055)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:59)

at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:55)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Caused by: com.sap.engine.interfaces.transaction.SAPHeuristicHazardException: ResourceManager Local RM com.sap.engine.services.dbpool.spi.CommonManagedConnectionImpl cannot rollback its transaction branch: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: java.sql.SQLException: JZ0C0: Connection is already closed..

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1266)

... 36 more

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: java.sql.SQLException: JZ0C0: Connection is already closed.

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.throwBaseResourceException(LocalTXManagedConnectionImpl.java:130)

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.rollback(LocalTXManagedConnectionImpl.java:442)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1253)

... 36 more

Caused by: java.sql.SQLException: JZ0C0: Connection is already closed.

at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:774)

at com.sybase.jdbc4.jdbc.SybConnection.checkConnection(SybConnection.java:3868)

at com.sybase.jdbc4.jdbc.SybConnection.getAutoCommit(SybConnection.java:1845)

at com.sap.sql.jdbc.basic.BasicConnection.getAutoCommit(BasicConnection.java:71)

at com.sap.sql.jdbc.direct.DirectPooledConnection.getAutoCommit(DirectPooledConnection.java:497)

at com.sap.sql.jdbc.common.CommonPooledConnection.setAutoCommit(CommonPooledConnection.java:634)

at com.sap.sql.jdbc.common.CommonPooledConnection.raiseTransactionState(CommonPooledConnection.java:972)

at com.sap.sql.jdbc.common.CommonConnectionImpl.validate(CommonConnectionImpl.java:1500)

at com.sap.sql.jdbc.common.CommonConnectionImpl.rollback(CommonConnectionImpl.java:565)

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.rollback(LocalTXManagedConnectionImpl.java:440)

... 37 more

javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 5142 ) in rollback.

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.exit(TransactionAttributeHandler.java:125)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:58)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_MethodRetry.invoke(Interceptors_MethodRetry.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:191)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:23)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:25)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:17)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:138)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:172)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:99)

at com.sun.proxy.$Proxy1702.read(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:241)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:483)

at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:83)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:72)

at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:43)

at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:1055)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:59)

at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:55)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Caused by: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 5142 ) in rollback.

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1465)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.commitSecondPhase(TXR_TransactionImpl.java:777)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.commit(TXR_TransactionImpl.java:1152)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionManagerImpl.commit(TXR_TransactionManagerImpl.java:333)

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$Required.exit(TransactionAttributeHandler.java:284)

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.exit(TransactionAttributeHandler.java:115)

... 31 more

Caused by: com.sap.engine.interfaces.transaction.SAPHeuristicHazardException: ResourceManager Local RM com.sap.engine.services.dbpool.spi.CommonManagedConnectionImpl cannot rollback its transaction branch: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: java.sql.SQLException: JZ0C0: Connection is already closed..

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1266)

... 36 more

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: java.sql.SQLException: JZ0C0: Connection is already closed.

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.throwBaseResourceException(LocalTXManagedConnectionImpl.java:130)

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.rollback(LocalTXManagedConnectionImpl.java:442)

at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1253)

... 36 more

Caused by: java.sql.SQLException: JZ0C0: Connection is already closed.

at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:774)

at com.sybase.jdbc4.jdbc.SybConnection.checkConnection(SybConnection.java:3868)

at com.sybase.jdbc4.jdbc.SybConnection.getAutoCommit(SybConnection.java:1845)

at com.sap.sql.jdbc.basic.BasicConnection.getAutoCommit(BasicConnection.java:71)

at com.sap.sql.jdbc.direct.DirectPooledConnection.getAutoCommit(DirectPooledConnection.java:497)

at com.sap.sql.jdbc.common.CommonPooledConnection.setAutoCommit(CommonPooledConnection.java:634)

at com.sap.sql.jdbc.common.CommonPooledConnection.raiseTransactionState(CommonPooledConnection.java:972)

at com.sap.sql.jdbc.common.CommonConnectionImpl.validate(CommonConnectionImpl.java:1500)

at com.sap.sql.jdbc.common.CommonConnectionImpl.rollback(CommonConnectionImpl.java:565)

at com.sap.engine.services.dbpool.spi.LocalTXManagedConnectionImpl.rollback(LocalTXManagedConnectionImpl.java:440)

... 37 more

See error logs for details "   

Please help to solve this issue.



Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182412
Active Contributor
‎02-24-2016 2:58 PM
0 Kudos

Hi Buddhika,

May be you keep it idle for long time and try to open the object, at the time of opening the connection already closed you need to close the directory and reopen again.

Regards,

Praveen.

Show replies
Show replies
buddhika_krishantha
Active Participant
‎02-25-2016 4:25 AM
0 Kudos

Thanks both for your replies.

It's not because of idle. As soon as i open the Integration builder it shows the error. I checked with log also. It shows following error.

former_member186851
Active Contributor
‎02-24-2016 2:55 PM
0 Kudos

Try increasing the java heap size.

Show replies
Show replies
Ask a Question