Symptom
-
Load/replication a table has a CHAR field longer than 1333 characters ends with error: Batch job for access plan calculation in sender system ended with errors.
- Data type mapping failed; conversion not possible: <datatype> <length>
- Cannot replicate data from field [fieldname] (table [table name]); see long text
- Long Text: “Field [field name] exceeds 1333 characters. If the length of a field exceeds 1333 characters, SAP LT Replication Server will change the type of the field to STRING. SAP LT Replication Server uses Open SQL to calculate the access plan, but Open SQL does not support the type STRING. This means that SAP LT Replication Server cannot replicate data from this field (as the access plan cannot be calculated).”
Read more...
Environment
SAP Landscape Transformation Replication Server
Keywords
long, varchar, STRG, SLT, CHAR, HANA, Oracle, LFIELD , 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.