Sunday, June 7, 2009

Informatica : Setting codepage

Informatica integration service sometimes fails with the following error when trying to startup:
LM_36011
Code page mismatch. Service process is running in code page [ISO 8859-1 Western European] whereas the service is configured in the Admin Console to run in code page [UTF-8 encoding of Unicode]

Set the following environment variables on the Linux based server hosting Informatica nodes:
setenv LANG en_US.utf8
setenv LC_ALL en_US.utf8
setenv INFA_CODEPAGENAME UTF-8

For windows, set environment variables LC_ALL and LANG to us_UTF8

Re-start the node service.

Now, integration service can be started with codepage set to UTF-8.