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!

Can't Merge into Main or Refresh Working copies: error

ExeccrJun 26 2024 — edited Jun 26 2024

I have a 23.2.6 Apex environment on Oracle 19c 19.3 database.

I came from Apex 22.1, so the first thing i want to check is the Working copies feature.

I create and app, made some pages, then create a working copy and then i continue to modify it. After some others new pages, i want to merge back the changes in the Main application.

But if i tried, after the loading screen showing me some progress, at the end i get an error (Red popup come up but is empty)

I get the same error if i try to refresh the working copy from the main.

I had open the Edge Developer console and i get this only row:

Failed to load resource: the server responded with a status of 500 ()

So i opened the debug log on apex and i have these errors for the page 5300:

Referenced component LIST_TEMPLATE with id 25782019501105400 does not exist! Currently processing type THEME.
Referenced component LIST_TEMPLATE with id 17532483759701452 does not exist! Currently processing type THEME.

Mmm, strange. So i go to the templates part in shared component, filter the view by the word list and i check every components.

What i've found is a Type=List, Name=Link List row that have one references, but if i click on it i get an empty view. It seems that no components is reported as referenced, but the count is 1 in the main view.

I don't know very well the underling Apex tables, but i searched for some tables with Templates in names, and i found that results for the query select * from APEX_APPLICATION_TEMPLATES where TEMPLATE_ID in (25782019501105400,17532483759701452) ;

Seems to be a Breadcumb item.
107 is the main application, 108 the working copy

Back on Apex, i go again in shared components → templates and i've searched now for the Breadcumb template.

Here i see that i got 3 references, but if i click on the number i get only 2 row: one for one of my application page (btw, in thaht page the breadcumb is Commented Out), and one for the apex standard application page 10000.

Any hint on what is wrong?

Comments
Post Details
Added on Jun 26 2024
2 comments
692 views