Unable to Launch Client java.lang.OutOfMemoryError: Java heap space Protocol violation

Document ID : KB000088062
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: null
java.sql.SQLException: Protocol violation

ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: null
java.lang.OutOfMemoryError: Java heap space

Users receive a connection refused error message when attempting to log into the Application Manager client.

A review of the $AW_HOME/log/RmiServer log files show the following errors.

06:56:01.668 MSM:read767-EVNCPAP1: .MasterSocketManager: cleanupSocket (sync) 3b353bbb[TLS_DH_anon_WITH_AES_128_CBC_SHA: Socket[addr=10.83.84.101,port=12120,localport=6101]]
ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: null
java.sql.SQLException: Protocol violation
Followed by
06:56:01.672 OCh: null ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: Java heap space
Null

This error message occurred when a user previously submitted a large history query from the GUI.

Investigation

This can be confirmed in the log files by analyzing the following sections of the RmiServer log.

A request is made to query job history form the gui (this is the same sql we ran outside of AM)

05:15:18.881 CR5 1.123.123.12:45489: .DBAccess: getSqlData() sID-6838990 APPWORX SELECT DISTINCT * from AW_JH_VIEW WHERE 1 = 1 AND (so_job_finished BETWEEN TO_DATE('2017-02-01 13:24:00','YYYY-MM-DDHH24:MI:SS') AND TO_DATE('2017-03-30 13:24:00','YYYY-MM-DD HH24:MI:SS'))order by so_job_finished desc

This launches the history request with the following sequence number (SeqNo 24228).

There is a large time gap in the logs containing the following error message.

06:56:01.575 CR51.123.123.12:45489: AwE-9999
06:56:01.575 CR51.123.123.12:45489: SQL Error: 17401
06:56:01.668 MSM:read767-EVNCPAP1: .MasterSocketManager: cleanupSocket (sync) 3b353bbb[TLS_DH_anon_WITH_AES_128_CBC_SHA: Socket[addr=automic.com/10.83.84.101,port=12120,localport=6101]]
ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: null
java.sql.SQLException: Protocol violation
Followed by
06:56:01.672 OCh: null ErrorMsg: AwE-9999 Internal error (3/29/17 6:56 AM)
Details: Java heap space
Null

Note that sequence number 24228 is being referenced in the error which indicates that the error is coming from the history query previously launched.

06:56:01.743 CR61.123.123.12:45489: .C: invoke getJobUpdates com.appworx.server.data.AxRmiServer
ErrorMsg: AwE-5103 network socket error (3/29/17 6:56 AM)
Details: Response error SeqNo 24228 Agent 4.56.22.85:1099 Master Client service clientServices sessionID 5953 Method getHistoryQuery [com.appworx.shared.data.JobFilter@55821a8f, null]
javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Connection reset
 
 
Environment:
OS Version: N/A
Cause:
Cause type:
By design
Root Cause: This issue is caused by hitting a java memory resource limit when submitting a large history query.
Resolution:
Narrow the query results by:
  1. limiting the initial query so fewer rows are returned
 OR
  1. ​run the query outside of Applications Manager


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A