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

book

Article ID: 3904

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER 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.
)

Cause

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

Environment

All Supported APM Releases

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.