SAP Knowledge Base Article - Preview

2819632 - DIST error 32058: The value given for '...' cannot be translated from datatype 'char' to the required datatype 'char'. Value length is ... - SRS

Symptom

  •  The distributor (DIST) thread goes down with Error 32058:

ERROR #1029 DIST(439 PRIM_DS.prim_db) - ic/trnsl/trnsl_cmn.c(411)
CS-Library error: Error: 33816868, Severity 1 -- 'cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow.'.
ERROR #32058 DIST(439 PRIM_DS.prim_db) - de/generic/nrm/nrm.c(4656)
The value given for 'mytable_repdef.mycol' cannot be translated from datatype 'char' to the required datatype 'char'. Value length is '21'; Maximum target length is '21'; The value is '123456789012345678901'.
DIST for 'PRIM_DS.prim_db' is waiting for SQM(s) to flush to outbound queue(s).
The distributor for 'PRIM_DS.prim_db' is shutting down

  • Restarting the DIST thread or SRS does not resolve the error.
  • Resetting the secondary truncation point in the primary database does not help.
  • The column is defined as VARCHAR(50) in the primary table and as CHAR(20) in the replication definition (repdef) and the replicate table.
    The replicate table definition cannot be changed, and increasing the length of the column to CHAR(35) from CHAR(20) in the replication definition does not resolve the issue.


Read more...

Environment

SAP Replication Server (SRS) all versions

Product

SAP Replication Server all versions

Keywords

Repserver, RS, sysadmin, dump_queue, sqm_zap_command, sqm_zap_tran, BEGIN, TRAN, TRANSACTION, zap, alter, function, string, rs_insert, rs_update , 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 for Me (Login required).

Search for additional results

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