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
- Try to create a model from an SAP SuccessFactors Workforce Analytics import data connection.
- 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
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
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