SAP Knowledge Base Article - Public

2770078 - "The Workforce Analytics server has timed out." error when importing data from SuccessFactors in SAP Analytics Cloud

Symptom

The following error occurs in SAP Analytics Cloud (SAC) when importing data from SuccessFactors:

  • "The Workforce Analytics server has timed out. Please try again later. If this continues, contact your Workforce Analytics administrator."

Error message in Google Developer tool:

  • "{"message":"The Workforce Analytics server has timed out. Please try again later. If this continues, contact your Workforce Analytics administrator.","stack":"","errorDetails":[{"messageId":"WFA_GATEWAY_TIMEOUT","message":"The Workforce Analytics server has timed out. Please try again later. If this continues, contact your Workforce Analytics administrator.","bUIMessage":false,"bWarning":false,"status":504}],"status":500,"bUIMsg":false,"bWarning":false}"

Environment

  • SAP Analytics Cloud
  • SAP SuccessFactors

Reproducing the Issue

  1. Try to create a model from an SAP SuccessFactors Workforce Analytics import data connection.
  2. Notice the error message.

Cause

  • The OData API used for WFA access is not suitable for large data-extraction scenarios (like replicating WFA cubes).
  • The OData API used to access WFA is designed for smaller data-consumption queries, to feed reports.
  • This interface will abort when approaching 60-80K Cells per fetch. (Approx. 15-20 columns, by 4000 rows) 
  • The behavior is by design. 

Resolution

  • Import different slices of data to fill the model, using the “Append” option in SAC.
  • Edit the query filters for subsequent import jobs, by changing the restriction selections. (i.e. Import different 'slices' of data into the model sequentially, e.g. by Month, Org Unit, and Location) 

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0 ; SAP SuccessFactors Workforce Analytics 1811