TEC618785: APM database installation error: creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

Document created by FrancisLee Employee on May 27, 2016Last modified by J.J. Lovett on May 27, 2016
Version 2Show Document
  • View in full screen mode

Document ID:  TEC618785

Last Modified Date:  10/9/2014
Authored By: FrancisLee

  • Products
    • CA Application Performance Management
  • Components
    • CUSTOMER EXPERIENCE MANAGER

 

Description:

When running a fresh installation of 9.6 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.
)

Solution:

This error is most likely caused by the LANG setting on the server.

To change this setting, edit the LANG setting 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.

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes