Replication starts to fail after upgrading Endpoint Protection Manger to 14.2

Products

• Endpoint Protection

Issue/Introduction

After upgrading your Symantec Endpoint Protection Manager (SEPM) to 14.2 you notice replication never completes.

Starting copy...

SQLState = 23000, NativeError = 515

Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert
the
value NULL into column 'IP_ADDR', table
'sem5.dbo.TMP_BE3C4ACBA999152975B84C2D92604B55' column does not allow nulls.
INSERT fails.

SQLState = 01000, NativeError = 3621

Warning = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The
statement
has been terminated.

BCP copy in failed

Resolution

This issue is fixed in Symantec Endpoint Protection 14.2 MP1. For information on how to obtain the latest build of Symantec Endpoint Protection, see Download the latest version of Symantec Endpoint Protection.

To workaround the issue:

    1. Run the following query on both SEPM sites.

select count(*) from SEM_COMPUTER_NIC
where DATALENGTH(IP_ADDR)=0;

    2. If records are found, run the following query on both sites to clean-up the table.

delete from SEM_COMPUTER_NIC
where DATALENGTH(IP_ADDR)=0;

    3. Run the replication manually to test if successful.