Python tool not seeing data from input tool

Question

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.

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

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

AkimasaKajitani · Answer

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.

charter747 · Answer

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:

This flow does not work:

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

AkimasaKajitani · Answer

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.