E1: JAS: Login Fails With Oracle Database RAC Failover (Doc ID 1908089.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When using two nodes on Oracle RAC, when node A goes down the users, working on web client, are not able to work.
E1 services have to be restarted before users can log in again.

All applications do not respond. If users log off and try to login again this error message appears in the e1root.log:

Extract from e1root_20130702_0_JAS_RAC.log
++++++++++++++++
02 lug 2013 11:54:59,309 [SEVERE] JDE - [JDBJ]            SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F986101 - Data Source[0] = SY910 java.sql.SQLRecoverableException: Non vi sono altri dati da leggere nel socket
02 lug 2013 11:54:59,465 [SEVERE] JDE - [BASE]            com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Non vi sono altri dati da leggere nel socket. java.sql.SQLRecoverableException: Non vi sono altri dati da leggere nel socket
++++++++++++++++

"Non vi sono altri dati da leggere nel socket" is the Italian version of "No more data to read from socket" message.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms