Application and Device Control reports and logs show garbled text

book

Article ID: 156124

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

Filenames and paths with double-byte character set (DBCS) characters display as garbled text in the Symantec Endpoint Protection Manager (SEPM).

 

Cause

This behavior occurs when the SEPM utilizes a Microsoft SQL 2008 or later database server. The Bulk Copy Protocol (BCP) utility included with this version of Microsoft SQL does not allow data to be transferred as UTF-8 formatted text. The SEPM uses UTF-8 formatted text in order to be able to transfer DBCS text to and from the SEPM database. When the SEPM uploads data to the database, DBCS characters (such as Japanese, Korean, Chinese or Devanagari characters) are not properly inserted into the SEPM's database.

DBCS data will display normally on a SEPM site utilizing SQL 2005 or earlier, or the embedded (SQLAnywhere) database. If a SQL 2005 or earlier, or embedded (SQLAnywhere) site Replicates with a SQL 2008 or later site, DBCS data will show incorrectly on the SQL 2008 or higher Replication partner.

 

Resolution

To work around this issue, configure the affected SEPM to use Batch Mode processing instead of BCP.

Note: Batch Mode processing is significantly less efficient at transferring large data sets that BCP. Making this change will lower the SEPM's ability to process client log data and may cause slow SEPM response time to client requests.

 

  1. Open the conf.properties file in a text editor
    • The file can be found in the \Symantec Endpoint Protection Manager\tomcat\etc folder
  2. Add the following line to the end of the file:
    • scm.log.batchmode=1
  3. Save the changes to conf.properties
  4. Restart the Symantec Endpoint Protection Manager service.


Applies To

This issue requires one or more SEPM Sites using Microsoft SQL server 2008 or later.