My Oracle Support Banner

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 JUNE 29, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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:

ERROR1

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)

ERROR2

$Object $Objectname was deleted by another user.

ERROR3

Event Code EEQEN-2830-7

ERROR4

Runtime error 231 at ##########


STEPS

The issue can be reproduced at will with the following steps:

  1. Configure an Oracle Database RAC.
  2. Configure Cloud Connect to connect to the RAC using short format or long format of RAC URL (reference KM Document 1192650.1).
  3. Connect P6 Professional to cloud connect and login.
  4. Shutdown the primary node processing requests in the RAC.
  5. Note the error which occurs next SQL statement executed from P6 Professional while using cloud connect.


EXPECTED OUTCOME

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.