SAP Knowledge Base Article - Preview

2185240 - After ERROR #32061, unable to RESUME the distributor - SRS


  • When a 'decimal' column is incorrectly defined as 'smallint' in the table replication definition(rep def),  the DIST (Distributor) thread fails with the following error :

ERROR #32061 DIST(107 ASE1571.pdb) - de\generic\nrm\nrm.c(12578)
Literal 'x' cannot be converted to native datatype 'smallint' (val_name 'xxx')
DIST for 'ASE1571.pdb' is waiting for SQM(s) to flush to outbound queue(s).

  • Can't dump queue:

    > sysadmin dump_queue, 107,1,-1,-2,-2
    > go

          Msg 32061, Level 12, State 0
          Server 'REP_RS': Literal 'x' cannot be converted to native datatype 'xxx' (val_name 'xxx')
  • There is no way to skip the offending transaction aside from purging the queue.
  • Same error can happen on different data types.




SAP Replication Server (SRS) 15.7.1 SP206 and up


SAP Replication Server 15.7


mismatch, data type, datatypes,  CR786113,CR 822291, 32061, #32061, distributor, resume, skip , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

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.