SOI Upgrade Database Error: The content of elements must consist of well-formed character data or markup

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We are upgrading SOI 4.0 to 4.2, during this process the installer throws the below error:

The content of elements must consist of well-formed character data or markup

Environment

Release : SOI 4.0 to 4.2

Component :

Cause

CA-SOI_InstallDebug.log has below errors...

Loading UC configuration from universal_<hostname>.xml
[Fatal Error] :5:29: The content of elements must consist of well-formed character data or markup.
java.lang.RuntimeException: org.xml.sax.SAXParseException; lineNumber: 5; columnNumber: 29; The content of elements must consist of well-formed character data or markup.
 at com.ca.soi.config.Xml.rootElement(Xml.java:48)
 at com.ca.soi.config.Xml.<init>(Xml.java:80)
 at com.ca.soi.config.Xml.<init>(Xml.java:85)
 at com.ca.soi.config.EEM.getProperties(EEM.java:26)
 at com.ca.soi.config.SoiManager.getProperties(SoiManager.java:469)
 at com.ca.soi.installer.ia.action.ConfigLoad.install(ConfigLoad.java:178)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
 at com.zerog.ia.installer.actions.PlugInAction.installSelf(Unknown Source)
 at com.zerog.ia.installer.util.GenericInstallPanel$2.run(Unknown Source)

Resolution

Per Install log, installer unable to parse \CA\SOI\tomcat\webapps\sam\eem-config.xml

The contents of eem-config.xml should look like

<root>
  <application><hostname></application>
  <server><hostname></server>
  <user>EiamAdmin</user>
  <password plain="false"><![CDATA[######################]]></password>
</root>

But it is observed that highlighted text CDATA[ was missing, after correcting this file, now installer able to parse this file, and upgrade was successful