Skip to Content

Invalid SFQL! Error: query "" is not properly formed

Hi Team,

We are working on SAP CPI standard content scenario"Employee Central to ERP Employee and Organizational Data" message was successfully processed in SAP HCI and getting the below error in SAP success factors logs.

Error details: Problem during invoking SuccessFactors Web service. SOAP faultCode ns2:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: query "SELECT person, EmployeeDataReplicationElement, SecondaryAssignments, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, accompanying_dependent, associated_employee_information, compensation_information, global_assignment_information, job_information, job_relation, payment_information, personal_documents_information, national_id_card, person_relation, personal_information, phone_information FROM CompoundEmployee WHERE replicationContentType = 'EMPLOYEE_MASTER_DATA' and replicationTargetSystem = '0M21EOR' andperson_id_external IN ('v4admin')AND company IN ('1010','1020') AND company_territory_code IN ('DEU') AND isContingentWorker IN ('0') AND effective_end_date >= to_date('2016-01-01')" is not properly formed , cause: org.apache.cxf.binding.soap.SoapFault: SFAPI Domain Error!

Please help me to fix this issue.


Bhargava Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers