IBM Support

IT14771: UPGRADE FAILS AT DBSCHEMA STEP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • traceTPCInstall.log or lax*out.txt will show:
    
    StringIndexOutOfBoundsException: String index out of range: 15
    
    and subsequent upgrade attempts will show:
    
    INFO SQL statement: INSERT INTO TEMP_PLAN_OPTIMIZATION_RECOMMEND
    Ýjava¨ SQLSTATE: 42802, Vendor error code: -117
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who upgrade TPC to a version like 5.2.6, 5.2.7, 5.2.8  *
    * or to 5.2.9 when TPC db username is the same or contains     *
    * same character sequence as the TPC DB password (case         *
    * sensitive)                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fix maintenance when available.                        *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is targeted for the following maintenance
    package:
    
    | refresh pack | 5.2-TIV-TPC-RP0010 - target 2Q16
    
    Fixed in IBM Spectrum Control 5.2.10.
    
    http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future refresh packs do not represent a
    formal commitment by IBM. The dates are subject to change
    without notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14771

  • Reported component name

    TPC ADVANCED

  • Reported component ID

    5608TPCA0

  • Reported release

    529

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-12

  • Closed date

    2016-04-19

  • Last modified date

    2016-04-19

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

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

Modules/Macros

  • INSTALL
    

Fix information

  • Fixed component name

    TPC ADVANCED

  • Fixed component ID

    5608TPCA0

Applicable component levels

  • R526 PSY

       UP

  • R527 PSY

       UP

  • R528 PSY

       UP

  • R529 PSY

       UP

[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSNECY","label":"Tivoli Storage Productivity Center Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"529"}]

Document Information

Modified date:
26 September 2021