Email Render Tool: System cannot find the file specified

Question

Hello,

I have created a workflow that can send multiple personilized files to the corresponding emails.

I can only upload screenshots because the workflow consists of sensitive data.

When I upload the workflow to the Alteryx server we get an error:

Record#1: Error Opening file: D: \ProgramData\Alteryx\Service\Staging\......\*.pdf: The system cannot find the file specified.

Why is it looking for a file there? I have saved all generated pdf with the render tool with unique names and added them as attachments on the email tool using the field: Filename.

It works locally but the server has restricted access to folders. Can that be?

Thanks for the help

wwatson · Answer

You could save the file in the current folder (.\filename.pdf) then read it from the .\ location in the email tool. I would use a hold until done to make sure the file has saved before trying to attach it to the email.

Dennisklad1 · Answer

That didnt do the job. I still get the error

Where the filename is just the resource name + pdf.

Thanks

c-lopez · Answer

I would store the PDFs to [Engine.TempFilePath] rather than a specific location on your computer and then use the same variable when getting the path of your PDF on the email tool.

Server does not know about your machine's folder structure and the folder structure of the machine hosting Server will probably be different that is why it cannot find the PDFs you created. With the temporary file path used for execution of the workflow things should be more dynamic.

I hope this helps