cancel
Showing results for 
Search instead for 
Did you mean: 

Archiving Rollback exception

Former Member
0 Kudos

Hi,

When running archive it terminates showing a message about JTA and rollback against the odspool.

Does anyone know what this means and how it can be solved?

Best regards,

Johan

Setting Trace level:1
Error executing batch process com.sap.me.demand.ArchiveGenRad
java.rmi.RemoteException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1445)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback(TXR_TransactionImpl.java:1153)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$BeanStateless.error(TransactionAttributeHandler.java:514)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:131)
at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:39)
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:164)
at com.sun.proxy.$Proxy1147.archiveBatchSFC(Unknown Source)
at sun.reflect.GeneratedMethodAccessor12821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:240)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:462)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)
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:999)
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 odsPool cannot rollback its transaction branch and returns an unknown XA status. Exception is javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***".
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1328)
... 32 more
Caused by: javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:545)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.rollback(SQLServerXAResource.java:713)
at com.sap.sql.jdbc.vendor.VendorXAResource.rollback(VendorXAResource.java:150)
at com.sap.engine.services.dbpool.spi.XAManagedConnectionImpl.rollback(XAManagedConnectionImpl.java:174)
at com.sap.engine.services.ts.jta.impl2.XAResourceWrapper.rollback(XAResourceWrapper.java:82)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1258)
... 32 more

javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:135)
at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:39)
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:164)
at com.sun.proxy.$Proxy1147.archiveBatchSFC(Unknown Source)
at sun.reflect.GeneratedMethodAccessor12821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:240)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:462)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)
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:999)
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 : 76046179 ) in rollback.
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1445)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback(TXR_TransactionImpl.java:1153)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$BeanStateless.error(TransactionAttributeHandler.java:514)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:131)
... 29 more
Caused by: com.sap.engine.interfaces.transaction.SAPHeuristicHazardException: ResourceManager odsPool cannot rollback its transaction branch and returns an unknown XA status. Exception is javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***".
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1328)
... 32 more
Caused by: javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:545)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.rollback(SQLServerXAResource.java:713)
at com.sap.sql.jdbc.vendor.VendorXAResource.rollback(VendorXAResource.java:150)
at com.sap.engine.services.dbpool.spi.XAManagedConnectionImpl.rollback(XAManagedConnectionImpl.java:174)
at com.sap.engine.services.ts.jta.impl2.XAResourceWrapper.rollback(XAResourceWrapper.java:82)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1258)
... 32 more

java.rmi.RemoteException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1445)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback(TXR_TransactionImpl.java:1153)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$BeanStateless.error(TransactionAttributeHandler.java:514)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:131)
at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:39)
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:164)
at com.sun.proxy.$Proxy1147.archiveBatchSFC(Unknown Source)
at sun.reflect.GeneratedMethodAccessor12821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:240)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:462)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)
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:999)
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 odsPool cannot rollback its transaction branch and returns an unknown XA status. Exception is javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***".
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1328)
... 32 more
Caused by: javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:545)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.rollback(SQLServerXAResource.java:713)
at com.sap.sql.jdbc.vendor.VendorXAResource.rollback(VendorXAResource.java:150)
at com.sap.engine.services.dbpool.spi.XAManagedConnectionImpl.rollback(XAManagedConnectionImpl.java:174)
at com.sap.engine.services.ts.jta.impl2.XAResourceWrapper.rollback(XAResourceWrapper.java:82)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1258)
... 32 more

javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( JTA Transaction : 76046179 ) in rollback.
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:135)
at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:39)
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:164)
at com.sun.proxy.$Proxy1147.archiveBatchSFC(Unknown Source)
at sun.reflect.GeneratedMethodAccessor12821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:240)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:462)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)
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:999)
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 : 76046179 ) in rollback.
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1445)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback(TXR_TransactionImpl.java:1153)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$BeanStateless.error(TransactionAttributeHandler.java:514)
at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$TransactionAttributeErrorsHandler.error(TransactionAttributeHandler.java:131)
... 29 more
Caused by: com.sap.engine.interfaces.transaction.SAPHeuristicHazardException: ResourceManager odsPool cannot rollback its transaction branch and returns an unknown XA status. Exception is javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***".
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1328)
... 32 more
Caused by: javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:545)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.rollback(SQLServerXAResource.java:713)
at com.sap.sql.jdbc.vendor.VendorXAResource.rollback(VendorXAResource.java:150)
at com.sap.engine.services.dbpool.spi.XAManagedConnectionImpl.rollback(XAManagedConnectionImpl.java:174)
at com.sap.engine.services.ts.jta.impl2.XAResourceWrapper.rollback(XAResourceWrapper.java:82)
at com.sap.engine.services.ts.jta.impl2.TXR_TransactionImpl.rollback_internal(TXR_TransactionImpl.java:1258)
... 32 more

at com.sap.engine.services.ejb3.runtime.impl.Actions_ComponentInterfaceProviderFactoriesInitialization$OldStyleRemoteViewConverter.convertThrowable(Actions_ComponentInterfaceProviderFactoriesInitialization.java:194)
at com.sap.engine.services.ejb3.runtime.impl.AbstractComponentInterfaceFactory.convertExceptionToClientView(AbstractComponentInterfaceFactory.java:171)
at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:169)
at com.sun.proxy.$Proxy1147.archiveBatchSFC(Unknown Source)
at sun.reflect.GeneratedMethodAccessor12821.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:240)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:462)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)
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:999)
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)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I found the problem and the solution by turning on SQL Trace.

One SFC was existing in AR_SFC table even though it was still available in WIP Tables.

The insert to AR_SFC was failing with a duplicate key error.

After removing the SFC from the AR_SFC table and re-starting the archive.bat file, everything is working again.

Br,

Johan

Answers (1)

Answers (1)

sergiy_katerinich
Active Contributor
0 Kudos

Hi Johan!

Usually it is about ODS transaction running longer than archive timeout specified in System Setup.

You are likely to be trying to process a lot of data at once. So, either increase the timeout or decrease the data chunk.

Sometimes there could be technical issues against DB connection.

Regards,

Sergiy

Former Member
0 Kudos

Hi Sergiy,

The error message comes directly (~2 seconds) after starting the archive.bat.

I anyway tried to both increase the timeout and decrease the data chunk, but
with no luck. The error still appear.

My feeling is that, according to the error message, have something to do with the DB connection
against the ODS Server. How can I troubleshoot this more?

Best regards,

Johan

sergiy_katerinich
Active Contributor
0 Kudos

If it happens right after the launch of the script, then it might be the case that the previous execution of the script failed for some reason, and this caused a lock from the stale distributed transaction hanging against ODS because of the failure of rollback.

When I faced such issue last time, I had to ask our DBA to manually delete the lock.

Maybe my explanation is not technically perfect but I hope your DBA can understand what and where to look at.

Regards,

Sergiy