My Oracle Support Banner

Error ORA-01467: Sort Key Too Long, While Upgrading APEX From 20.x to 21.1 (Doc ID 2793949.1)

Last updated on JULY 22, 2021

Applies to:

Oracle Application Express (APEX) - Version 20.1 and later
Information in this document applies to any platform.

Symptoms

On: APEX 20.x version, Administration

When attempting to upgrade to APEX 21.1, the following error occurs.

ERROR
-----------------------
  not ok 377 - Update Plug-In Settings of Applications | 0,00
  # Message: ORA-01467: sort key too long
  # Statement:
  # merge
  # into wwv_flow_plugin_settings dst
  # --
  # -- source query: select all component settings for native Plug-Ins

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On an APEX 20.x environment, start SQL Plus as SYS
2. Run APEX 21.1 installation script
3. Error message appears at end of installation process, and can be viewed in the installation log


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!


In this Document
Symptoms
Changes
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.