2827889 - sp_showoptstats generates incomplete XML output - SAP ASE

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>

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

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