Application error on the server

[josephatnjoroge]

Hello Team,

I am publishing an application to the gallery with seven chained applications. All my input and output files are relative. The application runs successfully on the designer but after publishing it on the server. It shows the following error. Kindly help.

• Error opening the file "Record #1: Tool #199: C:\ProgramData\Alteryx\Service\Staging\32796_a1563f70953d48c497e876f83430c4b9\_externals\3\section15(2g)_schedule.yxdb": The filename, directory name, or volume label syntax is incorrect. (123) (ToolId: -1)

[DataNath · Accepted solution]

Does the machine running your server have access to this directory? If not, the application won't be able to run as it's trying to reference a local location that it can't communicate with. I believe the best approach for running apps that constantly reference changing input/output files is to used a shared network drive where files are visible/accessible to both users on their local machines, as well as the machine hosting your server.

(The reason it currently runs fine in designer is because your local machine can access the file).

[dana_mcdonough]

@josephatnjoroge - this article is a good checklist to run through regarding your input/output paths: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Can-t-find-the-file-path-File... 

You can also review the Server-specific help article regarding permissions to run on Server: https://help.alteryx.com/20221/server/configure-required-run-user-permissions

Feel free to share your workflow for further review.