My Oracle Support Banner

Error 'ORA-01450: maximum key length (6398) exceeded' When Attempting to Create Index 'ndx_document_cr_external_key' in P6 EPPM 19.12 (Doc ID 2689787.1)

Last updated on AUGUST 07, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 19.12 to 19.12.7.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

When attempting to create the ndx_document_cr_external_key P6 EPPM index that is reported as a missing object by the Schema Validation utility, the following error occurs.

Error: : ORA-01450: maximum key length (6398) exceeded.

 

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

  1. Run the version 19.12.x schema validation tool.
  2. Note that the report lists missing index ndx_document_cr_external_key.
  3. Attempt to create the index via the following SQL command from the standard database scripts provided in the P6 EPPM installation media:
    CREATE INDEX ndx_document_cr_external_key ON DOCUMENT (cr_external_doc_key)
        TABLESPACE PMDB_NDX1 PCTFREE 10
        STORAGE (initial 50K next 50K minextents 1 maxextents unlimited pctincrease 0);
  4. Index creation fails with the reported error.

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!

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