PM88181: Error received when search numeric column in filter creation by using Teradata

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In report studio report, if search the numeric data as keywords
    when a custom filter is created, the error message has received.
    The problem occurred on Teradata database (verion 13)   Error
    message: RQP-DEF-0177: An error occurred while performing
    operation 'sqlPrepareWithOptions' status = '-69'. Details:
    UDA-SQL-0043 The underlying database detected an error during
    processing the SQL request.  [Teradata][ODBC Teradata
    Driver][Teradata Database] Partial string matching requires
    character operands. (screenshots have been attached)  When '6'
    is inserted and search, the UDA trace gets the following. select
    distinct         ITEM.L_ORDERKEY  as  L_ORDERKEY  from
    Teradata..retail.ITEM ITEM  where         (ITEM.L_ORDERKEY like
    '6%')  order by         L_ORDERKEY asc" in t20001
    macrovaluecallback, collate "en-au" , disable metadata cache,
    XFormClientServer, enable nagging, first row, database only,
    avoid zero
    division;]]></SQLAPI>]]></item></parameters></function>??
    RSVP.PROMPT.CASTNUMERICSEARCHKEYTOSTRING has enabled. But still
    has the same result.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 1 or IBM Cognos Business Intelligence 10.1.1 Fix Pack 3 or   *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 2                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM88181

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-01

  • Closed date

    2013-09-10

  • Last modified date

    2014-11-26

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

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

Fix information

  • Fixed component name

    COG REPORT STUD

  • Fixed component ID

    5724W12RS

Applicable component levels

  • RA21 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.1.1

Reference #:

PM88181

Modified date:

2014-11-26

Translate my page

Machine Translation

Content navigation