Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Installing APEX 24.2. Located Error in Application 8842, Universal Theme Legacy (f8842.242.sql)

Carlos Sendín7 hours ago

Anyone with the next situation?

  • Host Operating System: Windows Server 2016
  • DB Version: ORACLE 19.0.0.0.0 (19.3.0.0.0)
  • DB Version: ORACLE 19c Multitenant
  • The ORACLE Instance has other PDB running OK
  • There are other PDBs running different versions of ORACLE APEX (APEX 18.2, APEX 23.2)
  • Host Operating System: Windows Server 2016 (Spanish)

Bellow the error I've detected (an extract from my install log)

...
...
...
...Installing Universal Theme

--application/set_environment
API Last Extended:20241130
Your Current Version:20241130
This import is compatible with version: 20241130
COMPATIBLE (You should be able to run this import without issues.)
ID offset during import: 0
New ID offset for application: 0

APPLICATION 8842 - Universal Theme Legacy
--application/delete_application
--application/create_application
...
...
...
--application/end_environment
... elapsed: ,29 sec

...done
--application/set_environment

Error que empieza en la línea : 19 Archivo @ E:\app\Administrador\product\19.3.0.CDB\dbhome_1\apex_24.2\core\themes\f8842.242.sql
del comando -
begin
wwv_flow_imp.import_begin (
 p_version_yyyy_mm_dd=>'2024.11.30'
,p_release=>'24.2.0'
,p_default_workspace_id=>12
,p_default_application_id=>8842.242
,p_default_id_offset=>0
,p_default_owner=>'APEX_240200'
);
end;
Informe de error -
ORA-06502: PL/SQL: error : error de conversión de carácter a número numérico o de valor
ORA-06512: en línea 2
06502. 00000 -  "PL/SQL: value or conversion error%s"
*Cause:    An arithmetic, numeric, string, conversion, or constraint error
           occurred. For example, this error occurs if you attempt to
           assign the value NULL to a variable declared NOT NULL, or if you
           attempt to assign an integer greater than 99 to a variable
           declared NUMBER(2).
*Action:   To resolve the issue, change the data, the way the data is
           manipulated, or the data variable declaration.
*Params:   1) error_info
           occurred.

It seems than the error is located when the installer tries to escute the scritp “**f8842.242.sql**

Thanks in advance.

Thanks from Spain.

Comments
Post Details
Added 7 hours ago
0 comments
16 views