Symptom
- If you execute an API in a story from SAC (with an API step in a Multi Action), it runs 2 or more times.
- This API is run synchronously.
- The issue does not always happen. Sometimes the API runs once only, which is as expected.
- It takes some time for this API to be completed. It is not completed quickly.
- If you execute this API from other REST API clients, the issue does not happen.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Create a multi action that contains the HTTP API step.
- Run the multi action from the story.
- In the target system, you observe that the API is run twice.
Cause
It is related to a timeout. Our service does include a retry mechanism that is triggered after a significant delay without response.
Resolution
Typically, if a request that involves different system connections takes more than 5 minutes to receive a response, it's best practice to invoke this API with an asynchronous call. Please try to avoid the use of such long-running APIs.
- It is recommended to develop a new API that can run asynchronously. The design of the asynchronous API should adhere to common standards:
Upon successful triggering of the asynchronous activity, the HTTP code should return 202. This indicates that the remote API has initiated the processing of the backend job in the remote system.
For more details, please refer to the section "According to the common design standard" in this blog post: https://blogs.sap.com/2022/10/27/integrate-external-applications-using-multi-actions-in-sap-analytics-cloud/ - Please configure the API step to run asynchronously:
Please proceed to the API step's configuration panel, expand the "Get API Execution Result" section, and select "Asynchronous Return" as the method of request for "Get API Execution Result", instead of "Synchronous Return". Subsequently, please complete the other fields that appear once you select "Asynchronous Return".
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, multiaction, multi-action, APIs, REST, SAP Cloud Platform API, executed, called, ran, finished, more filters , KBA , LOD-ANA-PL-MA , Multi Actions , Problem