IBM Support

PH16277: DATA MODULE BASED DASHBOARD FAILS WITH ERROR 'V5 SYNTAX ERROR FOUND IN EXPRESSION' WHEN ADDING FILTER ON CHARACTER DATA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Using a Data Module consisting of a Package Joined to Uploaded
    Files results in error in a Dashboard when filtering on
    character data.
    
    Example: ALL selected a the Filter value in the Dashboard fails
    with error:
    
    V5 syntax error found in expression
    "[Physical View].[Query Subject].[Query Item] in (ALL)", invalid
    token "All" found after "[Physical View].[Query Subject].[Query
    Item] in (".
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH16277

  • 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

    2019-08-30

  • Closed date

    2019-10-15

  • Last modified date

    2019-10-15

  • 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