Field Summary tool temp file persistent error

[david_fetters]

Tried finding a topic on this, but could not (apologies if I did not search enough!)

Our firm uses alteryx designer on all of our machines.  Regardless of what machine is running it, we always get an error with the field summary tool.  The error is:

>Error: Field Summary (166): Tool #275: Tool #105: File not found "D:\Alteryx Temp >Directory\Engine_5832_f1ded0f019364b6aaf45e47f7388f0ad_\__temppath__.txt"

The tool still works despite the error, but it causes alarm to the analysts when an error pops up in our macros that use the field summary tool.  Anyone have any ideas how we can fix this?

[s_pichaipillai]

looks like the path is invalid

did you override system setting in your wrokflow designer?

can you check the path and provide valid one?

it should be something like below path

C:\ProgramData\Alteryx\Engine

[david_fetters]

Our temp folder is setup on the d drive (HDD) rather than our C drive (SSD). Im not sure what specific setting you're asking me to change, but everything else seems to point to the right place. Only the field summary tool has this issue.

[s_pichaipillai]

David,

can you go to system settings and navigate to the Engine configuration as below and see what path provided

as per your error message the ">" before Directory seems strange to me 

D:\Alteryx Temp >Directory\Engine_5832_f1ded0f019364b6aaf45e47f7388f0ad_\__temppath__.txt

[simon]

That 'Engine...' path looks like an Alteryx temp folder. It changes every time you run that module/macro/app.

I would check workflow dependencies and see if you have a relative %temp%\ or .\ in your path instead of an absolute path.

[david_fetters]

Sorry about the angle brackets, those are not present in the text and i realize now they are misleading.  Our temporary directory is set to D:\Alteryx Temp Directory

[david_fetters]

It appears that the problem is within the internal macros inside Field Summary, Tool 275: Tool 105, which I tracked down to this: 

Im not necessarily excited about the idea of changing one of the built-in macros

[simon]

there ya go. IMO, that %temp% is asking for trouble. 

Maybe drop that path in a batch file and run that. Then you don;t need to change your macro - well, only once to start using a batch file.

[david_fetters]

The issue is not with a macro that I've created (although mine have a few of their own unique problems), that error is buried inside the Field Summary tool in the official Data Investigation tool set. That's why I'm reluctant to change anything with it because I'm not exactly sure what it does or needs to do

[simon]

I see you point. Are you able to run a test module using that macro?

my output comes from here.

File_Input: Run Command (105): C:\ProgramData\Alteryx\Engine\Engine_6572_53a4c5fc88f44626ab26b2f5bcbd7000_\__temppath__.txt|1 records were read from "C:\ProgramData\Alteryx\Engine\Engine_6572_53a4c5fc88f44626ab26b2f5bcbd7000_\__temppath__.txt"

Look at your global workspace. mine is C:\ProgramData\Alteryx

Also, your D path has a space in it. Maybe I'm oldskool but I always avoid spaces in path and file names...

If all else fails there always client services :)