SQL Server experiences performance issues after an upgrade to Endpoint Protection Manager 14.2 MP1

book

Article ID: 184662

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

Following an upgrade from Symantec Endpoint Protection Manager (SEPM) 12.1.7454.7000 (schema version 12.1.6.11) to 14.2.1023.0100 (schema version 14.2.0.2), you see excessive CPU utilization on the SQL Server.

Error in AgentSecurityLogCollector-0.log

 

2019-03-08 08:14:04.513 THREAD 135 WARNING: SQLException:  BCP data error:

Starting copy...

SQLState = 22001, NativeError = 0

Error = [Microsoft][SQL Server Native Client 11.0]String data, right truncation

SQLState = 22001, NativeError = 0

Error = [Microsoft][SQL Server Native Client 11.0]String data, right truncation

 

0 rows copied.

Environment

Environment using SEPM 14.2 MP1 with SQL database and application learning enabled.

Resolution

This issue is fixed in version 14.2 RU1 MP1 by adding type conversion to the SQL statement to prevent this performance issue.

For information on how to obtain the latest build of Symantec Endpoint Protection, read
TECH103088: Download the latest version of Symantec Endpoint Protection