topic Re: Transient error handling in Azure in Talend Studio

Transient error handling in Azure

maayandermer — Sat, 16 Nov 2024 07:17:38 GMT

Hi,

Recently I started to have some kind of weird error in my ETL processes. After investigating it with Microsoft support I ended up here:

Apparently in Azure SQL Server encountering transient errors is ok (?!?) due to maintenance issues.

Can you share you best practices for restartibility of Jobs/components in a job? For example how would you manage a retry-restart of a whole map?

Maayan

Anonymous — Mon, 26 Nov 2018 10:15:00 GMT

Hello,

You can start Job from tLoop or tInfiniteLoop and finish with tSleep component.

Have you tried to setup Job schedule to see if it is OK with your use case?

Best regards

Sabrina

maayandermer — Tue, 27 Nov 2018 03:58:35 GMT

Thanks for the reply. We manged create the logic you suggested and it is working. We also added tChronometer for timeouts in case it gets hanged.

Thanks!

Anonymous — Tue, 27 Nov 2018 06:16:55 GMT

Hello,

Great it helps. Thanks for your prompt reply.

Best regards

Sabrina