SAP Knowledge Base Article - Preview

2432212 - Problem with xml format data stored as SAP HANA CLOB data type

Symptom

When storing xml formated data as CLOB datatype into a database table, some xml tags are stored incorrect. In the below example one can see that the last closing tag </position> gets saved as </positition>

For instance

<mechanicalKey sfc="93140164_17">
<header>

<material description="Schlüssel rund SR100" number="000000001220017912" oldMaterialNumber="SR100"/>

</header>
[…]
<labelling layoutFilename="???" layoutPath="\\TEST\TODO">
<positions>
<position layoutVarName="CUSTOMERLOGO" type="customerLogo"/>
<position layoutVarName="CUSTOMER" type="standard"/>
<position layoutVarName="PLANNR" type="standard">TF458</position>
<position layoutVarName="TRE" type="standard">1</position>
<position layoutVarName="SORTNU" type="standard">21</positition>
[…]
</mechanicalKey>


Read more...

Environment

SAP HANA SPS 12

Product

SAP HANA 1.0, platform edition

Keywords

clob, nclob, xml, data, type, error, mal, formatted, broke, tag, tags, incorrect, java, c#, odata, hana, studio, sql , KBA , HAN-DB , SAP HANA Database , 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.