SAP Knowledge Base Article - Preview

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

Symptom

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

 


Read more...

Environment

SAP Replication Server (SRS) 15.7.1 SP206 and up

Product

SAP Replication Server 15.7

Keywords

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.