Error: "ORA-01467: sort key too long" When Attempting to Login to P6 Professional for Cloud Connect in Oracle Hosted Cloud Environment

(Doc ID 2312902.1)

Last updated on OCTOBER 05, 2017

Applies to:

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

Symptoms

When attempting to login to the P6 Professional client via Cloud Connect, the following error occurs:

ERROR
-----------------------
"Exception TDBXError in module PM.exe at 00000000003628CF. ORA-01467: sort key too long"

STEPS TO DUPLICATE
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to P6 Professional for Cloud Connect
  2. Enter username and password
  3. Error is displayed

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