2571477 - Invalid numeric value for parameter/column () source type DECIMAL, target type DECIMAL - SAP Landscape Transformation replication server 2.0 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2571477 - Invalid numeric value for parameter/column () source type DECIMAL, target type DECIMAL - SAP Landscape Transformation replication server 2.0

Symptom

  • Initial load for table CRMD_CUSTOMER_H  fails with "SQL exception occurred in receiver system (rfc dest. NONE)"
  • Execution of program /1LT/RK1OLC_100000000010559 failed, return code 3
  • System log (/SM21):

Invalid numeric value for parameter/column (9) source type ##
> DECIMAL, target type DECIMAL

Trace:
C *** ERROR => EXECUTE C_0019 on connection 1, rc=-10802
[dbslsdb.cpp 9784]
C SQLCODE : -10802
C SQLERRTEXT : Invalid numeric value for parameter/column (9) source type DECIMAL, target type DECIMAL
C sc_p=88fff38,no=19,idc_p=(nil),con=1,act=1,slen=1054,smax=1280,#vars=49,stmt=8be3430,table=/1LT/00000009147
C INSERT INTO "/1LT/00000009147" ( "CLIENT" , "GUID" , "CUSTOMER_INT" , "CUSTOMER_EXT" , "CUSTOMER_H_D\
C UMMY" , "ZZAFLD000000" , "ZZAFLD000001" , "ZZAFLD000002" , "ZZAFLD000003" , "ZZAFLD000004" , "ZZAFLD\
C 000005" , "ZZAFLD000006" , "ZZAFLD000007" , "ZZAFLD000008" , "ZZAFLD000009" , "ZZAFLD00000A" , "ZZAF\
C LD00000B" , "ZZAFLD00000C" , "ZZAFLD00000D" , "ZZAFLD00000F" , "ZZAFLD00000L" , "ZZAFLD00000M" , "ZZ\
C AFLD000014" , "ZZAFLD000016" , "ZZAFLD000018" , "ZZAFLD00001A" , "ZZAFLD00001C" , "ZZAFLD00001D" , "\
C ZZAFLD00001E" , "ZZAFLD00001F" , "ZZAFLD00001G" , "ZZAFLD00001H" , "ZZAFLD00001I" , "ZZAFLD00001J" ,\
C "ZZAFLD00001L" , "ZZAFLD00001M" , "ZZAFLD00001O" , "ZZAFLD00001P" , "ZZAFLD00001Q" , "ZZAFLD00002E"\
C , "ZZTRAFFIC" , "ZZSOC" , "ZZPOT_TOTSALVOLM" , "ZZAFLD00003T" , "ZZAFLD00003V" , "ZZAFLD00004G" , "\
C ZZAFLD00004H" , "ZZAFLD00004N" , "ZZAFLD00004O" ) VALUES( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? \
C , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? \
C , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ;
B ***LOG BY4=> sql error -10802 performing INS on table /1LT/00000009147 [dbdbslst 3697]
B ***LOG BY0=> Invalid numeric value for parameter/column (9) source type DECIMAL, target type DECIMAL [dbdbslst 3697]


Read more...

Environment

  • SAP Landscape Transformation replication server 2.0
  • DMIS 2011_1_731 SP11

Product

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

Keywords

KBA , HAN-DP-LTR , SAP Landscape Transformation Replication Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

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