After upgrading your Symantec Endpoint Protection Manager (SEPM) to 14.2 you notice replication never completes.
SQLState = 23000, NativeError = 515
Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert
value NULL into column 'IP_ADDR', table
'sem5.dbo.TMP_BE3C4ACBA999152975B84C2D92604B55' column does not allow nulls.
SQLState = 01000, NativeError = 3621
Warning = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The
has been terminated.
BCP copy in failed
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.