SAP Knowledge Base Article - Preview

2827889 - sp_showoptstats generates incomplete XML output - SAP ASE

Symptom

On SAP ASE systems using utf8 character set, sp_showoptstats may generate incomplete and corrupt XML output.

On systems running SAP applications, t-code DBACockpit -> Space -> Single-Table Analysis fails with the error: errors occurred when parsing the statistics XML

For histogram steps referencing multibyte character values, the closing STEP tags are missing between certain steps.

<step>140</step>
<weight>0.00000000</weight>
<equation><</equation>
<value>"cadg"</value>
</steps>
<steps>
<step>141</step>
<weight>0.00214938</weight>
<equation>=</equation>
<value>"cadg"</value>

-- <missing steps tags here> --

<step>142</step>
<weight>0.00064685</weight>
<equation><</equation>
<value>"ertf"</value>
</steps>
<steps>


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP ERP 6.0

Keywords

sp_showoptstats, utf8, xml, parsing, statistics, "errors occurred when parsing the statistics XML", CR#819875, CR819875, 819875 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.