Friday, December 9, 2011

APEX Errors During the Workspace Creation

I encountered the following error. May be other people created the workspace and some were hanging in there.


Errors 1:  ORA-00001 APEX APEX_040100.WWV_FLOW_PROV_COMPANY_NAME


Error 2: ORA-20002: Request 2703406260663232 could not be processed. -1 ORA-00001: unique constraint (APEX_040100.WWV_FLOW_COMPANIES_IDX1) violated


How I solved it:


I  traced the Index and issued the following statements:



select COMPANY_NAME from apex_040100.WWV_FLOW_PROVISION_COMPANY ;


select SHORT_NAME from  apex_040100.WWV_FLOW_COMPANIES;


They returned the value same as I was entering. However that workspace and company does not exist anywhere in the DB, so I did following :






 delete from apex_040100.WWV_FLOW_COMPANIES where SHORT_NAME='WORK';

 delete from apex_040100.WWV_FLOW_PROVISION_COMPANY where COMPANY_NAME='WORK';


commit;

-- and Voila - the issue resolved !!
Posted by at 11:09 PM

2 comments:

  1. AnonymousOctober 10, 2012 at 5:47 AM

    it works fine,
    I am using an oracle xe 11.2 instance, and the error was solved closely like in your example,
    select company_name from apex_040000.wwv_flow_provision_company;

    then i deleted that company name like:
    delete from apex_040000.wwv_flow_provision_company where company)name='name';

    Thanks for the post

    ReplyDelete
  2. AnonymousMarch 2, 2013 at 7:44 AM

    Good solution.

    Thanks.

    ReplyDelete

Subscribe to: Post Comments (Atom)