Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Gallery Workflows with R Creating Temp File wqy-microhei.ttc

Highlighted
Alteryx Certified Partner

Since upgrading Alteryx Server Gallery to 2019.3.2.15763 the temp directory on our C drive (not the gallery settings specified temp drive or folder) has been filled with a 4MB file called wqy-microhei.ttc.

 

2019-09-20_10-36-45.png


After investigating I've found that Rterm.exe is creating this file and failing to delete it:

 

2019-09-20_10-36-58.png

 

Looking at the timestamps I think it's coming from a workflow which updates Alteryx Connect with data from the Gallery. Anybody seen a similar issue?

Highlighted
Alteryx Alumni (Retired)

Hi @craig_bloodworth,

 

Thank you for posting this question.

 

This is a -completely harmless- side effect of a patch introduced with 2019.3 (DE18722 for reference). 

 

Predictive tools now load R library showtext to address an issue impacting Asian characters.

This library depends on sysfonts and showtextdb that will create font file wqy-microhei.ttc in R temporary folder.

 

Hope this answers your question,

 

Best,

 

PaulN

Sr Customer Support Engineer, Alteryx

 

Highlighted
8 - Asteroid

@PaulN - does this mean we're obligated to manually delete these files + folders?  They add up quickly on the VM that hosts our Alteryx Server.

Highlighted
5 - Atom

Seconding this. These files actually filled up storage on the server and we were unable to run our predictive workflows. Any way to disable this?

Highlighted
9 - Comet

We had several of our scheduled workflows abort last night because there wasn't enough space to write temp files. Everything related to the Gallery should be written to our 😧 drive, but C: was filled with several Gigabytes of the wqy-microhei.ttc file in the temp directory on C:

 

I don't think this is harmless. It is ticking time bomb. I have deleted all those directories now (more than 60 GB), but I need to check our hard disk every now and then, because obviously this is bound to happen again.

Highlighted
Alteryx Alumni (Retired)

Hi @jleung322@raychase  and @chrisha,

 

Thank you for your messages.

 

My original answer was not considering the case of heavily used environments which may lead to the production of a lot of file. Also, current workaround is to manually removed files wqy-microhei.ttc and associated folder,  I would suggest to contact support@alteryx.com for follow-up. 

 

Thanks,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

Highlighted
5 - Atom

Thanks Paul, I have a ticket open with support already and will update here if I receive a better solution.

Highlighted
8 - Asteroid

@jleung322 - that would be great if you can pass along any information you garner from Support.  There simply has to be a better option than a scheduled .bat file to clean up these 'temporary' files.

Highlighted
Alteryx Alumni (Retired)

Hi @raychase, @craig_bloodworth@jleung322@chrisha,

 

I have built a workaround to prevent the creation of these files and an article explaining the procedure will be posted soon.

 

For now, unfortunately, the only workaround is to remove the files manually.

 

Thank you for your patience,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

 

 

Highlighted
9 - Comet

Hey,

 

has there been a fix, workaround, solution, ... made available somewhere?

 

Best

Christopher