JR61574: DUPLICATE ASSETS ARE CREATED WHEN IMPORTING CHAINED ALIASES FROM ORACLE CONNECTOR

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

APAR status

• Closed as program error.

Error description

• In case of chained aliases (duplicate aliases), as per the
  design, the expectation here is to describe/import the first
  alias (that has a direct reference to a table) and referenced
  table only.
  
  For example:
  Assume that we have chained aliases
  for a table test_sp exist like below :
  alias n -> ?>alias 3 ->
  alias 2 -> alias 1 -> test_sp
  With the fix in place (after
  removing duplicates), "alias 1" and the corresponding table
  (test_sp) will get described/imported.
  

Local fix

Problem summary

• Duplicate assets are created when importing chained aliases from
   Oracle connector
  

Problem conclusion

• In case of chained aliases (duplicate aliases), as per the
  design, the expectation here is to
  describe/import the first alias (that has a direct reference to
  a table) and referenced table only.
  
  For example:
  Assume that we have chained aliases for a table test_sp exist
  like below :
  alias n -> ?>alias 3 -> alias 2 -> alias 1 -> test_sp
  
  With the fix in place (after removing duplicates), alias 1 and
  the corresponding table (test_sp) will get described/imported.
  

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

• RB71 PSY

     UP