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

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels