2360229 - Trailing multibyte space characters may be truncated when replicating a string - SAP Replication Server

• A database connection parameter "dsi_bulk_copy" is on, and the number of insert commands reaches the value of a database connection parameter "dsi_bulk_threshold".
• Insert commands try to insert a string with trailing multibyte blanks into a column which is a variable-length charactera data type, such as CHAR NULL and VARCHAR.
• The string is replicated to the replicate database without multibyte trailing blanks. Please see an example below. 0xa1a1 is a multibyte space in eucjis.

-- On the primary database
1> select col1, convert(varbinary, col2), convert(varbinary, col3), convert(varbinary, col4) from tab1
2> go
 col1

 ----------- --------------------------------------------------------------
         --------------------------------------------------------------
         --------------------------------------------------------------
           1 0x74657374a1a1a1a120202020202020202020202020202020202020202020
         0x74657374a1a1a1a1
         0x74657374a1a1a1a1

(1 row affected)
1>

-- On the replicate database
1> select col1, convert(varbinary, col2), convert(varbinary, col3), convert(varbinary, col4) from tab1
2> go
 col1

 ----------- --------------------------------------------------------------
         --------------------------------------------------------------
         --------------------------------------------------------------
           1 0x74657374a1a1a1a120202020202020202020202020202020202020202020
         0x74657374
         0x74657374

(1 row affected)
1> 

• If the column is one of key columns, a 5185 error occurs due to row count mismatch when deleting the above row on the primary database. The DSI thread is suspended.

 W. yyyy/mm/dd hh:mm:ss. WARNING #5185 DSI EXEC(103(1) ASE157.RDB) - eneric/dsi/dsiexec.c(20669)
Row count mismatch for the command executed on 'ASE157.RDB'. The command impacted 0 rows but it should impact 1 rows.

• SAP Replication Server 15.7

multibyte space, multibyte blank, dsi_bulk_copy, dsi_bulk_threshold, 5185 error, row count mismatch, multi-byte space, multi-byte blank , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem