A hang in AF

[Former Member]

Hi Gurus,

I have 4 external systems connected to PI 7.0 SP12 on MSCA .

One external system is using soap adapter, while the others ftp adapter.

I want to send 3.000 MATMASes to them at once.

I dont have any problmes on IE (rounting, mapping is fast and succesfull),

but on the Java side the Adapter Engine hangs somehow.

When this occur I cannot login to Visual Administrator and nither to Runtime Workbench anymore.. (401 Unautorized.)

The server0 directory is filling up very quickly with defaultTrace.trc files

I can solve the situation only by restart the java part.

Then I need to cancel all messages.

Please help.

I see in defaultTrace.trc the following:

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7185 - 630]/>

<!NAME[./log/defaultTrace.trc]/>

<!PATTERN[defaultTrace.trc]/>

<!FORMATTER[com.sap.tc.logging.ListFormatter]/>

<!ENCODING[UTF8]/>

<!FILESET[7, 20, 10485760]/>

<!PREVIOUSFILE[defaultTrace.6.trc]/>

<!NEXTFILE[defaultTrace.8.trc]/>

<!LOGHEADER[END]/>

#1.5 #00145ED86134002C00133618000011B000043E7F30D9CB0B#1194615908452#com.sap.aii.adapter.file.util.locking.LockManager#sap.com/com.sap.aii.af.app#com.sap.aii.adapter.file.util.locking.LockManager.acquireLock(String, int)#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [2cffffffb076ffffffca006a76]###6249a8378ec811dc8e4700145ed86134#XI XI2File[FTP_Receiver_Material_TZ012/AGRINA_TZ012_TEST/]_9541##0#0#Error##Java###Received TechnicalLockException while trying to acquire lock for key #2#com.sap.engine.frame.core.locking.TechnicalLockException: Cannot lock [2007110911562472200000sapxi43....................749762250, $XIAFFileHandle, remote:///dk_dxd_agrina/CDE/XI/agrina/TZ012/material/material_20071109-144508-452.txt, X]; table-overflow (returncode = 16).#remote:///dk_dxd_agrina/CDE/XI/agrina/TZ012/material/material_20071109-144508-452.txt#

#1.5 #00145ED86134002C0013361A000011B000043E7F30D9E3DF#1194615908452#com.sap.engine.core.locking.AbstractLockingManagerImpl#sap.com/com.sap.aii.af.app#com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(owner, name, argument, mode, timeout)#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [2cffffffb076ffffffca006a76]###6249a8378ec811dc8e4700145ed86134#XI XI2File[FTP_Receiver_Material_TZ012/AGRINA_TZ012_TEST/]_9541##0#0#Error#1#/System/Server#Plain###Cannot lock [2007110911562472200000sapxi43....................749762250, $XIAFFileHandle, remote:///dk_dxd_agrina/CDE/XI/agrina/TZ012/material/material_20071109-144508-452.txt, X]; table-overflow (returncode = 16).#

#1.5 #00145ED86134002C0013361B000011B000043E7F30D9E430#1194615908452#com.sap.engine.core.locking.AbstractLockingManagerImpl#sap.com/com.sap.aii.af.app#com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(owner, name, argument, mode, timeout)#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [2cffffffb076ffffffca006a76]###6249a8378ec811dc8e4700145ed86134#XI XI2File[FTP_Receiver_Material_TZ012/AGRINA_TZ012_TEST/]_9541##0#0#Error##Plain###com.sap.engine.frame.core.locking.TechnicalLockException: Cannot lock [2007110911562472200000sapxi43....................749762250, $XIAFFileHandle, remote:///dk_dxd_agrina/CDE/XI/agrina/TZ012/material/material_20071109-144508-452.txt, X]; table-overflow (returncode = 16).#

#1.5 #00145ED86134002C0013361C000011B000043E7F30D9E469#1194615908452#com.sap.engine.core.locking.AbstractLockingManagerImpl#sap.com/com.sap.aii.af.app#com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(owner, name, argument, mode, timeout)#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [2cffffffb076ffffffca006a76]###6249a8378ec811dc8e4700145ed86134#XI XI2File[FTP_Receiver_Material_TZ012/AGRINA_TZ012_TEST/]_9541##0#0#Error##Plain###com.sap.engine.frame.core.locking.TechnicalLockException: Cannot lock [2007110911562472200000sapxi43....................749762250, $XIAFFileHandle, remote:///dk_dxd_agrina/CDE/XI/agrina/TZ012/material/material_20071109-144508-452.txt, X]; table-overflow (returncode = 16).

