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
..... [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
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]".
CA Workload Automation R11.3 or R12Oracle 12c Release 1, 184.108.40.206
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.