ODI 126.96.36.199 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?
You might be hitting Bug 13916069 : INTEGRITY CONSTRAINT VIOLATION ERROR WHEN DELETING SOURCE TABLE FROM INTERFACE.
Refer: ODI-10182 and ORA-02292 Errors Signalled After Deleting Unnecessary Datastore in ODI 11g Integration Interface (Doc ID 1545938.1)