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

Products

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

Issue/Introduction

 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
CREATE ROLE
Creating database cemdb with the admin user as the owner.
)

Environment

All Supported APM Releases

Cause

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

Resolution

  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:

 

 	LANG="en_US.UTF-8" 

 

 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.