Updated on 2023-01-17 GMT+08:00

Full Synchronization Error: invalid locale name

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: target engine postgresql client initialize failed, detail: Unable to connect to DBMS: url= %s/position3.0?client_encoding=UTF-8&autosave=always&stringtype=unspecified&ssl=false&sslmode=prefer user= %s, Caused by: ERROR: invalid locale name:'Chinese (Simplified)_China.936'.

Possible Causes

The source database region type is not supported by the destination database.

Solution

Contact the customer to check whether the region type can be changed to another one (UTF-8 by default). The region type may affect the sorting rules of different languages. If the encoding format can be changed to UTF-8, contact Huawei technical support.