SAP Knowledge Base Article - Public

3152696 - [PTP] - Error in SLG1 SFAPI Domain Error! - Error Code: INVALID_SFQL

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

  1.  Go to SE38
  2.  Select report RP_HRSFEC_PTP_EE_REPLICATION
  3.  Fill the mandatory field
  4.  Execute
  5.  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