PM85480: Materialized view returns an error when renamed

APAR status

• Closed as fixed if next.

Error description

• Materialized view returns an error when renamed on the import
  layer in Framework Manager.??Testing the object then in Dynamic
  Query Mode (DQM) either in Framework Manager or in studios
  returns the errors below.??There are no errors when using
  compatible query  mode.??Depending on release the error might
  vary. The following error is returned in 10.2 with applied
  component updater:??XQE-PLN-0011 The relation 'xxx' could not be
  found in the model. MFW-UT-1002 An internal problem has occured.
  Please contact your system administrator. MFW-UT-1003 Details:
  "Unexpected duplicate ID for a physical node:
  [:physicalSources].[<data source name in FM>].[<user/
  schema>].[<MQT name>].[<MQT item>]"
  

Local fix

• Workaround:
  (a) Do not rename the object.
  (b) Create a model query subject to rename.
  (c) Use compatible mode for packages including MQTs
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

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

• RA21 PSN

     UP