3201385 - Troubleshooting SQL Errors and Connection Interruptions in SAP Systems

The transfer of PO messages is interrupted, error:

SQL error occurred on connection sapx06-00:X06:SAPJAVA1: code={0,number,integer}, state="08006", message="Connection to database server lost; check server and network status [System error: java.io.IOException: java.lang.OutOfMemoryError: Direct buffer memory]";
SQL statement is "INSERT INTO "BC_MSG" ("MSG_ID","DIRECTION","MSG_BYTES","PCI_KEY_NAME","TIMES_FAILED","SENT_RECV_TIME","STATUS","CONN_NAME","MSG_TYPE","REF_TO_MSG_ID","ADDRESS","TRANSPORT","CREDENTIAL","PP_USER","PP_HASH","TRAN_HEADER","MSG_PROTOCOL","CORRELATION_ID","SEQUENCE_ID","SCHEDULE_TIME","PERSIST_UNTIL","FROM_PARTY_NAME","FROM_PARTY_TYPE","TO_PARTY_NAME","TO_PARTY_TYPE","FROM_SERVICE_NAME","FROM_SERVICE_TYPE","TO_SERVICE_NAME","TO_SERVICE_TYPE","ACTION_NAME","ACTION_TYPE","SEQUENCE_NBR","DELIVERY_SEMANTICS","VALID_UNTIL","NODE","DSR_PASSPORT","RETRIES","RETRY_INTERVAL","BYTES_LENGTH","BYTES_COMPRESSED","UNCOMPRESSED_SIZE","PRIORITY_TYPE","PRIORITY","STAGE","MSG_CLASS","PARENT_MSG_ID","RECV_ACTION_NAME","RECV_ACTION_TYPE","SCENARIO_ID","SUB_SEQ","ROOT_MSG_ID") VALUES (?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)".-
-
SQL error occurred on connection Thread[XI SOAP[SOAP_Sender/Intermediate/]_89610,5,Dedicated_Application_Thread], SQLException was thrown during connection rollback, Connection: com.sap.sql.jdbc.direct.DirectConnection@b21fee0. One more attempt to rollback the connection will be perfromed.: code={0,number,integer}, state="08006", message="Connection to database server lost; check server and network status [System error: null]".
-
SQL error occurred on connection Thread[XI SOAP[SOAP_Sender/Intermediate/]_89610,5,Dedicated_Application_Thread], SQLException was thrown during connection rollback, Connection: com.sap.sql.jdbc.direct.DirectConnection@b21fee0. One more attempt to rollback the connection will be perfromed.: code={0,number,integer}, state="08006", message="Connection to database server lost; check server and network status [System error: null]".
-
FATAL SQL error occurred on connection sapx06-00:X06:SAPJAVA1: code={0,number,integer}, state="<null>", message="Thread[XI SOAP[SOAP_Sender/Intermediate/]_89610,5,Dedicated_Application_Thread], SQLException was thrown during the second attempt to rollback the connection, Connection: com.sap.sql.jdbc.direct.DirectConnection@b21fee0. No more attempts to rollback the connection will be perfromed.
=> (-708,08006,Connection to database server lost; check server and network status [System error: null])";
SQL statement is "ROLLBACK".
-
Exception of type com.sap.sql.log.OpenSQLException caught: Exception of type com.sap.db.jdbc.exceptions.SQLNonTransientConnectionExceptionSapDB caught: Connection to database server lost; check server and network status [System error: java.io.IOException: java.lang.OutOfMemoryError: Direct buffer memory]..

SQL error, SAP, JDBC driver, Connection interruption, Direct buffer memory, OutOfMemoryError, nonBlockingIO, MaxDirectMemorySize, JDBC traces, Database server, Network status, Connection rollback, SAPJAVA1, BC_MSG, SQLNonTransientConnectionExceptionSapDB, SQL statement, JVM option