IBM Support

PM85480: Materialized view returns an error when renamed

Subscribe

You can track all active APARs for this component.

 

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 number

    PM85480

  • Reported component name

    COG FRAMEWRK MG

  • Reported component ID

    5724W12FM

  • Reported release

    A20

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-25

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A20"}]

Document Information

Modified date:
14 December 2020