This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been having an issue with several workflows running on the Alteryx Server. The jobs run fine (data outputs to Tableau at the end) but the job shows an error and doesn't display a time for the workflow run. When I check the logs in MongoDB I see the error:
Mongo error: "Document 0 is too large for the cluster. Document is 52201114 bytes, max is 16777216.: generic server error" code: <mongodb:18>
I've run some tests and found that when I delete the dynamic input tool from my workflow, the error goes away. I have a feeling that the dynamic input tool is causing a large amount of data to be written to Mongo, but I don't know how to change this other than to not use the tool (I mostly use it to look up extra information from a database downstream of my initial query, then join it back in to my main data stream).
I actually figured it out. I was right about the messages causing the memory problem in Mongodb. When I put portions of the workflow that had a dynamic input into a macro and suppressed macro messages, the error went away: