Skip to Main Content
Forums

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!

WWV_FLOW_FND_GU_INT_G_FK violated in workspace import - safe steps?

Paavo15 hours ago

apex latest
ords latest
sqlcl latest

When importing workspace export files created with “apex export -expworkspace -workspaceid 123123” with admin user given the “GRANT APEX_ADMINISTRATOR_ROLE TO admin;” to fresh APEX instance, I get errors like:

..clips..ids obfusced..
Creating Groups...
Elapsed: 00:00:00.196
Elapsed: 00:00:00.172
Elapsed: 00:00:00.128
Creating group grants...
Creating Users...

SQL best practice warning (23,37): G-1050: Avoid using literals in your code 
CREATE GROUP #1234567890

begin
*
ERROR at line 1:
ORA-02291: integrity constraint (APEX_240200.WWV_FLOW_FND_GU_INT_G_FK) violated - parent key not found
ORA-06512: at "APEX_240200.WWV_FLOW_FND_USER_INT", line 1928
ORA-06512: at "APEX_240200.WWV_FLOW_FND_USER_API", line 216
ORA-06512: at line 13

I found several suggestions to circumvent this:

  1. remove roles from source workspace users? and toggle them in target again on?

  2. remove from wsimport.sql file the ids p_group_ids => '12312313212:666666666:77777777:',

  3. disable the fk-constraint

    And none of them feel quite right? So how to do this today ?

rgrds Paavo
Comments
Post Details
Added 15 hours ago
#apex, #cicd
1 comment
26 views