Knowledge Base / Server / Prevent creation of font file wqy-microhei.ttc in Alteryx temporary folder
Environment
- Product - Alteryx Designer, Alteryx Server with predictive tools
- 2019.3+
Procedure
Prevent creation of font wqy-microhei.ttcin Alteryx temporary folder
With 2019.3+, one could notice the creation of files Rtmpxxxxxx\wqy-microhei.ttc in the Alteryx temporary folder each time a workflow that contains a predictive tool or R tool runs. Such files are not removed automatically.
Example:
Cause
Alteryx Predictive tools 2019.3, implemented a new way to handle fonts to help with some particular problems encountered with some languages (internal reference: DE18722). Fix is based on the packages sysfonts and showtext, which uses showtextdb. Font file wqy-microhei.ttc is loaded automatically when the package showtextdb is imported and is never released. This leads to the accumulation of unwanted files, which is a defect—TAP-839.
Solution
Note—The workaround discussed below has to be reapplied for each upgrade.
I. For the standard version of the Predictive Tools:
1. Uncompress attached file fixed_package.zip in %TEMP%. %TEMP% is a Windows environment variable that will be replaced by a value specific to your system. %TEMP% should now contain a file named showtextdb_2.0.tar.gz
2. Stop Alteryx Designer or AlteryxService; it has not process should access the library should be accessed between the changes.
3. Open a command prompt
- as Administrator if you have Alteryx Server or an admin version of Alteryx Designer
- standard otherwise
4. Go to R folder in Alteryx distribution (replace %ALTERYXDIR% with relevant value, example cd C:\Program Files\Alteryx\R-3.5.3\bin
cd %ALTERYXDIR%\R-3.5.3\bin
5. Rename library folder
move ..\library\showtextdb showtexdb.old
6. Install patched library. In the following example, replace %ALTERYXDIR% with the Alteryx product installation path. Note that character "/" is used as the delimiter (example: --library="C:/Program Files/Alteryx/R-3.5.3/library")
r CMD INSTALL --library="%ALTERYXDIR%/R-3.5.3/library" %TEMP%\showtextdb_2.0.tar.gz
7. Start Designer or AlteryxService
II. If Microsoft R is used with Alteryx Predictive Tools:
Following assumes that Microsoft R was installed using the default location: C:\Program Files\Microsoft\R Client
1. Uncompress attached file fixed_package.zip in %TEMP%. %TEMP% is a Windows environment variable that will be replaced by a value specific to your system. %TEMP% should now contain a file named showtextdb_2.0.tar.gz
2. Stop Alteryx Designer or Alteryx Server to ensure that no process will access the library during the operation
3. Open a command prompt as Administrator
4. Go to bin folder for Microsoft R
cd "C:\Program Files\Microsoft\R Client\R_SERVER\bin"
5. Rename library folder
move ..\library\showtextdb showtexdb.old
6. Install patched library
r CMD INSTALL --library="C:\Program Files\Microsoft\R Client\R_SERVER\library" %TEMP%\showtextdb_2.0.tar.gz
7. Start Designer/AlteryxService
Attachments