IBM Support

PM96713: [WI 270524] Running /repotools-?APP?.sh -addTables failed in 4.0.4

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • APAR Based on existing Jazz defect workitem
    
    https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.
    ibm.team.workitem.viewWorkItem&id=270524
    
    Version 4.0.4
    
    While running the repotools-<APP> upgrade scripts, it fails with
    this
    error: (Note in this example the app is QM)
    
    
    
    <snip>
    
    Running post addTables for 'com.ibm.rqm.requirement'...
    
    Running post addTables for 'Interop ClearQuest Manager Migration
    
    Handler'...
    
    Running post addTables for 'Full Text Migration Handler'...
    
    Running post addTables for 'Interop WorkItem Manager Migration
    
    Handler'...
    
    CRJAZ0577E The following SQL query did not execute properly on
    the
    server:
    
    CREATE UNIQUE INDEX MARKERS_UNIQUE_MARKER ON MARKERS.MARKER(URI,
    
    USER_COL,
    
    APPLI
    
    CATION, TYPE)
    
    The user 'ADMIN' has logged out of the database
    
    '//server.com:9433;databaseName=qm;user=xxxxxxxx;password=xxxxxx
    xx'.
    
    CRJAZ1425E The database encountered an error while attempting to
    create
    indices
    
    for the table 'MARKER'.
    
    
    Warning! The maximum key length is 900 bytes. The index
    
    'MARKERS_UNIQUE_MARKER' has maximum length of 3500 bytes. For
    some
    combination of large values, the insert/update operation will
    fail.
    Msg 1946, Level 16, State 3, Line 1  Operation failed. The index
    entry of length 2048 bytes for the index
    'MARKERS_UNIQUE_MARKER' exceeds the maximum length of 900 bytes.
     The statement has been terminated.
    

Local fix

Problem summary

Problem conclusion

  • Fixed in 4.0.5
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM96713

  • Reported component name

    RATL QUALITY MG

  • Reported component ID

    5724V1000

  • Reported release

    401

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-10

  • Closed date

    2014-01-07

  • Last modified date

    2014-08-26

  • 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

    RATL TEAM CONCE

  • Fixed component ID

    5724V0400

Applicable component levels

  • R401 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCP65","label":"Rational Team Concert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
26 August 2014