XML Load error: An invalid character was found in text content
Hi Team,
I am using the smart view and for the members which are having children more than 5000, I am getting the below error when I am drilling it down in zoom-in or in member selection.
Error:
XML Load error: An invalid character was found in text content
In one of the blog I found the below solution.
This type of Issue does not happen using Excel Add-in but Smart View. We encountered it as well. I have a feeling the root cause is the ESSLANG which used to be selected during installation. If the Essbase has for instance "English Latin1" or "English US Ascii Binary" and the client does not have it, then this would occur. We had old SR on it because we were testin the APS 7.1.6. SR 2-603906: Excel Essbase Add-in splitting special characters such as the " ü " in. Whe we reinstalled and selected same ESSLANG as Essbase server the isue stopped.