Could not generate the XML stream caused by: com.c Message no. ECPAO_IN_QUERY000
This Blog post is All about Error which we can get in Transaction SLG1 and after searching alot also I didn’t got nothing much on Internet particularly in SAP terms.
I Used standard package available in CPI for replicating Employee master data from SuccessFactors Employee Central to SAP ERP named :SAP SuccessFactors Employee Central to ERP Employee and Organizational Data. After Everything was moved to production ,project has been gone live. Everything was working fine, one day i noticed that my Employee Data has stopped replicating from SuccessFactors Employee Central to SAP ERP System.
After going through CPI and SAP ERP in Transaction SLG1 of SAP system i was getting error which is like : Could not generate the XML stream caused by: com.c Message no. ECPAO_IN_QUERY000.
I checked with my background job which was scheduled for Replicating Delta changes and new employees from the SuccessFactors ,I tried rescheduling it but it didn’t worked.I was still getting same issue.
I tried Replicating single employee using query program ECPAO_EE_ORG_REPL_QUERY and it was working in that case. Means, Program was working in case of single employee which proved me that their is nothing wrong with configurations.
Then i tried with running the query program at full load and again i got same issue. Which means error was coming while replicating bulk data from Employee Central to SAP ERP.
I tried resetting the query status using Transaction ECPAO_RESET_QRY_ADM but no change in issue.
I searched alot on Internet but didn’t find any exact solution to this error particularly in terms of SAP.
In this blog post i will tell you about how i resolved this error.
After my review, I found in the tcode SRT_MONI (Receiver interface name: EmployeeMasterDataAndOrgAssignmentBundleReplicationRequest_In) the following message is coming back from the SF EC instance:
“Could not generate the XML stream caused by: com.ctc.wstx.exc.WstxIOException: Error writing request body to server”
root cause is the SFAPI CompoundEmployee call in the SF side with huge payload.
For Solving this issue.change the page in receiver tab of Esize to e.g. 100 and timeout to 10 minutes.
Go to CPI > Design > SAP SuccessFactors Employee Central to ERP Employee and Organizational Data > Artifacts > SAP SuccessFactors Employee Central to ERP Employee Data and Organizational Assignment > Configure>
In recreiver Tab drop down to Employee_Central change Page Size to 100 , Timeout(in min) to 10.
This Configuration i showed particular in terms of this integration scenario. Scenario might change according to your scenario.
Try replicating Employees at full load and your problem will be solved.
Conclusion: This is how we can overcome this issue.Hope this blog is helpful for all.