IBM Support

PI93947: QUERY SERVICE INTERNAL ERROR - WHEN ADDING TWO MEASURES WHEN THERE IS NO COMMON DIMENSIONAL VALUES WHEN IN SCOPE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When attempting to add two measures to a dashboard visualisation
    when there is no common dimensional values when in scope the
    visualisation will error out saying Query Service Internal
    Error.
    
    The XQE logs says:
    Caught error in the Query Service: java.lang.ClassCastException:
    com.cognos.xqe.resultsets.ContextMember incompatible with
    com.cognos.xqe.resultsets.ContextValue
    
    Example condition:
    Source 1 fields: Reporting month, Measure 1
    Source 2 fields: Reporting Month, Measure 3
    
    Issue: If we are using 'Reporting month', Measure 1 and Measure
    3 in a Dashboard chart or table, it works fine if both Source 1
    'Reporting Month' and Source 2 'Reporting month' has same
    data(at least one value matching).
    
    If there are no common values in Source 1 ' Reporting Month' and
    Source 2 'Reporting Month' then the chart throw an error. It's
    same for all the dimensions in the cube.
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI93947

  • Reported component name

    COG DASHBOARDS

  • Reported component ID

    5724W12DB

  • Reported release

    B09

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-19

  • Closed date

    2018-06-29

  • Last modified date

    2018-06-29

  • 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

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

Document Information

Modified date:
11 November 2022