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.