IJ12788: UNABLE TO CHANGE THE LENGTH OF ITEM.ITEMNUM FROM 30 TO 40

APAR status

• Closed as program error.

Error description

• Unable to change the length of ITEM.ITEMNUM from 30 to 40
  
  Admin user is unable to increase the length of ITEM.ITEMNUM
  attribute 30 -> 40 in Database Configuration.
  
  When saving the following error is displayed.
  BMXAA0597E - Primary Column must have consecutive values with
  no gaps, starting with 1. More information
  
  It looks like it is only reproducible with Maximo for Aviation
  7.6.7.0
  
  Application effected
  ====================
  Database Configuration
  
  Steps to reproduce
  ===================
  
  1. Login in as MAXADMIN
  2. Go to Database Configuration --> Filter for ITEM --> Click
  on Attribute and bring up ITEMNUM
  3. Change the length from 30 to 40
  4. Save changes
  
  RESULTS / PROBLEM
  ==================
  BMXAA0597E - Primary Column must have consecutive values with
  no gaps, starting with 1. More information
  
  Expected Results
  ================
  Maximo should allow the user to increase the field length from
  30 to 40
  
  Product Version
  ===============
  Tivoli's process automation engine 7.6.1.0 Build 20180718-1141
  DB Build V7610-83
  
  IBM Maximo for Aviation 7.6.7.0 Build 20180731-1633 DB Build
  V7670-66
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo for Aviation Users on 7670.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UNABLE TO CHANGE THE LENGTH OF ITEM.ITEMNUM FROM 30 TO 40    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack  Release 7.5.0.8 of Base Services or request   *
  * an interim fix                                               *
  ****************************************************************
  

Problem conclusion

• Fix has been made to fix 05.
  

Temporary fix

Comments

APAR Information

• 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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels

• R761 PSY

     UP