Symptom
Error message in SLG1 for the employee replication:
Fault Code: ns2:Server, Fault String:
SFAPI Domain Error!
Error Code: INVALID_SFQL, Error Message:
Invalid SFQL! Error: Duplicated selected column:
SFAPI query failed with HTTP Status 500 for Configuration
Environment
- SAP ERP 6.0
- SAP enhancement package 1 for SAP ERP 6.0
- SAP enhancement package 2 for SAP ERP 6.0
- SAP enhancement package 3 for SAP ERP 6.0
- SAP enhancement package 4 for SAP ERP 6.0
- SAP enhancement package 5 for SAP ERP 6.0
- SAP enhancement package 6 for SAP ERP 6.0
- SAP enhancement package 7 for SAP ERP 6.0
- SAP enhancement package 8 for SAP ERP 6.0
Reproducing the Issue
- Go to SE38
- Select report RP_HRSFEC_PTP_EE_REPLICATION
- Fill the mandatory field
- Execute
- Check SLG1 for errors
Cause
Duplicated segment configured in the Query Segments for the ConfigID.
Resolution
Remove the duplicated segments for the affected ConfigID on the Query Segments.
Keywords
ConfigID, PTP, Query Segments, INVALID_SFQL, duplicated , KBA , LOD-EC-GCP-PY , Payroll Integration EC to Employee Central Payroll , Problem
Product
SAP SuccessFactors HXM Core 2111