SQL Exception error produced when CA Workload Automation DE access the Oracle database

Document ID : KB000006746
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

The CA Workload Automation DE may experience a SQL exception in Oracle database during normal operations.  The exception is recoverable, but it may generate SNMP messages for the DE administrator and other users.  The exception can be seen in the tracelog, and may be similar to this example.

..... [relationaldatabase] [ERROR] SS.sequential_event_trigger_28072: [.....] SQL Exception for query: SELECT 1 FROM .....; the exception is: No more data to read from socket

java.sql.SQLRecoverableException: No more data to read from socket

at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:456)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

..... [relationaldatabase] : [......] SQLException of SQLCode: 17410 SQLState: 08000 translated to null

..... [relationaldatabase] : [......] No translation available. Generating DatabaseException

..... [relationaldatabase] : [......] rollback SQLCode: 17410 SQLState: 08000 Message: No more data to read from socket

Environment:
CA Workload Automation R11.3 or R12Oracle 12c Release 1, 12.1.0.2
Cause:

This error has been identified as an Oracle database defect.  The Oracle defect number is  21522416, and is referred to as Bug "21522416 : ORA-7445 [KGHALP+51] [SIGSEGV]".  

Resolution:

It is recommended to contact Oracle and apply the latest patch to the database.  CA recommends to apply all latest OS and database patches as suggested by the vendor.