ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

On installing a fresh APM database, getting an error about an incompatible encoding with the template database.


Article ID: 3904


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE


 When running a fresh installation of the APM database (Postgres), the following error appears:

Additional Notes: ERROR - createdb: database
creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) 
HINT: Use the same encoding as in the template database, or use template0 as template.
(STDOUT: Creating user admin
Creating database cemdb with the admin user as the owner.


   This error is typically caused by the LANG setting on the server.


All Supported APM Releases


  To change this setting, edit the LANG value in the file /etc/sysconfig/i18n file.

  This is the system file where the Postgres installer gets the locale settings used to create the database.

  An example is the following:




 After setting this value, then uninstall the existing Postgres, and reinstall the database. 


  Usually, this error will go away, if this is not the case, then open a Support case to resolve the issue.