0 Replies Latest reply: Dec 30, 2013 1:43 PM by BillC RSS

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

    BillC

      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?