1 Reply Latest reply: Mar 1, 2014 1:14 PM by Krishan-Oracle RSS

    startcmd  OdiImportObject for interface raises com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (DEV_ODI_REPO.FK_POP_CLAUSE3) violated - child record found

    Keith Bines

      ODI 11.1.1.6 on linux, 11gr2 db

       

      Running the odi command lien to reload an interface raises

       

      com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (DEV_ODI_REPO.FK_POP_CLAUSE3) violated - child record found

       

      Anybody know why this happens and what the workaround is other than manually dropping and re importing the interface from the studio?