Oracle RAC Database Connected to P6 Pro Client Cloud Connect Fails and Causes Error: "No more data to read from socket" and/or Additional Errors
(Doc ID 2414468.1)
Last updated on FEBRUARY 27, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
When using P6 Professional through Cloud Connect, where Cloud Connect is configured for connection to an Oracle Real Application Cluster (RAC) (using either short format or long format of RAC Java Database Connectivity (JDBC) Uniform Resource Locator (URL) in both the brebootstrap.xml file and the configuration being read by Cloud Connect), the following error occurs when one primary node in the RAC processing requests goes down:
TCCustomVirtualRow.ExistInDB: table=(WBS), Exception=(Error executing query. Error: No more data to read from socket
Session -1 -- <privileged> user>::username(PM.exe) -- UTF-8
DB Connetion oracle.jdbc.driver.T4CConnection
Require type: GET_SQL_RESULT
Command tesxt $SQLStatement)
$Object $Objectname was deleted by another user.
Event Code EEQEN-2830-7
Runtime error 231 at ##########
The issue can be reproduced at will with the following steps:
- Configure an Oracle Database RAC.
- Configure Cloud Connect to connect to the RAC using short format or long format of RAC URL (reference KM Document 1192650.1).
- Connect P6 Professional to cloud connect and login.
- Shutdown the primary node processing requests in the RAC.
- Note the error which occurs next SQL statement executed from P6 Professional while using cloud connect.
When logged into P6 Professional using a Cloud Alias and the RAC node it is directed to goes down, the session should be able to failover to an additional running instance in the RAC without a need to logout/login or restart the managed server / deployment.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document