ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Python Tool Error - DataWrap2WrigleyDb

MatthewP
Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer
    • All versions
  • Python Tool

Error Message from the Python tool (See screenshot):
DataWrap2WrigleyDb::GoRecord: Attempt to seek past the end of the file



Cause


The cause of this error is from one of the incoming data sources having 0 records. If you see the below example, it has two data sources: the first one has 0 records and the second one has 1 record.


If you use the Alteryx.read() function on the first incoming connection you will run into the error:



Resolution


There are two ways of resolving this error:
  1. Double check the incoming data source that is causing this error (you can determine which data source it is by the error message in the Python Tool or the Results window). Once you identified the data source that has 0 records, fix the data source itself (if it is meant to have records/data in it).
  2. If you want to have data sources that may come in with 0 records but want the Python tool not to error, you can try a try-catch block similar to the below code that will allow for incoming data sources to be "skipped" if they have 0 records.
 

You can see that it still threw an error for the first input data connection but it continued to read in data connection 2 and you would be able to keep nesting try/catches and If statements similar to this.