Hi everyone,
We’re developing an APEX app that handles Excel files, and we’ve run into a problem when trying to export the app from one Workspace and import it into another.
The main issue:
When we export the app and attempt to import it into a different Workspace, the import fails with various errors, and ultimately the app does not load.Has anyone experienced similar issues or have any advice on how to resolve this? Being able to seamlessly transfer the app across Workspaces would greatly improve our workflow.
Additional details:
We export the entire application using default export options.
During import, we select “Import as Application” in the Import Wizard.
After some loading time, an error appears—although the exact error message varies. Examples include:
-
Internal Server Error - WriteThe server encountered an internal error or misconfiguration and was unable to complete your request.
Reference #4.73a2f17.1748513046.f1d44d4
https://errors.edgesuite.net/4.73a2f17.1748513046.f1d44d4 -
Execution of the statement was unsuccessful. ORA-02091: transaction rolled backbegin wwv_flow_imp.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));
commit;
end;
We encounter the same problem even when exporting and importing a single page into a blank app. Clicking “Install Page” triggers the same ORA-02091 error as above.
Any guidance, tips, or workarounds would be highly appreciated. Thanks so much for your help!
The most common cause is the handling of ID's between workspaces.
Check out this MOS note 3034956.1 for full details and how to mitigate, but the first thing to try is toggling the "Original ID" option on export