Symptom
- Refreshing the import job fails from SAP datasphere.
- After the generation of the access token for import connectivity from SAP datasphere the validity of refresh token on SAC side is not renewed for additional 30 days.
Environment
SAP Analytics Cloud 2.0
Datasource: SAP Datasphere.
Reproducing the Issue
- Log in to SAC
- Open the model.
- Switch to Data Management.
- Select the import job and refresh it.
- Refresh jobs fails with the connectivity error.
Cause
The import job fails because the connection is terminated after 30 days since the refresh token expires.
Resolution
- If a refresh token expires, then the only way to renew it is to ask the user to log in again, starting a new OAuth flow from scratch, which will issue a new access token and refresh token.
- So, the refresh token is only valid for 30 days from entering the secret in the connection dialog and it won’t be renewed each time the refresh job takes place.
- Thus creating a new access token will NOT renew the refresh token.
- When initially trying to obtain an OAuth access token by sending an HTTP POST request to DWC using OAuth Client ID and Secret, SAC also receives a refresh token. The presence of the refresh token means that SAC will be able to get a new access token from DWC without the user’s interaction if the access token will expire in 1 hour. Meanwhile, the refresh token will be kept valid in 30 days (720 hours) since the previous log on using OAuth Client ID and Secret.
- We request you to use our BTP influence tool to submit improvement requests:2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? - SAP for Me
- 0000000011 - Would you like to shape & influence future releases of SAP Products?
See Also
- https://influence.sap.com/sap/ino/#/idea/301518/?section=sectionDetails
- SAP Analytics Cloud community best practices expert page
- 2511489 Troubleshooting performance issues in SAP Analytics Cloud
- 2413393 How to record timelines in Chrome Developer Tools in case of SAP Analytics Cloud performance issues
- Performance Analysis Reference
- Wikipedia - .har files
- 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 case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAC, API, OAuth, Connection, DWC, access token, refresh token. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement
Product
SAP Analytics Cloud 1.0