My Oracle Support Banner

Unable To Import translation Application in APEX 21.1.x (Doc ID 2896621.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

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

Symptoms

Source and Target Database are having Apex Runtime Environment Installation.
Trying to Export and Import Application from Source to Target Database
Facing Issues only with translation Applications, normal English Application import works fine as expected
Trying to Import the translation application from Source to Target Environment, hitting with the below error

alter session set container = sxxxxxe;
@f1xxx10.sql -- application file

But hitting with the below Error

--application/set_environment
APPLICATION 1xxx10 - AA_SC_UI_MAIN
--application/delete_application
--application/delete_application
--application/create_application
--application/shared_components/navigation/lists/data_load_process_train_import_lwgw
...
--application/shared_components/globalization/language
--application/shared_components/globalization/translations
begin
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "APEX_210200.WWV_FLOW_API", line 12045
ORA-06512: at line 92

++ read apex_filename
+++ date '+%d.%m.%Y %H:%M:%S'
++ logdate='05.09.2022 01:07:23'
++ IMPORT_STEP_COUNT=20
++ echo -e 05.09.2022 '01:07:23. 20. JOB_QUEUE_PROCESSES auf 10 gesetzt\n'
++ IMPORT_STEP_COUNT=21
++ echo -e 05.09.2022 '01:07:23. 21. UTLRP.SQL\n'
++ IMPORT_STEP_COUNT=22
++ echo -e 05.09.2022 '01:07:23. 22. Systemstatistiken mit NOWORKLOAD\n'

 

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.