SAP Knowledge Base Article - Preview

2571477 - Invalid numeric value for parameter/column () source type DECIMAL, target type DECIMAL - SAP Landscape Transformation Replication Server

Symptom

  • Replication doesn't fail but data in some target table columns shifted or truncated.
  • Initial load for a table (i.e  MARA)  fails right at the beginning
  • Errors in Application log:
    • SQL exception occurred in receiver system (rfc dest. NONE)
    • Execution of program /1LT/DK2OLC_100000000062203 failed, return code 3
  • Error 1 in SM21: 
    • SQLCODE : -10802
    • SQLERRTEXT : Invalid numeric value for parameter/column (211) source type DECIMAL, target type DECIMAL
    • sc_p=9b2fbc8,no=209,idc_p=(nil),con=1,act=1,slen=4950,smax=5120,#vars=287,stmt=a599d70,table=/1CADMC/S0001533
    • OR
    • SQLCODE : -10802
    • SQLERRTEXT : Invalid numeric value for parameter/column (211) source type DECIMAL, target type FIXED8
    • sc_p=9b2fbc8,no=209,idc_p=(nil),con=1,act=1,slen=4950,smax=5120,#vars=287,stmt=a599d70,table=/1CADMC/S0001533
  • Error 2 in SM21:
    • invalid sign in BCD number: 0
    • Error converting decimal:  000000000#0.00 HEX: 000000000C0000 input variable
  • Fields XXX in table /ÍCADMC/10000000000XXXX<TABLE> is specified twice

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Landscape Transformation Replication Server

Product

SAP Landscape Transformation replication server 1.0 ; SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0

Keywords

SLT, DECIMAL, FIXED8, -10802, specified, twice , KBA , HAN-DP-LTR , Use CA-LT-SLT instead , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , 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.