Hello, APEX team
Recently I decided to upgrade some of my environments from APEX 18.2 to 19.1.
Most of the migrations went without an issue. But not all of them, unfortunately.
On one of the environments I got this:
# Error: ORA-02298: cannot validate (APEX_190100.WWV_FLOW_DATA_SESSION_FK) - par
ent keys not found
# Statement: alter table "APEX_190100"."WWV_FLOW_DATA" enable all triggers enabl
e constraint "VALID_ITEM_FILTER" enable constraint "VALID_SESSION_STATE_STATUS"
enable constraint "WWV_FLOW_DATA_SESSION_FK"
# Backtrace: ORA-06512: at "APEX_190100.WWV_FLOW_UPGRADE", line 1141
This is the only issue which appeared during the migration process. Now it looks as everything works, of course, because it is just a foreign key contraint, but still, I am not sure how much critical the issue and where it could lead in future.
I tried to look for same issues on forums and found several threads about similar symptoms during the migration process, but they are either unanswered or irrelevant:
-
-
-
Did anyone come across the same situation? And could anyone suggest how much critical the issue is?