topic Re: Save errors from alteryx gallery to a table in data base in Alteryx Server Discussions

Save errors from alteryx gallery to a table in data base

Youssef_BenSalem — Mon, 14 Nov 2022 15:17:10 GMT

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

Re: Save errors from alteryx gallery to a table in data base

JagdeeshN — Mon, 14 Nov 2022 22:43:07 GMT

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

Re: Save errors from alteryx gallery to a table in data base

Youssef_BenSalem — Tue, 15 Nov 2022 19:32:10 GMT

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

Re: Save errors from alteryx gallery to a table in data base

JagdeeshN — Tue, 15 Nov 2022 20:49:17 GMT

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

Re: Save errors from alteryx gallery to a table in data base

gabrielvilella — Wed, 16 Nov 2022 03:08:02 GMT

@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:

Re: Save errors from alteryx gallery to a table in data base

Youssef_BenSalem — Wed, 16 Nov 2022 18:55:33 GMT

Thank you so much

Exactly what i wanted

Re: Save errors from alteryx gallery to a table in data base

Youssef_BenSalem — Wed, 16 Nov 2022 18:59:24 GMT

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?

Re: Save errors from alteryx gallery to a table in data base

gabrielvilella — Wed, 16 Nov 2022 19:06:38 GMT

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.

Re: Save errors from alteryx gallery to a table in data base

Youssef_BenSalem — Wed, 16 Nov 2022 19:12:11 GMT

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?