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
Last updated on JUNE 29, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 126.96.36.199 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 RAC (using either short format or long format of RAC JDBC 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 -- privuser::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.
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