on 12-15-2014 10:21 AM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
97 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.