JR60568: Error when importing hive metadata if the description contains special characters like "&"

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• When importing Hive metadata if a description contains special
  characters like "&" they get the following error:
  com.ibm.mif.ChannelException: [CDIMR0070E] There was an error
  querying all tables in the z0_tech_metadata schema.
  Caused by:
  com.ibm.iis.cas.shared.ConnectorServiceException: An exception
  [org.xml.sax.SAXParseException: The entity name must
  immediately follow the '&' in the entity reference.] occurred
  when parsing the following XML:
  "<DataCollections>.....
  <Value schema="myschema" nameQualifier="myschema"
  subType="TABLE" isView="false" isSystem="false"
  description="This description contains & and other special
  characters !@#*^%" ><![CDATA[mytable]]></Value>
  ....</DataCollections>"
  

Local fix

Problem summary

• Error when importing hive metadata if the description contains
  special characters like "&"
  

Problem conclusion

• Issue is fixed
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB50 PSY

     UP