IBM Support

IT14570: THE ALERTS MAY NOT BE CORRECTLY MIGRATED WHEN UPGRADING IN IBM SPECTRUM CONTROL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following errors relative to the alerts migration can be
    seen in the traceTPCInstall.log:
    
    2016-01-04 12:02:52.144+0000 INFO
    com.ibm.tpc.install.backend.rules.RulesMigrationManager
    consolidateAlertsAndRules No consolidation was done for this
    alert.
    2016-01-04 12:02:52.144+0000 ERROR
    com.ibm.tpc.install.backend.rules.RulesMigrationManager
    consolidateAlertsAndRules
    com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException DB2
    SQL Error: SQLCODE=-803, SQLSTATE=23505,
    SQLERRMC=1;TPC.T_RULE_CONSTRAINT, DRIVER=3.65.77
    com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2
    SQL Error: SQLCODE=-803, SQLSTATE=23505,
    SQLERRMC=1;TPC.T_RULE_CONSTRAINT, DRIVER=3.65.77
            at com.ibm.db2.jcc.am.cd.a(cd.java:694)
            at com.ibm.db2.jcc.am.cd.a(cd.java:60)
            at com.ibm.db2.jcc.am.cd.a(cd.java:127)
            at com.ibm.db2.jcc.am.jo.b(jo.java:2420)
            at com.ibm.db2.jcc.am.jo.c(jo.java:2403)
            at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
            at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
            at com.ibm.db2.jcc.t4.p.a(p.java:50)
            at com.ibm.db2.jcc.t4.rb.b(rb.java:220)
            at com.ibm.db2.jcc.am.ko.nc(ko.java:3414)
            at com.ibm.db2.jcc.am.ko.b(ko.java:4377)
            at com.ibm.db2.jcc.am.ko.hc(ko.java:2743)
            at com.ibm.db2.jcc.am.ko.execute(ko.java:2723)
            at
    com.ibm.tpc.install.backend.rules.RulesMigrationDBQueryUtil.addR
    uleConstraintToDB(RulesMigrationDBQueryUtil.java:2985)
    
    The error "An Unexpected response was received from the server."
    occurs when trying to display the alerts in the IBM Spectrum
    Control Web-GUI after the upgrade.
    
    
    Other Affected Products/Components:
    IBM Spectrum Control 5.2.8.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Control 5.2.8 users                             *
    ****************************************************************
    * 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-RP0009 - target 2Q16
    
    Fixed in IBM Spectrum Control 5.2.9.
    
    http://www.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.
    
    |MDVREGR 5.2-TIV-TPC-RP0008 |
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14570

  • Reported component name

    TPC ADVANCED

  • Reported component ID

    5608TPCA0

  • Reported release

    528

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-01

  • Closed date

    2016-04-01

  • Last modified date

    2016-04-01

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

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

Modules/Macros

  • ALERT
    

Fix information

  • Fixed component name

    TPC ADVANCED

  • Fixed component ID

    5608TPCA0

Applicable component levels

  • R528 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"528","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
22 February 2022