Large files causing workflow to fail

Question

I have an app that a user selects a file to upload - that file is an XML file and its massive, Alteryx then extracts the data from the XML and compares it to data in our production database. Anyway, this has been working for about 4 or 5 years with no issues until the last update.  Now it just gives an error, the action tool ~325 has an error, the file name is empty.  Tool 325 is the action tool, directly after the file browse tool - Im wondering if this is a bug or something in the latest version?

craigja · Answer

Hi - its the Update Input Data Tool (same as your screenshot) that Im using.  What I have noticed, in other workflows, when importing an xlsx file, it now takes a few seconds longer to bring up the dialog allowing you to select the excel tab after browsing for a file.  You are able to click the Run button before this has happened and you get the same error message.  I wonder if Alteryx now needs to load in the file before it can continue?  In the case of the xlsx files its obvious its not loaded yet as its not asked what tab name you want, but as this is an xml file, there is no other dialog, and I wonder if its not loaded the file in the background or something when people click run?

BrandonB · Answer

How is the action tool configured? Strange that it would say the file name is empty when you are using a File Browse tool. If you are using the "update value" option rather than "Update Input Data Tool" option I would recommend giving Update Input Data Tool a try.