Error handling by storing error and tool details which causes error in DB.

Question

Hi All,

I am new to Alteryx and looking for error handling options, apart from event (on error).
I need to store the tool name (which causes error) and error details in SQL database in case my workflow get failed.

In Snaplogic, we have error pipeline. If any snap causes error in main pipeline, we can call error pipeline and store the error, snap name, pipeline name and time in database.
Do we have any option like this in Alteryx.

Appreciate quick help on this.

Thanks 
Anchal

BrandonB · Answer

@AkshataK since then Alteryx has released customer managed telemetry which provides quite a bit more information than previous methods: https://community.alteryx.com/t5/Engine-Works/Customer-Managed-Telemetry-A-Window-into-Workflow-Transparency/ba-p/1081472

This article shows how to enable it.

If you would like to use the older methods you can follow the answer in this link: https://community.alteryx.com/t5/Alteryx-Server-Discussions/Save-workflow-log-in-SQL-database/td-p/1180523#:~:text=You%20can%20either%20enable%20a,for%20when%20the%20job%20started.

"You can either enable a setting in the Alteryx System Settings under Engine > General and add a path in the Logging Directory field. Anytime the server runs a workflow, the message log will be written to that location and named with the timestamp (EPOCH formatted) for when the job started.

The other option would be pulling it directly from Alteryx Servers MongoDB, which can be a bit tedious if you're not familiar with the collection schema."

AkshataK · Answer

Hi Brandon, The link seems to be archived now. Would you have another example where this requirement has been achieved?

AnchalJain · Answer

Hi,

Thanks a lot for the link shared. It will help.