This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
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.
I think the trick here is relative paths and folder structures.
Please attached a zip which contains the following folders:-
1. workflows:- Consists of the two applications.
First Application.yxwz is the workflow that reads data and writes into yxdb. Second Application.yxmz is meant to do the transformations on the data written earlier. It then stores this transformed output into new yxdb for demonstration purposes.
2. data files:- Consists of all data files.
This includes the yxdb's created by First Application.yxwz and the Second Application.yxmz
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.