Error while renumbering Work Repository ID in ODI - java.lang.RuntimeException: com.sunopsis.dwg.SQLMasterReposException: ORA-02292: integrity constraint (SID_ODIREPO.FK_VERSION_SNP_DAT) violated - child record found

Error while renumbering Work Repository ID in ODI - java.lang.RuntimeException: com.sunopsis.dwg.SQLMasterReposException: ORA-02292: integrity constraint (SID_ODIREPO.FK_VERSION_SNP_DAT) violated - child record found

at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:611)
at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:347)
at com.sunopsis.graphical.dialog.SnpsDialogRenumberId.dialogOkActionHook(SnpsDialogRenumberId.java:113)
at com.sunopsis.graphical.definition.DialogDefinitionNode$1.vetoableChange(DialogDefinitionNode.java:407)
at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:335)
at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:252)
at oracle.bali.ewt.dialog.JEWTDialog.fireVetoableChange(JEWTDialog.java:1530)

at oracle.bali.ewt.dialog.JEWTDialog.dismissDialog(JEWTDialog.java:1560)



If you are encountering errors as above while renumbering the Work Repository ID in Oracle Data Integrator (ODI), kindly refer to the steps in this post and check if the issue is resolved.

Related posts:

In OBIA 11.1.1.8.1, import error  ODI-10013: The import action has been cancelled because it could damage your repository. This is due to SNP_COL object that has object identifier 82624500 that is greater than that for the current SNP_COL id sequence. Importing this object would lead to primary key violations in the future