Qlik Talend Data Integration: Issue with tAddCRCRow component for Chinese language in Unix JobServer

[uma_rani]

The tAddCRCRow component computes the correct value for Chinese characters in the local Studio (Windows).

However, when the same Job is set to be executed in the remote JobServer (Unix), the component is showing same calculated values for different input values.

The sample output from the Unix JobServer execution log is shown below:

The first column is part of the CRC and the last column is calculated CRC.

Input value	Calculated CRC value
吊环轴承座	916913630
耳轴轴承块	916913630
铰接吊环头	916913630

Resolution

For the string containing Chinese characters, the CRC calculation did not function correctly when the target was a JobServer in Unix.

Adding the below properties in the Studio -> Run Tab -> Advanced settings -> Use specific JVM Arguments resolves the issue.

-Duser.country=CN
-Duser.language=zh
-Dfile.encoding=UTF-8

The correct output is now displayed.

Environment

• Talend Data Integration 7.3.1, 8.0.1