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

• 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.

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

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