topic 502 / 504 Error from Add Row to Table in Qlik Automate

502 / 504 Error from Add Row to Table

gns6543 — Mon, 22 May 2023 15:43:27 GMT

Hi all,

I currently utilize Copy data from Qlik Sense straight table to an Excel sheet to download data into the Excel file.

When the automation process runs, it runs perfectly fine and generates the Excel file, but occasionally I get a 502 Error from Add Row to Table process.

Can anyone explain why I encounter this issue and how to resolve it?

Re: 502 / 504 Error from Add Row to Table

AfeefaTk — Tue, 23 May 2023 03:48:40 GMT

Hi @gns6543

The 502 / 504 error is from the Microsoft Excel API side due to some temporary server outage.

More details can be found here

Thanks

Re: 502 / 504 Error from Add Row to Table

gns6543 — Tue, 23 May 2023 17:59:34 GMT

Hi AfeefaTk,

Thanks for your answer.

If this error happens, I want to set a condition to reload the automation process again.

I've been researching some videos on using condition blocks, but I can't find anything related to this error.

Do you know what value I need to put in the condition block if 502/503/504 error happens?

Re: 502 / 504 Error from Add Row to Table

AfeefaTk — Mon, 29 May 2023 06:55:49 GMT

Hi @gns6543

You can add an error formula in the condition block to check the error status.

Something like this: { $.state.addRowToTable.error.response.status }

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/working-with-automations/working-with-errors.htm

Please take a look at the section: 'Catching errors' in the above link.

Hope this helps!

Thanks!

Afeefa TK

Re: 502 / 504 Error from Add Row to Table

sahikha56 — Mon, 12 Jun 2023 17:43:32 GMT

The web browser uses browsing data from past sessions to load up your QuickBooks page. QuickBooks Online is essentially a website just like any other. And on that website it will store data for your next session so that it can load up faster. If for some reason we do an update or chrome does an update or we have to refresh our systems after an outage, then that data will become corrupt triggering an error whenever you go to login.

JJSploit