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

book

Article ID: 6746

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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

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]".  

Environment

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

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.