3794700 - Refresh all fails with “Destination host is unreachable” or “Current operation cancelled by request and transaction rolled back” in large workbooks using GETDATA formulas — SAC Add-in

• Refresh All on an Excel workbook containing a very large number of SAP.GETDATA formulas fails intermittently.
• Refreshing individual sheets usually succeeds.
• Error messages observed:
  “Destination host is unreachable!”
  “Current operation cancelled by request and transaction rolled back”
  "HTTP 502"
• The issue is not reproducible in an SAC story based on the same model.

SAP Analytics Cloud, add-in for Microsoft Office

1. Open an Excel workbook that contains a large number of SAP.GETDATA formulas.
2. Sign in with the SAP Analytics Cloud, add-in for Microsoft Office.
3. From the add-in ribbon, choose Refresh, then select Refresh All.
4. After processing for some time, observe one of the following errors: “Destination host is unreachable!” or “current operation cancelled by request and transaction rolled back.”
5. Note that refreshing a single sheet typically succeeds.

• A very large number of SAP.GETDATA formulas leads to heavy processing during Refresh All and large combined request payloads.

1. Enable the “Optimize Data Retrieval” option in the workbook preferences of the SAC add-in.
2. Reduce the number of SAP.GETDATA formulas where possible (for example, add filters, aggregate data, or split the workbook into smaller workbooks).
3. Limit the use of complex measures (for example, YTD) in SAP.GETDATA requests where feasible to lower processing cost.

• GETDATA functions – SAP Analytics Cloud, add-in for Office
• Note 3627929 - Long refresh times for big files containing GETDATA formulas in SAP Analytics Cloud add-in
• Note 3323835 - GETDATA performance optimization by customizing drill level
• Note 3664247 - “Refresh all” error in SAP Analytics Cloud, add-in for Office

sac add-in, excel, getdata, refresh all, destination host is unreachable, current operation cancelled by request and transaction rolled back, error 502, large workbook, performance, timeout, content-length, getresponse, optimize data retrieval, ytd measure, transaction rolled back , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem