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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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.

 


Read more...

Environment

  • SAP Replication Server 15.7

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.