Replication fails at partner site

Products

• Endpoint Protection

Issue/Introduction

Replication fails at partner site with exception 'java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Right truncation of string data

Replication logs:

 Replication failed while loading table SEM_COMPUTER:

2021-11-24 11:10:13.661 THREAD 383508 WARNING: TableMerger>> Table name: SEM_COMPUTER

The step that loads the csv file to the temp table in the embedded database is not logged, but that's where the error occurred:

LOAD TABLE DBA.SEM_COMPUTER
(header line...)
 FROM (filePath...)
 FORMAT 'TEXT' DEFAULTS ON QUOTES ON ORDER OFF ESCAPES OFF CHECK 
 CONSTRAINTS OFF COMPUTES OFF STRIP OFF 
 SKIP 1
 DELIMITED BY ','

Environment

SEP version: 14.3 MP1 and below

SQL database restored in the Embedded database.

Cause

If the database were SQL server, the data is loaded using a different method, where a SQL Server format file is used. Ideally, data can be replicated between the embedded database and SQL server, however, there are subtle differences in the schemas and may result in errors. 

Resolution

1. Change the site's database to SQL Server
2. Upgrade to 14.3 RU1 or higher to make use of the SQL Express.

Additional Information

ESCRT-7189 where loading a backup file created with the embedded database fails in SQL Server