Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Python tool not seeing data from input tool

charter747
6 - Meteoroid

Hello. I'm working with the python tool and I keep getting an error that no data was passed to the python tool. I'm getting this error when running the flow our alteryx server gallery. When I run it on my laptop, it works fine. I know that the input step grabbing the AVS.csv works on both my laptop and the server. I have no idea why this is not working.

 

I googled the error message below and see it appears when an empty dataset is passed to the python tool. In my case, that is not the issue; the AVS.csv has 900,000 rows. Any help would be greatly appreciated.

 

This is the flow. Very simple.

charter747_0-1651176706587.png

 

This is the code that's inside the python tool.

charter747_1-1651176744071.png

 

 

 

 

 

 

 

 

 

 

 

 

 

This is all the info returned after I try running my flow.

 

charter747_2-1651177317524.png

 

3 REPLIES 3
AkimasaKajitani
15 - Aurora
15 - Aurora

Hi @charter747 ,

 

According to row 2(File Input) of info, the File input tool can't read the file that shows 0 records were read from the file.

 

It seems that this file is put in the shared folder. Regarding this situation, I think this problem is not a python tool but also the access right of an account problem. 

 

Normally, if you run the workflow on the Gallery, it runs as Service Account. I think the Server's Service Account doesn't have access right of the folder that you want to read from.

 

Please contact the Server Admin and check the access right of the Service Account. Depending on the situation, it will be needed to set the Run As a user.

 

charter747
6 - Meteoroid

Thanks for your input Akimasa.

 

Both Alteryx laptop and Alteryx server can access the Shared Folder.

 

If I remove the python tool piece from the flow, it all works. I'm able to save it and run it on the server. But once I reinsert the python tool, I get the error mentioned before.

 

This flow works:

charter747_0-1651243548315.png

 

 

This flow does not work:

 

charter747_1-1651243721364.png

 

The python tool errors and says it received no data from the input tool.

AkimasaKajitani
15 - Aurora
15 - Aurora

Hi @charter747 

 

My concern was that the gallery and Designer on the server would run with different permissions. So, the permission of the shared folder will be different. If it is no problem, I recommend to contact the Alteryx support team.