Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Save errors from alteryx gallery to a table in data base

Youssef_BenSalem
7 - Meteor

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

8 REPLIES 8
JagdeeshN
12 - Quasar
12 - Quasar

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
7 - Meteor

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
12 - Quasar
12 - Quasar

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
14 - Magnetar

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

gabrielvilella_0-1668568065632.png

 

Youssef_BenSalem
7 - Meteor

Thank you so much

Exactly what i wanted

Youssef_BenSalem
7 - Meteor

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
14 - Magnetar

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
7 - Meteor

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?