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 18.104.22.168 [Release 19.12]
Information in this document applies to any platform.
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:
- Run the version 19.12.x schema validation tool.
- Note that the report lists missing index ndx_document_cr_external_key.
- 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);
- Index creation fails with the reported error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!