Skip to Main Content
Feature Request FR-2142
Product Area Application Builder
Status DELIVERED

5 Voters

Improve the restore subscription for theme and templates, as it can fail without givin any details, better template matching

gabriel.diaz.arias Public · Nov 2 2021

Idea Summary
The restore subscription for theme and templates doesn't work properly sometimes failing with a general error. Now we cannot restore the theme subscription as it says a general error and doesn't give us any detail, for example, duplicates or watever. It should give much more information in case of errors, which template failed or in which point in order to manually fix it.

Use Case
Improve theme and template management with multiple applications.

Preferred Solution (Optional)
- Give much more details in case of error when restoring theme subscriptions, and if fails on specific template restoring, it should tell you which one has failed. 

- Better template matching, many times you tell to match by template name and even then the proposal doesn't match, even when the select list template title is the same when you manually select it.

- Don't reset all template options in all pages application and components when changing themes if they have similar options. Sometimes you just change between different universal theme versions, and it resets all template options everywhere.

This has been delivered in Oracle APEX 22.2 as part of bug 34549822!

Comments

Comments

  • vincent morneau Admin OP 3.3 years ago

    We've encountered this internally too. Some improvements were made in 21.2 and then again in 22.1. If you have more info in the error codes, that would be useful. We plan to monitor this and address issues.

  • gabriel.diaz.arias OP 3.3 years ago

    Glad to see that you joined oracle apex team, sure you are providing very nice feedback and new ideas. Nice initial pwa support!

    At the end I had to get as the SYS user and manually correct all invalid references in templates assignments and subscriptions on internal apex tables. I saw that when you had non-existant references to page templates, the restore subscription process failed. I contacted Oracle support for this, I will try to provide the case support number as I provided more details about this there. They weren't helpful as you see, as I had to do it myself. I have the feeling that oracle support cases that are related to apex never reach the proper teams. We manually fixed all invalid references before upgrading to 21.2 as I didn't want to have problems when refreshing the universal theme.

  • gabriel.diaz.arias OP 3.3 years ago

    What would be the general recomendation if you just develop apex apps for your own company (not multiple clients). It would be better to use the “keep original id's” option before exporting apex applications? Because apex doesn't use foreign keys for all internal tables, things can get really messy if you keep internal id's for some apps, and not for others, when using theme subscriptions or cloning db instances. The missing internal foreign keys is maybe related to making easier exporting apex apps, but It would be nice having them for avoiding this kind of problems.