Error When Creating Index In EDQ (Doc ID 2848120.1)

Last updated on JUNE 27, 2023

Applies to:

Goal

Error when creating Index in EDQ - Version 12.2.4.1

Error trace:

<Jan 21, 2022 9:03:57,370 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0116 ON DN_R20(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:03:57,371 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0115 ON DN_R20(COLUMN2) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:05,544 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0130 ON DN_R35(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,017 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0137 ON DN_R37(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,121 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f013d ON DN_R41(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,125 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f013e ON DN_R30(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,239 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f013f ON DN_R34(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,246 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0140 ON DN_R34(COLUMN2) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,293 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0141 ON DN_R36(COLUMN1) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,490 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0143 ON DN_R32(COLUMN13) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,491 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0144 ON DN_R32(COLUMN14) failed: ORA-01450: maximum key length (6398) exceeded
>
<Jan 21, 2022 9:04:06,493 AM ICT> <Warning> <oracle.edq.main> <EDQ-05604> <SQL operation CREATE INDEX idx_0_17e7a5f0145 ON DN_R32(COLUMN12) failed: ORA-01450: maximum key length (6398) exceeded

Solution

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