Hello Experts,
We have a custom developed Resource (Process, Process Form, ITR) . When migrated to higher environments, the XML import throws error in the logs. The export/import always throws error because of keys in the OIM DB tables - MAV, ADV, SDP etc.
Please advise if this is the correct procedure to migrate custom resources.
Import failed for entity : 'XXXXX' which is of type : 'Process', with the following error message :Unable to save dataobject for MAV[[com.thortech.xl.ddm.exception.DDMException: Import failed for entity : 'xxxxx' which is of type : 'Process', with the following error message :Unable to save dataobject for MAV at com.thortech.xl.ddm.engine.SchemaInstanceFacade.performImport(SchemaInstanceFacade.java:504) at com.thortech.xl.ejb.beansimpl.tcImportOperationsBean.performImport(tcImportOperationsBean.java:1274) at Thor.API.Operations.tcImportOperationsIntfEJB.performImportx(Unknown Source) at Thor.API.Operations.tcImportOperationsIntf_uawk3z_tcImportOperationsIntfRemoteImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)
Caused by: Error : 2291, Position : 0, Sql = insert into mav (MAV_KEY, MIL_KEY, ADV_KEY, MAV_MAP_TO, MAV_MAP_QUALIFIER, MAV_MAP_VALUE, MAV_FIELD_LENGTH, MAV_MAP_OLD_VALUE, MAV_CREATE, MAV_CREATEBY, MAV_UPDATE, MAV_UPDATEBY, mav_rowver) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 ), OriginalSql = insert into mav (MAV_KEY, MIL_KEY, ADV_KEY, MAV_MAP_TO, MAV_MAP_QUALIFIER, MAV_MAP_VALUE, MAV_FIELD_LENGTH, MAV_MAP_OLD_VALUE, MAV_CREATE, MAV_CREATEBY, MAV_UPDATE, MAV_UPDATEBY, mav_rowver) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-02291: integrity constraint (IGD_OIM.FK_MAV_ADV) violated - parent key not found