Cannot create new files using output data tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I recently updated to version 2023.1.1.123
this issue is regardless of output file type (excel vs DB). The below example is with using Alteryx DB which recreates the DB every time the workflow is ran
Then I started a workflow created in a previous version (last version of 2022). The workflow ran fine until the end where it is supposed to update a DB. The workflow stated the DB was updated but the file did not contain the new data. So I decided to delete the DB so it would rebuild it. It did not, gave me an error that "the system cannot find the file specified"
So then I decided to recreate the output tool, added the file name etc. and hit ok. Hoping it would just rebuild the file as that is what its supposed to do anyway. Once I reran the workflow, I keep getting the following error:
File not found. Check the file name and try again.
Why is it looking for a file if the file does not exist? Did anything change in 2023 version of Alteryx?
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kams01 for the output data tool, in the tool configuration window when you click Set Up a Connection, choose Files then Select file in the top-right. Choose the destination where you want to save it, then in the File name section, type in the name of the file you want to create, then click save (see screenshot).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is what I am doing but I keep getting the same error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
it seems it has to do with the folder as its under one drive however the files are all local and synced to onedrive. not sure why this changed after updating from 2022 to 2023
Is there a spot where I need to make access changes?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Updating to 2023.2.1.194 has not helped
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kams01 hmmm...I'm not sure. I know that for my organization, we have shared drives which have to occasionally be updated to allow Alteryx to read/write to a folder in the drive.
Sorry, I'm not sure what else it could be.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!
Upon further looking with the IT department, it seems its related to an internal change within the security policies that were pushed earlier this week. Other users within my company are having the same issue. So most likely will be resolved shortly. Thank you for everyone who chimed in
