IBM Support

PI87002: UPGRADED REPORT CONTAINING SEARCH AND SELECT PROMPT BASED ON A NESTED QUERY WITH CONCATENATED FIELDS THROWS ERROR: XQE-GEN-0005

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as unreproducible.

Error description

  • A report is created in Cognos 10 which contains a Search &
    Select prompt.  The prompt is based on a nested query, where the
    parent query contains complex calculations which concatenate
    various columns of different data types, including dates and
    strings.  When the report is upgraded to Cognos Analytics 11.0.7
    and executed, the user receives an error when attempting to
    search in the prompt:
    
    XQE-GEN-0005 Found an internal error:
    com.cognos.xqe.runtree.relational.vectorization.expressions.char
    acter.XVectorStringColumnConcatDateColumn
    

Local fix

  • Move the concatenation calculations from the parent query into
    the child query, and base the search & select prompt on the
    child query.
    

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

    PI87002

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B07

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-07

  • 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



Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: B07

Reference #: PI87002

Modified date: 29 June 2018


Translate this page: