Replication fails at partner site with exception 'java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Right truncation of string data
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
FORMAT 'TEXT' DEFAULTS ON QUOTES ON ORDER OFF ESCAPES OFF CHECK
CONSTRAINTS OFF COMPUTES OFF STRIP OFF
DELIMITED BY ','
SEP version: 14.3 MP1 and below
SQL database restored in the Embedded database.
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.
1. Change the site's database to SQL Server
2. Upgrade to 14.3 RU1 or higher to make use of the SQL Express.
ESCRT-7189 where loading a backup file created with the embedded database fails in SQL Server