My Oracle Support Banner

Apex Upgrade To 22.1 Failed with ORA-01408: such column list already indexed (Doc ID 2881852.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Application Express (APEX) - Version 18.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to Upgrade to APEX 22.1
the following error occurs.

ERROR
-----------------------
 not ok 4 - Creating APEX Tables | 0.42
  # Message: ORA-01408: such column list already indexed ORA-06512: at line 15
  #
  # Statement: declare
  # l_exists boolean := FALSE;
  # not_in_pdb exception;
  # pragma exception_init(not_in_pdb,-65040);
  # begin
  # for c1 in (select null
  # from sys.dba_indexes
  # where owner = 'FLOWS_FILES'
  # and index_name = 'WWV_FLOW_FILES_FILE_IDX') loop
  # l_exists := TRUE;
  # end loop;
  # --
  # -- If the index doesn't exist add it
  # if l_exists = FALSE then
  # execute immediate 'create index FLOWS_FILES.wwv_flow_files_file_id
x on FLOWS_FILES.wwv_flow_file_objects$ (security_group_id, filename, flow_id)';
  # end if;
  # exception
  # when not_in_pdb then
  # null;
  # end;
  # Message: ORA-06512: at line 15
  # Statement: as above


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Ran the installed script on a DB with APEX on it
2. See error in installation log

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!


In this Document
Symptoms
Cause
Solution
References


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