3626211 - 504 gateway timeout error during remote table replication from SuccessFactors to Datasphere

• When attempting to replicate a remote table from SuccessFactors to SAP Datasphere, the process fails with a "504 Gateway Timeout" error.
• The error message is similar to: "Error: {"timestamp":"2025-01-01 00:00:00.00000", "origin":"_sys_task", "message":"internal error: connection to api17.sapsf.com:443 returned status 504 message: ß"faultV:ß"faultstringV:VGateway TimeoutV.VdetailV: ["errorcode : \"messaging.adaptors.http.flow.GatewayTimeout!"}}} at
  ederation/fedservice/FederationQueryExecutorResultSet.cpp:242; Statement: ,INSERT INTO VTABLE.VEmpJob$CTV [attachment!", attachmentFileName, attachmentFileSize, attachmentFileType, lattachmentld\", ...."
  We recommend that you start a direct data replication without using a schedule to get a proper error analysis with an accurate solution." 

SAP Datasphere

Check the Run of the remote table in the Data Integration Monitor and see the error.

The issue is caused in the SuccessFactors OData API protocol when handling large or complex data requests. The inclusion of attachment-related fields in the OData call contributes to the timeout error.

1. Check if the custom attachment field has navigation property set. Meaning that we are fetching only attachment ID and not the complete attachment content.
2. For performance purposes make sure that all attachment-related fields are excluded from the replication.
3. Make sure that there is no parallel expensive replication from the same source which can overload the system.
4. Use more partitions.
5. Refer to the following best practices refer to our Help Portal: OData V2 Best Practices and SAP SuccessFactors Connections

• KBA 3308167 - How to handle timeouts in API calls
• SAP Help: OData V2 Best Practices

504 gateway timeout, remote table replication, SuccessFactors, Odata API, timeout error, attachment , KBA , DS-DI-RT , Remote Tables , Problem