topic Re: Executing snowflake stored proc and catching errors... in Talend Studio

Executing snowflake stored proc and catching errors...

gurn — Fri, 15 Nov 2024 21:33:34 GMT

I have a job that is calling a Javascript stored procedure in Snowflake using a tDBRow component within my Talend flow.

The issue I have is that I'm forcing a failure of the SP which is correctly catching and returning the error if I run from the Snowflake UI. However, my tDBRow thinks the SP completes ok and so just continues through the SubJob OK rather than being caught by the On Component Error path.

Any one have any ideas how to ensure I can capture the flow correctly?

Thanks

Re: Executing snowflake stored proc and catching errors...

anselmopeixoto — Thu, 20 Jul 2023 19:51:59 GMT

Hi @Dave Gurney

Have you enabled the "Die on error" option of tDBRow component?

Re: Executing snowflake stored proc and catching errors...

gurn — Fri, 21 Jul 2023 07:40:54 GMT

Solved - I realised I'd not used the throw routine in my try-catch-throw.

throw raises an exception which is then caught by Talend as expected.

Re: Executing snowflake stored proc and catching errors...

Anonymous — Mon, 24 Jul 2023 03:56:44 GMT

Hello,

Thanks for letting us know you've resolved this issue by yourself.

Best regards

Sabrina