NetWorker: Sybase backups fail "Locale name "en_US.utf8" doesn't exist in your locales.dat file"
Summary: Sybase backups fail with the following error "Locale name "en_US.utf8" doesn't exist in your /sybase/GWP/locales/locales.dat file.
Symptoms
Add the localization information for the specific platform to resolve the issue. Below is an example of localization information for Linux architecture:
[linux] locale = FRENCH, french, iso_1 locale = fr, french, iso_1 locale = fr_BE, french, iso_1 locale = fr_BE.437, french, cp437 locale = en_US.UTF-8, us_english, utf8
Adding the locale for Linux platform fixed the issue for Sybase backup that required en_US.UTF-8.
Sybase backups fail with the below error:
"Locale name "en_US.utf8" doesn't exist in your $SYBASE/locales/locales.dat file"
Cause
The locales file called locales.dat provides platform-specific locale information in a Sybase proprietary format. This file associates locale names with languages, character sets, and collating sequences.
The reason is that the localization file is not updated with parameter "en_US.utf8" for specific platform. The file $SYBASE/locales/locales.dat should contain the below parameter for the platform on which the Sybase Database is deployed. There are multiple platforms like Posix, HP, Linux, macosx, and others, for which the localization information should be updated for the specific platform.
Resolution
Ensure that the locale for the specific platform is updated.
[linux]
locale = en_US.437, us_english, cp437
locale = en_US.850, us_english, cp850
locale = us_english.utf8, us_english, utf8
locale = en_US.UTF-8, us_english, utf8
locale = en_US.ISO8859-1, us_english, iso_1
locale = en_US.ISO8859-15, us_english, iso15
locale = us_EN, us_english, iso_1
locale = C, us_english, iso_1
locale = default, us_english, iso_1Additional Information
The locales file called locales.dat provides platform-specific locale information in a Sybase proprietary format. This file associates locale names with languages, character sets, and collating sequences.
How it is used.
Open Client applications use locales.dat to determine what localization information to load. The locales.dat file directs Open Client applications to localization information, but it does not contain localized messages or character set information.