topic Re: Alteryx Server Error Monitoring in Alteryx Server Discussions

Alteryx Server Error Monitoring

jmelik — Mon, 04 Nov 2019 20:30:38 GMT

I'm looking to create a custom workflow to monitor scheduled jobs on the server that cause and Error. This is outside of using the events email notifications. In the Alteryx Service MongoDB and I can't locate how workflow errors are captured in the database. The closest I can find, the AS_Queue collection has a Status column, but even if a workflow ends in an error, this column is stating, "Complete."

Two questions:

1) Does anyone know how to identify workflow errors in MongoDB

2) Would it make sense to propose having the Status column in AS_Queue say something other than "Complete," in the event of a failure.

Re: Alteryx Server Error Monitoring

MichalM — Mon, 04 Nov 2019 20:58:55 GMT

@jmelik

1) The workflow status data is stored in the Service data blob within the AS_Queue collection. We provide a pre-canned Server Usage Report workflow which you can download from https://downloads.alteryx.com under Alteryx Server. When you look at the embedded macro, this queries the AS_Queue collection to extract Job IDs and then uses these to parse the service data to get the workflow run status - AlteryxResultCode.

Code	Status
0	Success
1	Warning
2	Error

2) I agree that it would make sense to have the status available directly in Mongo. It might be worth submitting it as a Product Idea via our suggestion board.

Re: Alteryx Server Error Monitoring

jmelik — Mon, 04 Nov 2019 23:07:32 GMT

This is perfect, thank you!

Re: Alteryx Server Error Monitoring

AijajShaikh2021 — Tue, 09 Mar 2021 06:13:39 GMT

Hello,

Could you please upload workflow to test on Alteryx Server.

Re: Alteryx Server Error Monitoring

agomoll — Wed, 20 Sep 2023 18:00:51 GMT

Hi,

It appears that the Status field in the AS_Queue collection is now outputting 'Complete', 'Error', or 'Running' (at least for my workflow). How is the error designation assigned? Is this different from how errors are recorded in the Service Data BLOB?

Thanks in advance