SAP Knowledge Base Article - Preview

3147635 - The INSERT statement conflicted with the FOREIGN KEY constraint

Symptom

During package import, the ABAP package is failing to import into test.
From eclipse the error is : "Package Transport Failed"

The Netweaver logs show; 

Import failed with result code: -1 
[EXCEPTION] 
java.lang.IllegalStateException: Import failed with result code: -1 
at com.sap.idm.ic.backgrountasks.adapters.ImportPackageAdapter.doAction(ImportPackageAdapter.java:116) 
at com.sap.idm.ic.backgrountasks.TaskExecutorAdapter.run(TaskExecutorAdapter.java:136) 
at java.lang.Thread.run(Thread.java:836) 


importIDStore 
[EXCEPTION] 
com.sap.idm.db.exceptions.IdMDbException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MC_Dispatcher_LINK_JOB". The conflict occurred in database "idmd_db", table "dbo.mc_jobs", column 'JobId'. 
OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION] 
at com.sap.idm.db.util.ExceptionUtil.HandleExceptions(ExceptionUtil.java:24) 
at com.sap.idm.db.objutil.exec.MxObjectQueryExecUtil.execInsert(MxObjectQueryExecUtil.java:386) 
at com.sap.idm.db.objutil.BaseTableUtil.addNew(BaseTableUtil.java:28) 
at com.sap.idm.packagetransport.ic.JobDispatcherLinkUtil.toDatabase(JobDispatcherLinkUtil.java:64) 
at com.sap.idm.packagetransport.impl.Import.execute(Import.java:111) 
at com.sap.idm.packagetransport.impl.Main.importPackages(Main.java:208) 
at com.sap.idm.ic.backgrountasks.adapters.ImportPackageAdapter.doAction(ImportPackageAdapter.java:104) 
at com.sap.idm.ic.backgrountasks.TaskExecutorAdapter.run(TaskExecutorAdapter.java:136) 
at java.lang.Thread.run(Thread.java:836) 


Read more...

Environment

SAP Identity Management 

Keywords

Package, Key, Constraint, IDM, Package, Import , KBA , BC-IAM-IDM , Identity Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.