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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error 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      *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

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

    2013-12-16

  • 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

Add comments

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.1.1

Reference #:

PM88181

Modified date:

2013-12-16

Translate my page

Machine Translation

Content navigation