Executing snowflake stored proc and catching errors...

[gurn]

Hi

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

[anselmopeixoto]

Hi @Dave Gurney​ 

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

[gurn · Accepted solution]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina