Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Stop ERROR when 0 records are read into PYTHON tool

Here's a sample of what you get if no records are read into a python tool:

 

Error: CReW SHA256 (4): Tool #1: Traceback (most recent call last):
  File "D:\Engine_10804_3513901e8d4d4ab48a13c314a18fd1f9_\2f1b1eb4701e445775092128efe77f76\workbook.py", line 7, in <module>
    df = Alteryx.read('#1')
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\export.py", line 35, in read
    return _CachedData_(debug=debug).read(incoming_connection_name, **kwargs)
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\CachedData.py", line 306, in read
    data = db.getData()
  File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\ayx\Datafiles.py", line 500, in getData
    data = self.connection.read_nparrays()
RuntimeError: DataWrap2WrigleyDb::GoRecord: Attempt to seek past the end of the file

 

I've fixed this in my macro by forcing a DUMMY record into the python tool (deleting it on the back-end).  It would be much nicer to have error handling that prevents the issue.  Even as a configuration option, what to do with no input this would simplify things.  

 

This error condition potentially effects every python tool created.

 

Cheers,

 

Mark

8 Comments
patrick_digan
17 - Castor
17 - Castor

Great Idea Mark!

TheOC
15 - Aurora
15 - Aurora

Great idea Mark,
Are we able to fix the 'run workflow to get metadata' error from within macros too? :( 

Thableaus
17 - Castor
17 - Castor

We definitely could use some enhancements on the Python tool, it's about time!

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
clmc9601
13 - Pulsar
13 - Pulsar

Yes please!! Or at least provide a more intuitive error message for some of these Python tool quirks.

clmc9601
13 - Pulsar
13 - Pulsar
adamrice
5 - Atom

Yes please!

nickmartella
7 - Meteor

Bumping this - would love to see this implemented