Howdy, I'm upgrading an ORDS 24.4 (24.4.0.r3451601) to ORDS 26 and I'm running into an error:
[*** Info: Upgrade version: 25.4.1.047 teamPath: upgrade/25.4.1.047/core/ ]
[*** script: upg_roles_and_privs.sql]
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (ORDS_METADATA.ROLES_SCHEMA_FK) violated - parent key not found
ORA-06512: at line 3
I've run into the same error with what I think are the two latest ORDS versions: (26.2.0.r1732140 and 26.1.2.r1401916)
I'm running on database version 19.30. I do have an older APEX version installed that I'll be upgrading to 26.1 after, but I thought I should be doing the ORDS upgrade first.
The 24.4 version was running fine with no issues, but it has been upgraded serveral times from older ORDS versions. Reviewing SEC_ROLES / SEC_PRIVILEGES and ORDS_MODULES from the pre-upgrade and current state, I'm not seeing anything like an invalid schema reference.