Symptom
ODP DTP extraction of HR dataosurces fails with error:
The system tried to insert a data record, even though a data record with the same primary key already exists
Message no. SODQ666
Meanwhile, there might be the following error in extraction job log:
Exception DBSQL_DUPLICATE_KEY_ERROR occurred in line 33 of include LHRMS_BIW_PTDWU27 (program SAPLHRMS_BIW_PTDW)
Exception UNCAUGHT_EXCEPTION occurred in line 1 of include LHRMS_BIW_PTDWU27 (program SAPLHRMS_BIW_PTDW)
Error with extractor call RSC1_INIT_BIW_GET
Read more...
Environment
- Target independent ( SAP NetWeaver, SAP BW/4HANA )
- SAP ERP
- SAP ERP Central Component
- SAP enhancement package for SAP ERP
- SAP enhancement package for SAP ERP, version for SAP HANA
- SAP S/4HANA
Product
SAP ERP Central Component all versions ; SAP ERP all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions
Keywords
KBA , BW-BCT-PT , BW only - Personnel Time Management , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , How To
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.