Cannot generate SFG report in Chinese characters in Sterling File Gateway

Technote (troubleshooting)


Problem(Abstract)

Reports generated in Chinese from the filegateway dashboard, do not display any of the Chinese characters. All of them are displayed as "??"

Symptom

The problem can be simulated using following steps:
1) Set your Internet Explorer browser language preference to Chinese and access the /filegateway URL.
2) If the page is not displayed in Chinese, then login to Sterling Integrator dashboard and change the Language to Traditional Chinese under Accounts > My Account. Repeat Step 1.
3) Login to the /filegateway URL as fg_sysadmin.
4) Navigate to Tools > Reports and click on Generate Report on the resulting page.
5) A report will be generated
6) All the Chinese chars are displayed as "??"


Environment

Sterling Integrator 5020300
Sterling File Gateway 2.2.3

Resolving the problem

Follow the instructions in the 5.2.3 documentation here and use install3rdParty.sh to install the two jars mentioned. To quote from the documentation:

<install_dir>/bin/install3rdParty.sh jasperreports 1_2_0 -j <download_dir_path>/iTextAsian.jar
<install_dir>/bin/install3rdParty.sh jasperreports 1_2_0 -j <download_dir_path>/iTextAsianCmaps.jar

It is also necessary to fix one of the Chinese language property files. This file is: <install_dir>/properties/lang/zh/filegateway_report.properties

If you go to the end of the file you will see something like:
#START NON-TRANSLATABLE
#For each language file these values need to be modified per pdf (Adobe) and jasper report documentations
filegateway.reports.locale=en
filegateway.reports.font=SansSerif
filegateway.reports.pdfFont=Helvetica
filegateway.reports.pdfEncoding=CP1252
#END NON-TRANSLATABLE

These entries are incorrect. They should read:
#START NON-TRANSLATABLE
#For each language file these values need to be modified per pdf (Adobe) and jasper report documentations
filegateway.reports.locale=zh
filegateway.reports.font=MSGothic
filegateway.reports.pdfFont=STSong-Light
filegateway.reports.pdfEncoding=UniGB-UCS2-H
#END NON-TRANSLATABLE

After these steps, Chinese characters in the report will be visible.

Rate this page:

(0 users)Average rating

Document information


More support for:

Sterling File Gateway

Software version:

2.2

Operating system(s):

Windows

Reference #:

1626857

Modified date:

2013-03-26

Translate my page

Machine Translation

Content navigation