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
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * **************************************************************** See work item for details : https://jazz.net/jazz/web/projects/Jazz%20Foundation#action= com.ibm.team.workitem.viewWorkItem?id=270524
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