Event -

[Tienemientje]

Hi,

I would like to create an event that sends me a mail when a (scheduled) flow runs with errors.

I have found documentation on how to adapt the email, but is there a way to only show errors from the outputlog?  Some of my outputlogs have quite some warnings or conversion errors and it is difficult to find the "real" errors.  
So at least I want to add them on top, like shown below.

Or is there a way to influence (filter) the outputlog to only show errors?

User: %User%
ComputerName: %ComputerName%
WorkingDir: %WorkingDir%

Errors: %NumErrors%
Conversion Errors: %NumConvErrors%
Warnings: %Warnings%

--- Errors ---
%Errors%

--- Full Log ---
%OutputLog%

[abacon]

@Tienemientje No there is not a way to only show the errors from the log that I know of using this method. A trickier method is to pull the logs from either the server using the API or the backend DB, and parsing through them in another workflow. Not exactly the best option.

Are you looking for specific error handling checks you have built or any error in general? If you are looking for error handling checks you have built, super easy to add into the failure event. If you are looking for errors in general, I usually open the email and do a find for the word error - another option is to go to the job in the Alteryx Server and that will show the errors in red text. I know that's not showing it in the email but still pretty easy to do.

Bacon

[jrlindem]

Found an old post:

Solved: Logging workflow metadata after run to Database - Alteryx Community

I also found some information on using Crew Macro:  Log Parser Tool.  Admittedly haven't used this myself, but some internet searching suggests it might be useful.

-Jay

[Tienemientje]

Thank you @abacon .

I was just exploring some possibilities.  No specific error, but I got a bit lost in the big log with quite some conversion errors.  

I also wanted to share the mail with some other users and it would have been nice that the focus could be on the errors.  Going to Alteryx is an option, but I believe those others cannot see the automated runs from my flow even if the flow is shared with them.

I have limited API access, I can explore that, but it might be a bit much for what I want to achieve.  I just wanted to ask around in case I missed an easy obvious solution.

My actual original need was to know why/that an automated flow did not run.  But even these error mails wouldn't help, because the flow was disabled (without my knowledge).

[Tienemientje]

Thank you @jrlindem , unfortunately most of the links in the post are archived and the others did not really provide what I wanted (or not in an easy way).

Just wanted to check with the community if it was possible in an easy way.

Thank you for trying to help!

[abacon]

@Tienemientje What I did to do this was create two events - one for if the workflow ran with errors, and one for if the workflow ran without errors. The ones I created to run successfully were sent to a folder I created in outlook so I didn't have to see them every day, but I knew if there were no emails, failure or success, I know it didn't run.

There is an option to send email after disabled too, try that option in your testing.

A workaround to the issue of others seeing the flows runs is to use the Server Usage Report - https://help.alteryx.com/current/en/designer/workflows/enterprise-utilities/server-usage-report.html

I built a dashboard and workflow using these connections that allowed my team to see others workflow runs even if they didn't own it.

This is done by tapping into the MongoDB persistence layer and using that information to see the logs of all workflows on the server, regardless of who runs it.

Bacon

[dreldrel]

As far as I know, there is no way to only show the errors from the log at the moment