SAP Knowledge Base Article - Preview

2823870 - Workload analyzer running out of user connections while performing a replay - SAP ASE

Symptom

  • User connections are not being freed up
  • Workload analyzer does not seem to be closing / freeing up connections 
  • Following exception is reported, when all local ports are used up:

    [ERROR] [ReplayEngine                                 ] [Thread-218] - 2036 create Socket failed
    java.net.NoRouteToHostException: Cannot assign requested address (Address not available) (local port 0 to address 0:0:0:0:0:0:0:0, remote port 9953 to address 99.99.99.99 (hostname))
                at java.net.PlainSocketImpl.socketConnect(Native Method)
                at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
                at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
                at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
                at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
                at java.net.Socket.connect(Socket.java:857)
                at java.net.Socket.connect(Socket.java:794)
                at java.net.Socket.<init>(Socket.java:690)
                at java.net.Socket.<init>(Socket.java:467)
                at com.sybase.workload.replay.control.ReplayControlThread.createSocket(ReplayControlThread.java:473)
                at com.sybase.workload.replay.control.ReplayControlThread.buildSessionState(ReplayControlThread.java:521)
                at com.sybase.workload.replay.control.ReplayControlThread.run(ReplayControlThread.java:119)Remove timestamps and extraneous information from error messages. Connection and server names must be generic

     
  • Another possible exception reported is:
    [ERROR] [ReplayEngine                                 ] [pool-5-thread-205] - ReplayThread->%s,%s Thread meets uncheckExp
    java.lang.ArrayIndexOutOfBoundsException: while trying to load from index 1 of an object array with length 1, loaded from local variable '_data'
                at com.sybase.workload.replay.replay.ReplayThread.analyzeResponse(ReplayThread.java:675)
                at com.sybase.workload.replay.replay.ReplayThread.isLastBuffer(ReplayThread.java:594)
                at com.sybase.workload.replay.replay.ReplayThread.recieveTDSPackageToASEServer(ReplayThread.java:524)
                at com.sybase.workload.replay.replay.ReplayThread.receiveTDS(ReplayThread.java:364)
                at com.sybase.workload.replay.replay.ReplayThread.sendTDSPackageToASEServer(ReplayThread.java:226)
                at com.sybase.workload.replay.replay.ReplayThread.run(ReplayThread.java:71)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                at java.lang.Thread.run(Thread.java:836) 
     
  • Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 and later
  • Workload Analyzer
  • SAP ASE Cockpit

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR819766, CR#819766, 819766, ArrayIndexOutOfBoundsException , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.