Validation error when publishing workflow with FTP Upload Macro.

[David_G]

Hello guys,

I'm working on a workflow to produce a csv file and then upload it to a ftp server.

I'm using this tool (tool #51) : Ftp Upload Macro 

The workflow runs fine in designer but a validation error occurs when i publish it on alteryx server :

[Fichier contacts.yxmd] Tool -1 - Tool #51: Tool #1: ---------------------------------------------------------------------------
RuntimeError Traceback (most recent call last)
 in
 5
 6
----> 7 param = Alteryx.read("#1")
 8 host = param.values[0][1]
 9 username = param.values[1][1]
c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\export.py in read(incoming_connection_name, debug, **kwargs)
 33 When running the workflow in Alteryx, this function will convert incoming data streams to pandas dataframes when executing the code written in the Python tool. When called from the Jupyter notebook interactively, it will read in a copy of the incoming data that was cached on the previous run of the Alteryx workflow.
 34 """
---> 35 return __CachedData__(debug=debug).read(incoming_connection_name, **kwargs)
 36
 37
c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\CachedData.py in read(self, incoming_connection_name)
 304 try:
 305 # get the data from the sql db (if only one table exists, no need to specify the table name)
--> 306 data = db.getData()
 307 # print success message
 308 print("".join(["SUCCESS: ", msg_action]))
c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\ayx\Datafiles.py in getData(self, data, metadata)
 498 if data is None:
 499 # read in data as a list of numpy ndarrays
--> 500 data = self.connection.read_nparrays()
 501
# check if data is a list of numpy structs
 502 elif isinstance(data, list) and all(
RuntimeError: DataWrap2WrigleyDb::GoRecord: Attempt to seek past the end of the file

If I'm missing something, please let me know.

cheers,

David.

[danilang]

Hi @David_G 

This appears to be an error in the python routines when you try to pass 0 records to an input.  Check out this post for a couple of possible solutions

In your specific case, you can add a Message tool to count the number of records going into the download macro.  The output will show up in the results of the workflow before the error.

Dan