Qlik Automate: Error 503 calling endpoint "Microsoft Excel - Update Rows In Worksheet"

[Daniele_Purrone]

Updating an Excel Worksheet using Qlik Application Automation leads to Microsoft Excel reporting a 503 error.

Resolution

A 503 (Service not Available) error indicates the target system, in this case Microsoft Excel, cannot handle the calls due to high frequency. To overcome this, a retry mechanism would need to be implemented in your automation, adding robustness in front of those errors.

Attached to this article is a sample automation demonstrating how to handle these errors in the Excel block and implement retry logic when it fails.

Cause

Third-party bottleneck.

Environment

• Qlik Automate
• Qlik Cloud