topic Re: Un-Blobbing MongoDB results OutputLog in Alteryx Server Discussions

Un-Blobbing MongoDB results OutputLog

Kmaclean — Thu, 20 Jun 2024 19:27:14 GMT

So I am connecting to our Alteryx MongoDB (2023.2 patch 3) via odbc connection and I am wanting to access the outputlog for the jobs, However the log is stored as a Blob in "Binary format" and I am wondering if there is an easy way to extract the logs, all of the settings in the Blob convert tool haven't been working for me.

Re: Un-Blobbing MongoDB results OutputLog

Ariharan — Sat, 22 Jun 2024 19:27:19 GMT

Hi @Kmaclean ,

By using the Alteryx Server Usage Report, you can leverage the Service parser macro to access the blob data. All you need to do is open the pre-built "Server data parsed" macro and incorporate it into your new workflow to effortlessly retrieve the blob data.

Regards,

Ariharan Rengasamy

Re: Un-Blobbing MongoDB results OutputLog

dv735 — Thu, 01 Aug 2024 11:29:46 GMT

Hi, I am also trying to derive human readable information from outputlog to see status of completed scheduled jobs - does ServiceDataParser macro still work on 2023.2 or is there another method to achieve this please?

Re: Un-Blobbing MongoDB results OutputLog

venza — Wed, 21 Aug 2024 12:51:15 GMT

Hello,

There is no Alteryx Server Usage Report for the 2023.2.X version listed on the download site, where can we find it ?

Re: Un-Blobbing MongoDB results OutputLog

patrick_digan — Wed, 21 Aug 2024 13:20:21 GMT

@venza @Kmaclean @dv735 I'm attaching the Service Data Parser macro here that still works on 23.2 for fields like the OutputLog in the ASResults table

Re: Un-Blobbing MongoDB results OutputLog

dv735 — Thu, 22 Aug 2024 14:58:46 GMT

Thank you for response and copy of macro. Unfortunately, I get errors in the first two steps of the macro.