at com.sap.engine.core.locking.impl3.LockingManagerImpl.lockInternal(LockingManagerImpl.java:277)

at com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(AbstractLockingManagerImpl.java:421)

at com.sap.engine.core.locking.AbstractLockingManagerImpl.lock(AbstractLockingManagerImpl.java:441)

at com.sap.engine.core.locking.ServerInternalLockingImpl.lock(ServerInternalLockingImpl.java:42)

at com.sap.aii.adapter.file.util.locking.LockManager.acquireLock(LockManager.java:241)

at com.sap.aii.adapter.file.util.locking.LockManager.acquireLock(LockManager.java:170)

at com.sap.aii.adapter.file.util.locking.LockManager.acquireLock(LockManager.java:148)

at com.sap.aii.adapter.file.io.FileHandle.acquireLock(FileHandle.java:92)

at com.sap.aii.adapter.file.handler.FtpTargetHandlerImpl.getTargetFile(FtpTargetHandlerImpl.java:54)

at com.sap.aii.adapter.file.XI2File.processMessage(XI2File.java:655)

at com.sap.aii.adapter.file.XI2File.dispatchMessage(XI2File.java:425)

at com.sap.aii.adapter.file.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:211)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:252)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:175)

at com.sap.aii.af.mp.module.ModuleLocalLocalObjectImpl0_1.process(ModuleLocalLocalObjectImpl0_1.java:103)

at com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:264)

at com.sap.aii.af.mp.processor.ModuleProcessorLocalLocalObjectImpl0_0.process(ModuleProcessorLocalLocalObjectImpl0_0.java:103)

at com.sap.aii.af.listener.AFWListenerBean.onMessage(AFWListenerBean.java:343)

at com.sap.aii.af.listener.AFWListenerLocalObjectImpl0_0.onMessage(AFWListenerLocalObjectImpl0_0.java:103)

at com.sap.aii.af.ra.ms.impl.ServicesImpl.deliver(ServicesImpl.java:276)

at com.sap.aii.adapter.xi.ms.XIEventHandler.onDeliver(XIEventHandler.java:1049)

at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.processMessage(ReceiveConsumer.java:291)

at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.onMessage(ReceiveConsumer.java:78)

at com.sap.aii.af.ra.ms.impl.core.queue.Queue.run(Queue.java:850)

at com.sap.aii.af.ra.ms.runtime.MSWorkWrapper.run(MSWorkWrapper.java:56)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: java.lang.Exception: class com.sap.bc.krn.enqu.EnquServerException reported: SERVER ERROR:

Code...: 16

Name...: ENQ_OVERFLOW

Text...: table overflow

at com.sap.engine.core.locking.impl3.LockingManagerImpl.transformToExceptionForApplication(LockingManagerImpl.java:697)

at com.sap.engine.core.locking.impl3.LockingManagerImpl.lockInternal(LockingManagerImpl.java:276)

... 28 more

[Former Member]

Solved in Note 1079221.

[Former Member]

Hi Agasthuri,

Thank you for quick reply, and please ignore my previous confused post - I was doing too many things at once.

The questions that I am trying to solve now are.

1. Does the File Adapter have a Quality of service itself ?

Where this can be set and to what value (EO or EOIO) in case we have lot

of small messages?

2. What can be done to avoid TechnicalLockException and ENQ_OVERFOLOW ?

3. Is this mainly a problem in java or in abab stack. Where to fix configuration

(RZxx or Visual Administrator) ?

Can you give ma a hint, please?

Thanx, Janos

[Former Member]

Hi,

I use Quality of service=EO.

Can you pols explain what you mean by Table space. On MSSQL is checked and ok.

What do you mean by TechnicalLockException. I didnt see any pop ups.

Thanks.

[agasthuri_doss]

Hi,

1) Check whethere Table space is available

2) TechnicalLockException pops out

3) Is your File Adapter EOIO

Regards

Agasthuri Doss