Errors: "Event Code SRE-2835-B" or "TCVirtualDBEngine.EndTransaction: Missing Begin Transaction" or "Exception=(Stream Read Error)" or "WBS Deleted by Another User" Using P6 Professional Through Cloud Connect Reconfigured for SSO/SAML (Doc ID 2192314.1)

Last updated on MAY 17, 2017

Applies to:

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

Symptoms

The following errors occur in P6 Professional when:

...once the SSO engine expiry settings are exceeded:

ERROR 1

TCCustomVirtualRow.ExistInDB: table=($table), Exception=(Stream read error), sql=($sql statement)

ERROR 2

WBS '$ProjectName' was deleted by another user.

ERROR 3

Event Code: SRE-2835-B
Message: Stream read error

ERROR 4

Exception Exception in module PM.exe at <address>.
TCVirtualDBEngine.EndTransaction: Missing Begin Transaction.

Note:

  • When the exceptions above occur, P6 Professional may hang until the application is forcefully closed.
  • The above exceptions can occur other alternate circumstances. and the symptoms in this document are specific to P6 Professional/Cloud Connect reconfigured for SSO AND ONLY WHEN EXCEEDING THE SSO EXPIRY PERIOD.
  • All cloud customers are not utilizing Cloud Connect/P6 Professional through SSO unless the environment has been reconfigured for SAML.  If the environment has not been reconfigured for SAML, cloud customers are authenticating through cloud connect and the ldap protocol connecting to an internal directory server.

 

STEPS

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

  1. Install an SSO application (Oracle Access Manager)
  2. Install a Web Server (Oracle HTTP Server)
  3. Configure a Webgate with the Web Server
  4. Configure the web server WebLogic proxy for cloud connect
  5. Configure Cloud Connect for SSO
  6. Configure P6 Professional to:
    • Connect through Cloud Connect / CloudServer driver
    • Utilize SAML to enable SSO authentication
  7. Set the session expiry period in the SSO engine
  8. Login to P6 Professional
  9. Use the product longer than the duration of the SSO session expiry and note the reported issues which occur

Changes

 

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