0 Replies Latest reply: Dec 30, 2013 11:43 AM by BillC RSS

Joel Kallman - ORA-00001: unique constraint (APEX_040200.WWV_FLOW_PAGE_PLUG_IDX2) violated

BillC Newbie
Currently Being Moderated

Hi,

I am getting

ORA-00001: unique constraint (APEX_040200.WWV_FLOW_PAGE_PLUG_IDX2) violated

when trying to add theme 24 to application 777 on oursite.com

 

 

I read Joel Kallman's response to this Discussion

https://community.oracle.com/thread/2475486

and it got the thought to go see if I had any templates in my app that have theme 24.

Well looking in Shared Components did not show any BUT then I queried APEX_APPLICATION_TEMPLATES

 

 

select WORKSPACE,WORKSPACE_DISPLAY_NAME,APPLICATION_ID,APPLICATION_NAME,THEME_NUMBER,TEMPLATE_ID,TEMPLATE_NAME,TEMPLATE_TYPE

from APEX_APPLICATION_TEMPLATES

where THEME_NUMBER = 24

and APPLICATION_ID = 777

 

 

my results showed the same region template as Joel mentioned in his reply to the above post

 

 

I had the "DIV Region with ID" region template in the APEX view.

 

 

Paul,

I'm not sure how you ended up in this situation, but you had one template associated with theme ID 24 with a name of 'DIV Region with ID'. This was in the absence of theme 24 being installed in your application.

I'll review the data integrity rules how this was even permitted in the first place. But for your specific application, I deleted the one errant row and you can now install Theme 24 into that application.

Joel

 

How do I delete this from the base tables?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points