Save errors from alteryx gallery to a table in data base

[Youssef_BenSalem]

Dear community 

I have a workflow running on server and i would like to save , at the end of execution , the result message / error in case of errors

Could you please share with me the source ( log files, mongodb...)

Thank you

[JagdeeshN]

Hi @Youssef_BenSalem ,

Have you tried using the Runner Macro (part of the Crew Macros pack). That lets you run a workflow and get the logs(including any errors) as an input stream with the same workflow. 

You can then use this to populate your tables.

http://www.chaosreignswithin.com/p/macros.html

Best,

Jagdeesh

[Youssef_BenSalem]

Hi

Thank you for replying 

Currently i am not using the crew macros,

Is there any other way to track how my workflow running it components 

As i am sure these data are being stored somewhere cause in case of error it shows exactly the ID of the tool wherethe error happened 

[JagdeeshN]

Hi @Youssef_BenSalem ,

I would still suggest looking into the crew macros as that would be the easiest way to export/store logs.

But if you don't prefer that route please refer the documentation below on how to do it on the server itself:-

https://help.alteryx.com/20221/server/configure-and-use-server-logs

[gabrielvilella · Accepted solution]

@Youssef_BenSalem if you want to capture the errors, warnings and any other message from the workflow, you need to enable and use the Engine Logs. 

How to enable https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-to-enable-Engine-Logs/ta-p/545628 

How to use https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Use-Engine-Logs/ta-p/899262 

Example from the article:

[Youssef_BenSalem]

Thank you so much

Exactly what i wanted

[Youssef_BenSalem]

I wanted to use them but I found here many comments suggesting that Alteryx do not support the use of crew macros on server. Also, some said "it is discouraged to use them" . Honestly I am not sure why but i am avoiding the crew macros. Do you have any idea on that matter?

[gabrielvilella]

Crew macros are good as a quick path for some things, but the runner ones are not supported on the Server. It works if you try it, but if something goes wrong, Alteryx will not support that. And you can lose control of which and how many workflows are running.

[Youssef_BenSalem]

I see, thank you for the clarification 

But from what I see they are wodely used. Aren't they?

If so , what kind of problems can they cause on production server?