zorantica / dome

D.O.M.E. for Oracle Database and APEX is a powerful utility designed to streamline and accelerate the development and deployment processes for PL/SQL and APEX applications. It enhances efficiency by aiding developer teams in organizing their work and automating the production of installation scripts.
MIT License
17 stars 2 forks source link

Confirm Patch - ORA-20001: Unable to find fr translation of application #1

Open rnijs opened 1 month ago

rnijs commented 1 month ago

Hi

Latest version has been installed.

When confirming the patch, we get following error: ORA-20001: Unable to find fr translation of application We have some components into this patch, but even with the most simple object, we get this message. Can you please guide us in this error?

Thanks in advance for your help.

APEX version 22.02.05

Full Stack: is_internal_error: false ora_sqlcode: -20001 ora_sqlerrm: ORA-20001: Unable to find fr translation of application 251000 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573 ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163 component.type: APEX_APPLICATION_PAGE_PROCESS component.id: 5293378029293863623 component.name: Confirm patch error_backtrace: ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573 ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "APEX_220200.WWV_FLOW_LANG", line 2573 ORA-06512: at "APEX_220200.HTMLDB_LANG", line 219 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_UTILS", line 125 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at "DOME.PKG_PATCHES", line 38 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 837 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2614 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_LOCAL", line 3053 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2642 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC", line 2678 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 3163 ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS", line 170 error_statement: begin PKG_PATCHES.p_confirm_patch( p_patch_id => :P410_PATCH_ID, p_user_confirmed_id => :APP_LOGGED_USER_ID ); end;

zorantica commented 1 month ago

Hi!

Can You check if the translated application for FR language exists? When You add a new translation language for Your application and do not publish it... the translated application is not created and maybe that's the reason why You get an error "Unable to find fr translation of application 251000".

rnijs commented 1 month ago

Hi,

The language fr and nl are already long time available in this app and has been seed & published several times already by the apex designer.

screenshot jpg (3001)

Regards, R.