Updated on 2022-09-21 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.