2317018 - "[301]: unique constraint violated" error occurs while loading to IBP by CI-DS process - SAP Cloud Integration for Data Services

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• CPI-DS Process fails with error:
  
  
• Could not complete stored procedure ""/IBP/CL_SAP_SFND_SOPINTEG=>SOPINTEG_DATA_UPLOAD"" of application "SNOP" due to "Failed to run stored procedure for Lumira:com.sap.db.jdbc.exceptions.jdbc40.SQLIntegrityConstraintViolationException: [301]: unique constraint violated: [301] ""."/IBP/CL_SAP_SFND_SOPINTEG=>SOPINTEG_DATA_UPLOAD": line 204 col 17 (at pos 10815): [301] (range 3) unique constraint violated exception: unique constraint violated: Table(/IBP/I MTFILECOL), Index(_SYS_TREE_RS_#544362_#0_#P0)".
  
  
• Could not complete stored procedure "SAPHANADB."/IBP/CL_SAP_SFND_SOPINTEG=>SOPINTEG_DATA_UPLOAD_V1"" of application "SNOP" due to "Failed to run stored procedure for IBP:com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB [301]: unique constraint violated: "SAPHANADB"."/1BCAMDP/SOPINTEG_DATA_UPLOAD_V1": line 20 col 11 (at pos 786)
  
  
• Process contains multiple dataflows that write to the same IBP target.
• Running any individual task does not fail with the same unique constraint error.

SAP Cloud Integration for Data Services 1.0.11.xxxx

HCI, DS, HCI-DS, CPI, CPI-DS, IBP , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , EIM-HCI , SAP HANA Cloud Integration (Data Services) , Problem