Error Message :
AwE-5001 Database Query Error
java.sql.SQLRecoverableException: No more data to read from socket
There is a very rare problem where the RMI process fails to start and simultaneously disconnects from the database due to an Oracle core dump. The above error is seen in the RmiServer.log.
Oracle alert log shows an error similar to:
Root Cause: This issue is related to a change made in Oracle version 22.214.171.124.
OS Version: N/A
Please contact Oracle for additional information regarding this parameter.
Fix Status: No Fix
Add the parameter "alter session set "_optimizer_unnest_all_subqueries"=false;" to the AW_MASTER_STMTS table and restart RMI process.