How To Load Alteryx Error Into Table

[shashank_shukla]

Hi All,

Good Evening,

Use Case:-

I have Alteryx Workflows scheduled on Alteryx Gallery which will run on Daily and weekly basis respectively.

If my workflow gets failed then the error code and message has to be store in Redshift table with System date and the table will be drop and create.

Kindly let me know the steps which is required to complete this scenario.

If possible kindly share the sample workflow as well.

Thanks & Regards,

Shashank R. Shukla

[MatthiasSeil]

Hi Shashank,

First of all the Logging of the Engine(s) needs to be activated if not already done yet. This needs to be done via the Server instance admin.

Here are more details about this:

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-To-Attach-Server-Log-Files/ta-p/6...

You should then set the workflow not to write data whenever an error is occurring:

For parsing the log files you need to create a separate workflow which parses the log files from the folder and writes to Redshift. Also here access to the Server instance/log folder is key.

The log parser macro from the Crew Macro pack may be of help here: 

http://www.chaosreignswithin.com/

Or this App here could be of value for you as well:
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-To-Obtain-Logs-the-Easy-Way/ta-p/...

Kind regards

Matthias