Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Alteryx Server Usage Report

MM_Chris
8 - Asteroid

Hi there,

 

I am running the Usage Report from both local and on the production gallery, and every time I run the PDF output for 30 days, I keep getting an error that says "Out of Memory" from the render tool. Is there a memory cap that the Render tool can handle?

 

The App Execution Excel output is less than 1MB, so I don't see why it would be out of memory.

4 REPLIES 4
r4upadhye
11 - Bolide

It may happen if the app data is too large to handle for render tool, try to summarize it.

Can you share your flow?

MM_Chris
8 - Asteroid

I forgot to update this, but I worked with Support to find the problem. It is because the data entering the Render tool for the AppExecutions file is too large. Even with 12GB of RAM it still errors out. But we figured out work around for this, which is using an Output tool right before we use any Reporting tools. 

Ambar
5 - Atom

Hi Chris, can you please explain in more detailed how you solved it? Thanks.

EdP
Alteryx
Alteryx

 

The change suggested above would add an output tool in the Alteryx_Server_Usage_Report.yxmc macro, right about here:

EdP_1-1651176135495.png

 

This will be in the PDF Report container, so you will probably need to minimize the Tableau Report container and expand the PDF one to see these tools.  I would also recommend Putting the tools after that sort into another container and disabling it so the error doesn't show up.  Since you also want to filter on workflows, you could also put a filter here as well and set it for the [AppName] table.  The AppName should be the workflow file name without the extension.

Ed Phelps
Sr CSE
Alteryx