Skip to Content
0

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

Feb 04 at 10:23 AM

101

avatar image

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:

com.sap.it.rt.adapter.sfsf.wsclient.SfsfWsClientFaultException: 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.

Regards

Bhargava Krishna

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers