We need to set up DB-Connect between 2 servers:
1) BW server on DBMS Informix (DBMS Informix and BW are installed on the same host)
2) Transactional data server on DBMS Informix
Databases were created with different locales:
dbs_collate (from table sysdbslocale) is en_US.819 for Informix on BW and ru_RU.915 for transactional data server.
After DB-Connect creation we get an error Source system <NAME> cannot be accessed.. In system log we see:
Time Ty. Nr Cl. User Tcod MNo Text
12:14:41 DIA 0 100 DSTESEV RSA1 BY2 Database error -23101 at CON
12:14:41 DIA 0 100 DSTESEV RSA1 BY0 > INF-23101: Unable to load locale categories.
This error doesnt depend on values of environment variables CLIENT_LOCALE, DB_LOCALE, DBNLS, LC_CTYPE, LANG, LC_COLLATE for user <SID>adm. We restart appl. server after changing variables (stopsap r3; startsap r3).
Does anybody meet such problem? How to solve it?