Symptom
When using flowgraph to replicate data from MSSQL view to HANA, observed the following errors.
- Data with 'YYYYMM' format is wrongly replicated. E.g. 201204 -> 2012Ap, 201205 -> 2012Ma
- Data with 'YYYY' format is cut off. E.g. 2012 -> 201, 2013 -> 201
- Data with 'MM' format is wrongly replicated. E.g. 04 -> Ap, 05 -> Ma
- Some data are replicated into question mark
- Some other wrongly replicated data. E.g. 2012年04月 > 201年Ap月
Read more...
Environment
HANA Server: 1.00.122.09
DP Agent: 1.3.8.1
MSSQL Server2014 with Collation set to Japanese_CI_AS
Product
SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0
Keywords
garbled, Chinese, JP, CN, double, multi, multiple, byte , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.