JR41659: IA REPORT FAILS WITH SCHEMA NAME HAVING "@" IN IT

APAR status

• Closed as program error.

Error description

• We are trying to analyize DB2 Tables where the objects are owned
  by OFM@LD1. We are able to import meta data, perform column
  analysis, however when we try to product the column analysis
  report it does not display the schema name as OFM@LD1 and shows
  LD1 only. In addition it shows metadata that does not belong to
  the project and does not generate the reports. We have tried
  both the client and web and face similar issue.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of Information Analyzer 8.5 and higher generating Reports
  with a schema/table name containing the @ character
  ****************************************************************
  PROBLEM DESCRIPTION:
  IA Report creation fails if the schema name contains an @
  character. For example a schema named 'ABC@DEF' is shown as
  'DEF' in report generation.
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.5 Rollup Patch 7.
  ****************************************************************
  

Problem conclusion

• The reason for failure is in Reports, we used '@@' as the
  delimiter to prepare datacollection list. So, whenever there is
  an @ in the schema name or table name, it fails to  prepare a
  valid datacollection and hence the report output is not good. As
  a fix, we have handled the @ character in hostname, schemename
  and table name.
  

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 INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP