Symptom
- Create and schedule import job based on import data connection to Google Drive in a model
- Observe this scheduled import job would fail intermittently with error message "Unexpected error occurred, please contact system admin for help. "
Environment
- SAP Analytics Cloud 2024.8.10
Reproducing the Issue
- Log onto SAC
- Open a model
- Create an import job based on the import data connection to Google Drive in this model
- Schedule this import job to run daily
- Click on this import job and navigate to the Status panel
=> Observe that this import job would fail intermittently when running automatically on this scheduled time
=> Also observe that this import job would not fail when running it manually
Cause
- This issue is caused by the large number of concurrent calls to get the data from Google Drive.
- This error is coming from the data source (Google Drive) side
Resolution
Workaround from SAC side:
- Try not use exact times when scheduling import jobs because probably many other import jobs are scheduled to that exact time. For example, schedule import jobs on 07:13 instead of 07:00.
- Try to consider import frequency. Import job frequency should be adjusted according to the needs. Too frequent import jobs are not the optimal in many data sources, it might cause overloading on the data source and sometimes even SAC.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, model, account, google, drive, scheduling, failure, plugin, import, manual, epm service , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0