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. Exclude attachment-related fields from the OData call when replicating the remote table;
2. Use more partitions ;
3. Refer to the following best practices for OData V2 API calls: OData V2 Best Practices | SAP Help Portal 

• 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 , KBA , DS-DI-RT , Remote Tables , Problem