
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Executing snowflake stored proc and catching errors...
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Dave Gurney
Have you enabled the "Die on error" option of tDBRow component?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Thanks for letting us know you've resolved this issue by yourself.
Best regards
Sabrina
