![oracle apex sql error 02291 oracle apex sql error 02291](https://1.bp.blogspot.com/-YPhDyG1t-C8/WzeWhtXERmI/AAAAAAAAJP8/mN369ntmsCgkTskEzN3RcIC6uz9R8GQJgCLcBGAs/s1600/ora_apex_error_handling_function.png)
![oracle apex sql error 02291 oracle apex sql error 02291](https://i.stack.imgur.com/p7A4J.png)
ORA-02292: integrity constraint (APEX_180100.WWV_FLOW_UI_NAV_LIST_FK) violated Hello - APEX 18.1.0.00.45 When I attempt to Import an application from back up I am receiving the following error - Execution of the statement was unsuccessful. Any insight into how we get past this would be great. Execution of the statement was unsuccessful. We have exported the components to try to move to our test workspace and are now receiving the following error. Using APEX 5.0 having issue with import of Data Loading tables Hi,We are using APEX 5.0, on a 12c database.In our development area we created a set of data load pages to upload data into a working table. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key. Any information on this would be helpful. Thanks,Prashanth
#Oracle apex sql error 02291 update#
00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. Below is the complete error message.Error report -ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_RPTS_UK) violatedORA-06512: at "APEX_040200.WWV_FLOW_API", line 16287ORA-06512: at line 600001.
#Oracle apex sql error 02291 code#
This new export got migrated successfully into my test instance without any error. APEX Verison: 4.2Database Version: 12g Any information about this error code why it occurs and if its really due to saved reports in IR. Error occurs in the page where the Interactive report with Saved public report is present.I then tried deleting the Saved reports in DEV instance and then took an export of the application. ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_RPTS_UK) violated Hi All, I have an strange scenario where I get an error "ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_RPTS_UK) violated" when I try to migrate the application file to other instance.I suspect that this was due to some saved public reports of an Interactive Report.