IV29879: USING SUBSTR COLUMN FUNCTION AND ORACLE WAREHOUSE FAILS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • APAR Type:            Field
    Approver Initials:    mb
    Severity:             3
    Reported Release:     622
    Compid:               5724C04PS Tivoli Enterprise Portal Server
    ABSTRACT:             Using substr column function and Oracle
    warehouse fails
    PROBLEM DESCRIPTION:
    When using the SUBSTR function on a column and the warehouse is
    configured for Oracle, then the requests are done via JDBC. In
    the JDBC code the translation is not done when the SUBSTR
    function wraps the column name.
    .
    RECREATE INSTRUCTIONS:
    Configure the TEPS for an Oracle Warehouse and then create a
    query that uses the SUBSTR function.
    .
    

Local fix

Problem summary

  • When specifying a query to the Warehouse database, the long
    column names need to be specified in the query and not the short
     name.  When the Oracle Warehouse is specified, the portal
    server eWAS JDBC code does not handle the translation properly
    and uses the short name which causes the query to fail with:
    
    KFWITM354E The Timespan request terminated with the following
    message:
    KFWITM217E: Request error java.sql.SQLException ORA-00904:
    "UNIXDISK"."MOUNTPT".  Invalid identifier.
    
    The column name 'MOUNTPT' and table name 'UNIXDISK' in the above
    message will be different based on the agent table and column in
    the query.
    

Problem conclusion

  • The code was modified to parse out the SUBSTR( ) value and
    translate the column name.
    
    The fix for this APAR is contained in the following maintenance
    packages:
    
      | fix pack | 6.2.3-TIV-ITM-FP0003
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV29879

  • Reported component name

    TEP

  • Reported component ID

    5724C04EP

  • Reported release

    622

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-09

  • Closed date

    2013-01-02

  • Last modified date

    2013-05-06

  • 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

    TEPS

  • Fixed component ID

    5724C04PS

Applicable component levels

  • R622 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Components
ITM Tivoli Enterprise Portal Server V6

Software version:

622

Reference #:

IV29879

Modified date:

2013-05-06

Translate my page

Machine Translation

Content navigation