Catch SQL Action Error Text

1 year 11 months ago - 1 year 11 months ago #21078 by bruce.gibbins

I was wondering if there was a way to catch the Error Text from an SQL Action Item. Typically these actions go through without issue. However, sometimes we may make a slight environment change that breaks a package which we have not thought about or tested thoroughly enough. Then when we check through the child package logs we can easily see what we have forgotten to do. BUT... it would also save some time if the email alert we have could share the text of the underlying issue. This would then allow us to go straight to the source of the problem rather than reviewing the underlying logs.

This is also the case for a Transformation error. The execution log shows the detail of the error but if we could somehow have this bubbled up such that we can assign it to a execution variable then we can include it any email alerts we may send out.

For example, the screen shot shows an SQL Action object that failed as we had not created the underlying SQL stored procedure in the custom schema. Simple, to fix. But it would have been helpful if could catch this message text so that it could be included in the email that gets sent out on a failure. We DO send the package log. But because this is a sub-package, the parent log does not contain this detail. So we need to fire up AETL UI and then review the failed child log and take the appropriate action from there.

Thanks in advance if you see value in this.

Last edit: 1 year 11 months ago by bruce.gibbins.

Please Log in or Create an account to join the conversation.

1 year 11 months ago #21105 by admin
Replied by admin on topic Catch SQL Action Error Text

As requested we added new variables you can use to the Transformation, SQL check, SQL Script, and Import objects.

ETL Architect
The following user(s) said Thank You: bruce.gibbins

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Set of techniques which have for object the commercial strategy and in particular the market study.
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Tools used to give you more features when navigating on the website, this can include social sharing.