@chvizda this is probably to do with the permissions that the user associated to your Server has on that table. Can you check this?
Alternatively try to set the workflow up on Server to Run As a different user ie. the one that's used in Designer:
https://community.alteryx.com/t5/Alteryx-Server/Run-As-Settings/ta-p/17830
For quick proof of security problem, run the workflow on server as the service account using designer instead of gallery. For me it is easier to see details of the error and pass them on to dba as a security change request.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |