Query is Not Properly Formed Replication Error - SuccessFactors to S4 (on-premise)

[Max_B]

When executing the query ECPAO_EE_ORG_REPL_QUERY to replicate Employee Master Data from SuccessFactors to S/4 I receive the following error message in the inbound webservice:

Problem during invoking SuccessFactors Web service. SOAP faultCode ns2:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: query "" is not properly formed.

It seems like the query is empty. What can I do to solve this issue?

[Sriprasadsbhat]

Hello Max,

Please check with your integration consultant to get the logs to see what query( Compound Employee query ) is being passed to SFSF.Once send correct parameters you should get response back to S4 or ECC.

Regards,

Sriprasad Shivaram Bhat

[Max_B]

Hi Sripasad,

The query looks like this:

QUERY = SELECT ItDeclaration,WorkOrder,address_information,alternative_cost_distribution,associated_employee_information,compensation_information,dependent_information,email_information,employment_information,global_assignment_information,job_information,national_id_card,paycompensation_non_recurring,paycompensation_recurring,payment_information,person,personal_information,phone_information from CompoundEmployee WHERE replicationTargetSystem = 'XXXXXXX' AND replicationContentType IN ('EMPLOYEE_MASTER_DATA','EMPLOYEE_ORG_ASSIGNMENT') AND isContingentWorker IN ('0','1') AND effective_end_date >= to_date('2018-09-08') AND hiringNotCompleted = 'false' AND assignment_class IN ('ST','GA')