Export error: value of length column (38) greater than VARDATA column (36)

[Former Member]

Hello @,

I am performing an export on HP-UX/Oracle of a R/3 Enterprise 1.10 system.

I already use got the latest R3load binary. For pool table KAPOL I get

this strange error and I couldn't find any further information about it:

cat SAPPOOL.log
[...]
(EXP) TABLE: "DEBI"
(EXP) TABLE: "DVPOOL"
(EXP) TABLE: "DVPOOLTEXT"
(EXP) TABLE: "FINPL"
(EXP) TABLE: "GLTP"
(EXP) TABLE: "KALK"
value of length column (38) greater than VARDATA column (36)
(CNVPOOL) conversion failed for row 356 of table A004       VARKEY = 001V ZSP0003010TI060067A.01      00000000  
(CNV) ERROR: data conversion failed.  rc = 2
(DB) INFO: disconnected from DB

/usr/sap/AVT/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/AVT/SYS/exe/run/R3load: END OF LOG: 20110117114148

SQL> desc kapol
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABNAME                                   NOT NULL VARCHAR2(30)
 VARKEY                                    NOT NULL VARCHAR2(195)
 DATALN                                    NOT NULL NUMBER(5)
 VARDATA                                            RAW(36)

SQL> select length(vardata),count(*) from kapol group by length(vardata);

LENGTH(VARDATA)   COUNT(*)
--------------- ----------
             72     183681

select dataln,count(*) from kapol  group by dataln;

    DATALN   COUNT(*)
---------- ----------
    -32730          2
        36     183679

Does this mean that one row in KAPOL has to be changed from within SAP?

Or could it be an error/bug within R3load?

Regards,

Mark

Edited by: Mark Foerster on Jan 17, 2011 12:46 PM

[Former Member]

Maybe this information is of any help:

I opened a support call and was told by SAP support to change the

two entries from -32730 to -32732. Don't ask me why...

[Former Member]

Hi Mark,

Maybe notes 686357 and 1169995 could be of help.

Regards,

Srikishan