Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Multi-byte characters are saved incorrectly in DPA

Multi-byte characters are saved incorrectly in DPA

Overview

You entered and saved multi-byte characters, but the characters display incorrectly when you re-access DPA.

Environment

  • All versions of DPA

Cause

By default, DPA does not support special characters using a specific character set such as multi-byte, double-byte, and so on. Generally this happens when the DPA repository is set to a single-byte character set, but the monitored instance is set to a multi-byte character set. Java can handle this correctly, but when trying to insert the multi-byte character set into the repository, it will usually fail.

In order to support a multi-byte language, the DPA server, repository, and monitored instances must be configured with the same character set.

Use the following steps to change that default behavior to support single-, double-, or triple-byte. DPA does not support four-byte character sets.

Resolution

These steps include recreating the repository database. You will lose your historical data.

  1. In the operating system settings on the DPA server, change the Language and Region settings to the language with the same character set.
  2. Make sure that your system supports the appropriate fonts.
  3. In your DPA database repository, change the default language to match the operating system language.
  4. Stop the DPA service.
    • Windows: Stop the Ignite PI Server service.
    • UNIX or Linux: Run installDir\shutdown.sh.
  5. Go to the following directory on the DPA server:

    installDir\iwc\tomcat\ignite_config\idc

  6. Open the system.properties file, and edit the following property by deleting the number sign (#) and setting to true:

    com.confio.doublebyte=true

  7. Open the repo.properties file, and edit the following property by setting to no:

    repo.created=no

  8. Save and close both files.
  9. Start the DPA service.
    • Windows: Start the Ignite PI Server service.
    • UNIX or Linux: Run installDir\startup.sh.
  10. Access DPA in a browser, and create the database repository again.

 

 

Last modified

Tags

Classifications

Public