Hi,
I encountered an ORA-00001 error on APEX_260100.WWV_FLOW_WORKSHEET_RPTS_PK after copying an Interactive Report region on a page (within the same page) and modifying it to use a different query.
This worked fine in the original environment. However, after exporting the application and importing it into another environment, the error started occurring. The full error stack is included below. Error is raised when I run the page.
The error seems to originate from the original region (copied region has a different name).
Is this a known issue, and is there possibly a patch available or planned?
Environment details:
- APEX version: 26.1.1 (fully patched)
Kind regards,
Bas
Error: Error during rendering of region "Hoofaannemer detailregels uren".
- Additional info: Contact your application administrator.
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.REGION.UNHANDLED_ERROR
- SQL code: -1
- SQL error: ORA-00001: Schending van UNIQUE-beperking (APEX_260100.WWV_FLOW_WORKSHEET_RPTS_PK).
ORA-06512: in "APEX_260100.WWV_FLOW_PAGE", regel 1980
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2464
ORA-06512: in "APEX_260100.WWV_FLOW_IR", regel 2108
ORA-06512: in "APEX_260100.WWV_FLOW_IR", regel 2310
ORA-06512: in "APEX_260100.WWV_FLOW_IR_RENDER", regel 2179
ORA-06512: in "APEX_260100.WWV_FLOW_IR_RENDER", regel 15744
ORA-06512: in "APEX_260100.WWV_FLOW_REGION_NATIVE", regel 610
ORA-06512: in "APEX_260100.WWV_FLOW_REGION_NATIVE", regel 2717
ORA-06512: in "APEX_260100.WWV_FLOW_PLUGIN", regel 4508
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 1277
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2032
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2440
ORA-06512: in "APEX_260100.WWV_FLOW_PAGE", regel 1930
- Backtrace: ORA-06512: in "APEX_260100.WWV_FLOW_PAGE", regel 1980
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2464
ORA-06512: in "APEX_260100.WWV_FLOW_IR", regel 2108
ORA-06512: in "APEX_260100.WWV_FLOW_IR", regel 2310
ORA-06512: in "APEX_260100.WWV_FLOW_IR_RENDER", regel 2179
ORA-06512: in "APEX_260100.WWV_FLOW_IR_RENDER", regel 15744
ORA-06512: in "APEX_260100.WWV_FLOW_REGION_NATIVE", regel 610
ORA-06512: in "APEX_260100.WWV_FLOW_REGION_NATIVE", regel 2717
ORA-06512: in "APEX_260100.WWV_FLOW_PLUGIN", regel 4508
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 1277
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2032
ORA-06512: in "APEX_260100.WWV_FLOW_DISP_PAGE_PLUGS", regel 2440
ORA-06512: in "APEX_260100.WWV_FLOW_PAGE", regel 1930
- Statement:
- Component: APEX_APPLICATION_PAGES Hoofaannemer detailregels uren (200000000278)