IBM Support

PH04679: XQE-PLN-0020 FOR SPECIFIC COUNT DISTINCT SCENARIO

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A report that uses the same data item with count distinct
    aggregation in columns and rows, as well as 3 other data items
    in a crosstab is failing with: XQE-PLN-0020 The V5 Query could
    not be planned by the Query Service. The 'V5Edge' node is
    invalid for the OLAP Transformation Library and the Query
    Service Planner is currently not able to resolve it.
    The same report can be executed successfully if one of the data
    items is removed, or when the report is executed in Compatible
    Query Mode.
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH04679

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-30

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

  • 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



Document information

More support for: Cognos Analytics
Report Authoring v11x

Software version: B0A

Reference #: PH04679

Modified date: 05 June 2019