Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

.tde file not being overwritten - Alteryx Scheduler Error

Highlighted
Alteryx Partner

Hi All,

 

From the raw file - I output the files in two formats - one a csv - around 2 gb in size and the same as a .tde which is ~ 140 MB in size.

Since last month  - on few occasions,  I have faced the issue of my .tde file not being overwritten - The workflow runs via Alteryx scheduler.

 

Solutions -  I think it can be a permission issue or someone using the .tde when the workflow runs can also be one of the issue.

Workaround - I think outputting the file to a SQL database can be one of the workarounds.

 

Let me know if I have any other workarounds here.Thanks.

 

Regards,

Rahul

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Yes; if the file is open by another user then the file will lock (this is the same for a lot of filetypes).

 

As you mention this should be fine using SQL Server, or alternatively, publish the datasource directly to Tableau Server, and then this conflict won't occur either.

 

Ben

Labels