PH31249: DATA MODULES LINKED VIEWS BROKEN WHEN UNDERLYING TABLES NOT INCLUDED - ERROR XQE-MSR-0008

APAR status

• Closed as fixed if next.

Error description

• When defining a view in a data module based on two joined tables
  and creating another data module linked in the view defined in
  the first data module, the view no longer works after removing
  the underlying tables used to create the view. .
  The error is: XQE-MSR-0008 In module "View Defined In Here", the
  following query subjects are not joined: "Sls Product Dim", "Sls
  Product Type Lookup".
  
  If the view works in the first data module, it should work in
  the second - without including the underlying tables.
  

Local fix

• Workaround is to also include the underlying tables used in the
  view.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.4                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels