IBM Support

PH16537: TI-PROCESS WITH VALID BUT EMPTY MDX VIEW AS DATA SOURCE THROWS MAJOR ERROR AND ABORTS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When a TI process has as DatasourceType='VIEW' and the view is a
    MDX view where the view syntax is correct but the view happens
    to return empty due to column and/or row SELECT NON EMPTY
    suppression then the process will throw a major error and abort
    rather than skipping the metadata and data tabs and proceeding
    directly to the epilog.
    Error: Prolog procedure line (0): Unable to open data source
    "cubename"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Planning Analytics 2.0.9.4 or later release       *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH16537

  • Reported component name

    PA TM1 TURBO IN

  • Reported component ID

    5737B03TI

  • Reported release

    204

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-06

  • Closed date

    2020-12-04

  • Last modified date

    2020-12-04

  • 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

    PA TM1 TURBO IN

  • Fixed component ID

    5737B03TI

Applicable component levels

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

Document Information

Modified date:
05 December 2020