JR60567: CDIMR0070E ERROR WHEN IMPORTING HIVE METADATA IF A DESCRIPTION CONTAINS SPECIAL CHARACTERS LIKE "&"

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux
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

• ****************************************************************
  USERS AFFECTED:
  Users trying to use HiveConnector with IMAM
  ****************************************************************
  PROBLEM 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.
  ****************************************************************
  RECOMMENDATION:
  Apply fix for JR60567
  ****************************************************************
  

Problem conclusion

• XML Special  characters were replaced with XML entities
  

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

• RB70 PSY

     UP

• RB71 PSY

     UP