IBM Support

PH20488: ERROR "QUERY SERVICES INTERNAL ERROR HAS OCCURRED PLEASE SEE THELOGS FOR DETAILS" USING MSSAS RELATIVE TIME SET IN DASHBOARD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error description

  • Designing CA 11.1.4 dashboard using MS SSAS cube data source,
    
    MS SSAS cube utilizes custom relative time data sets (this is
    design option on MS SSAS cube side).
    
    CA 11.1.4 dashboard design requirement is to have two
    visualizations and to have relative time data sets filter
    applied to each of the visualizations.
    
    User is able to create required dashboard design and there is no
    issues during dashboard design process, after adding relative
    time data sets filers in dashboard design process visualizations
    are rendered as per applied filters, and user is able to save
    dashboard with applied filters.
    
    Issue starts when users try to run saved dashboard, dashboard
    does not render visualizations and returns following error in
    both of the visualization place holders:
    
    "Query services internal error has occurred please see the logs
    for details"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * n/a                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * see formal description                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix will not be provided for this issue.  If you find it
    exists in a current release of our software and would like
    re-evaluation, please contact Technical Support
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH20488

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B09

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-18

  • Closed date

    2022-12-05

  • Last modified date

    2022-12-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

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

Document Information

Modified date:
05 December 2022