IBM Support

PI34211: FEATURE LEVEL UPGRADE NEEDS BETTER DATA CHECKING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer was trying to do an in-place Feature Level
    upgrade of their database from FL 7 to Fl 8 and it was taking
    days to complete.
    Most of this time was spend on fixing relationships
    via millions of update statement like the following:
    
    CRMMD1466E Item '48767144' (dbid=48767144) of record type
    'CR_AffectedItem' has an invalid reference to 'CR' in field
    'ParentCR' (bad value=34350312). This field will be cleared.
    CRMMD1466E Item '48767184' (dbid=48767184) of record type
    'CR_AffectedItem' has an invalid reference to 'CR' in field
    'ParentCR' (bad value=34350312). This field will be cleared.
    CRMMD1466E Item '48767206' (dbid=48767206) of record type
    'CR_AffectedItem' has an invalid reference to 'CR' in field
    'ParentCR' (bad value=34350312). This field will be cleared.
    CRMMD1466E Item '48767234' (dbid=48767234) of record type
    'CR_AffectedItem' has an invalid reference to 'CR' in field
    'ParentCR' (bad value=34350312). This field will be cleared.
    CRMMD1466E Item '48767366' (dbid=48767366) of record type
    'CR_AffectedItem' has an invalid reference to 'CR' in field
    'ParentCR' (bad value=34350312). This field will be cleared.
    
    and
    CRMMD1466E Item '33877656' (dbid=33877656) of record type
    'attachments' has an invalid reference to 'ratl_replicas' in
    field 'ratl_keysite' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '33877657' (dbid=33877657) of record type
    'attachments' has an invalid reference to 'ratl_replicas' in
    field 'ratl_keysite' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '33877660' (dbid=33877660) of record type
    'attachments' has an invalid reference to 'ratl_replicas' in
    field 'ratl_keysite' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '33877661' (dbid=33877661) of record type
    'attachments' has an invalid reference to 'ratl_replicas' in
    field 'ratl_keysite' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '33877664' (dbid=33877664) of record type
    'attachments' has an invalid reference to 'ratl_replicas' in
    field 'ratl_keysite' (bad value=2001448192). This field will be
    cleared.
    
    and
    CRMMD1466E Item '34349010' (dbid=34349010) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '34349011' (dbid=34349011) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '34349012' (dbid=34349012) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '34349013' (dbid=34349013) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '34349014' (dbid=34349014) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    CRMMD1466E Item '34349015' (dbid=34349015) of record type
    'history' has an invalid reference to 'ratl_replicas' in field
    'ratl_mastership' (bad value=2001448192). This field will be
    cleared.
    

Local fix

  • No work-around known at this time.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When doing feature level upgrades, ClearQuest sometimes has  *
    * inefficient data checking.                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.1.8
    ClearQuest now has more efficient data checking when doing
    feature level upgrades.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI34211

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-02-04

  • Closed date

    2015-06-29

  • Last modified date

    2015-06-29

  • 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

    CLEARQUEST WIN

  • Fixed component ID

    5724G3600

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"801","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
15 October 2021