IBM Support

PH06970: IN QUERY STUDIO CLICK ICON COLLABSE GROUP ON A CALCULATION DATE ITEM WHICH IS GROUPED: IDENTIFIER NOT FOUND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as unreproducible.

Error description

  • In Query Studio when creating a report with a calculated date
    field and a group by on this item then the error message appears
    after clicking the icon Collabse Group.
    
    
    ------------------------------------------------------------
    Testcase Environment Cognos Analytics
    ------------------------------------------------------------
    
    Content Store Database: MS SQL Server 2008 R2 Standart Ed.
    Query Database: MS SQL Server 2008 R2 Standart Ed.
    Relevant Package: GO Sales (Query)
    Relevant Cognos Version: Cognos Analytics 11.0.13
    Relevant Cognos Version: Cognos Analytics 11.1.1
    
    ------------------------------------------------------------
    Steps to reproduce
    ------------------------------------------------------------
    
    (A) Restore the database:
    01. Restore the database GOSALES.bak which is located in the 7z
    files GOSALES.7z.001 and GOSALES.7z.002. You have to merge them
    together
    02. Create a database connection called great_outdoors_sales
    
    (B) Import the deployment:
    01. Copy the file 'QueryStudioError.zip'  into folder deployment
    of the Cognos Analytics 11.0.13 server installation folder
    02. Go to the welcome page and click Manage > Administration
    console > Configuration > Content Administration
    03. Click on the button new import, select the deployment
    'QueryStudioError' and click next twice
    04. Select the upcoming entries and click next three times
    05. Click finish
    
    (C) Steps to reproduce the customer issue:
    01. Navigate into the following path Team Content > GO Sales
    (Query) and run the report 'QueryStudioError'
    02. In Query Studio, in the icon bar click the icon Collabse
    Group
    Error: The following error message appears: XQE-V5-0005
    Identifier not found 'Date'.
    

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

    PH06970

  • Reported component name

    COG QUERY STUDI

  • Reported component ID

    5724W12QS

  • Reported release

    B0A

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-07

  • 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
Query Studio v11x

Software version: B0A

Reference #: PH06970

Modified date: 05 June 2019