IBM Support

IV50764: QUERY WITH STRSCAN FAILS WITH LONG TERM HISTORY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A query defined with the STRSCAN function on a column returns
    data for real time and short term history, but fails with an
    error when used to retrieve long term history.
    RECREATE INSTRUCTIONS:
    Create a query using the STRSCAN function, verify it returns
    real time
    and short term history, then modify the view to retrieve long
    term
    history data.
    

Local fix

Problem summary

  • A query defined with the STRSCAN function on a column fails with
     an error when used to retrieve long term history.
    
    
    A query defined with the STRSCAN function on a column returns
    data for real time and short term history, but fails with an
    error when used to retrieve long term history.  An error message
    similar to the following will be seen in the portal server log:
    
    [IBM][CLI Drivcw.er] CLI0100E  Wrong number of parameters.
    SQLSTATE=07001,
    GENERIC SQLSTATE: 07001, ERR: -99999
    

Problem conclusion

  • Modified code to use correct string scan function for ODBC data
    sources.
    
    The fix for this APAR is included in the following
    maintenance vehicle:
    
    | fix pack | 6.3.0-TIV-ITM-FP0003
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV50764

  • Reported component name

    TEPS

  • Reported component ID

    5724C04PS

  • Reported release

    623

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-14

  • Closed date

    2014-01-30

  • Last modified date

    2014-08-08

  • 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

  • R630 PSY

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCTLMQ","label":"ITM Tivoli Enterprise Portal Server V6"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"623","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
08 August 2014