Writing to/reading from Temp Files Chained App

kylemhabe

Hello,

I have developed a chained app that writes to temp .yxdb files in the first workflow. The second workflow reads from these temp files and does further data manipulation. I am publishing this app to my firm's server so that those without Alteryx Designer can run the application. This app works on my machine but I have been having trouble getting it to work on my firm's server. Essentially, the first workflow (writing to the temp files) runs fine;however, when I run the second workflow (reading from the temp files), i receive the following error messages:

I saw a few posts with a similar issue but could not find a clear solution.

Here are how my how my input/output tools are configured. 

I also tried to write/read to regular .yxdb files with relative paths;however, I was receiving an error after the first step that I do not have access to the directory when trying to write to the .yxdb files.

I guess that I may need to get my firm's Alteryx server team involved but I figured I'd ask here.

As well, this app needs to be run in two steps because it is possible that the user may need to update an input file after the first workflow is run.

Best,

Kyle

blyons

The relative paths are important and can be tricky. Options->Advanced Options->Workflow Dependencies definitely help with that.

However, the main issue for us turned out to be permissions on the server. The account configured to run the worker needed to be granted explicit full-control permission to the Service\Staging folder. This was very odd because the account was already in the local administrators group, and the "effective permissions" already showed as full control. However granting that specifically to the account solved the problem.