Unique constraint WWV_FLOW_WORKSHEET_RPTS_UK violated
If your APEX application import log shows something like this:
...PAGE 73: Transaction Lines Report declare * ERROR at line 1: ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_RPTS_UK) violated ORA-06512: at "APEX_040200.WWV_FLOW_API", line 16271 ORA-06512: at line 6
(this is on an Apex 4.2.4 instance)
This is due to a Saved Report on an Interactive Report that was included in the export, which conflicts with a different Saved Report in the target instance. The log will, conveniently, tell you which page the IR is on.
The solution for this problem is simple – either:
(a) Export the application with Export Public Interactive Reports and Export Private Interactive Reports set to No;
OR
(b) Delete the Saved Report(s) from the instance you’re exporting from.
You can find all Saved Reports in an instance by running a query like this:
select workspace ,application_id ,application_name ,page_id ,application_user ,report_name ,report_alias ,status from APEX_APPLICATION_PAGE_IR_RPT where application_user not in ('APXWS_DEFAULT' ,'APXWS_ALTERNATIVE');
You can delete Saved Reports from the Application Builder by going to the page with the Interactive Report, right-click on the IR and choose Edit Saved Reports, then select the report(s) and click Delete Checked.
Sekhar
4 September 2017 - 2:19 pm
HI Kemp,
We are facing the below issue, do you have any idea why we see below issue –
ORA-00001: unique constraint (APEX_050100.WW_FLOW_COLLECTIONS_UK) violated.
Thanks,
Sekhar
Jeffrey Kemp
4 September 2017 - 2:58 pm
That is not the same issue – it’s a completely different constraint. I recommend posting your question on the Oracle community forum. http://community.oracle.com/community/database/developer-tools/application_express
MoriwaldEmare
31 July 2018 - 9:16 pm
Hi,
I’m facing this error at the moment while I’m exporting applications from DEV to TEST Environment via Jenkins and therefore Command Line Export. At the moment I’m using following code: “java.exe oracle.apex.APEXExport -db %3 -user %4 -password %5 -applicationid %6”. Is there a command for cli to set saved reports to “No”? Thanks in advance
Jeffrey Kemp
1 August 2018 - 8:34 am
Hi Moriwald, I think that would be a question for the CLI team – try the forum: https://community.oracle.com/community/database/developer-tools/sql_developer/sqlcl