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
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.