IJ22228: CUE - UNIQUE ID AND KEY ATTRIBUTES HAVE NOT BEEN CONVERTED TO BIGINT/19 FORMAT LOADING

APAR status

• Closed as program error.

Error description

• Missing SAMEAS
  The complete list of attributes that should be converted to
  BIGINT/19 follows:
  
  STEPS TO REPRODUCE:
  1 - Login on Maximo as admin user.
  2 - Go to System Configuration > Platform Configuration >
  Database Configuration.
  3 - Verify the objects/attributes below.
  PLUSDACGDETAIL.ACGDETAILKEY(UPPER/20) Same As:
  PLUSDACGDETAIL.PLUSDACGDETAILID(INTEGER/12) Same As:
  PLUSDCU.PLUSDCUID(INTEGER/12) Same As:
  PLUSDCUCONTROL.PLUSDCUCONTROLID(INTEGER/12) Same As:
  PLUSDCUDETAIL.CUDETAILKEY(INTEGER/12) Same As:
  PLUSDCUDETAIL.PLUSDCUDETAILID(INTEGER/12) Same As:
  PLUSDCUEACTCODE.PLUSDCUEACTCODEID(INTEGER/12) Same As:
  PLUSDCUEACTOVRD.PLUSDCUEACTOVRDID(INTEGER/12) Same As:
  PLUSDCUEASSTCDE.PLUSDCUEASSTCDEID(INTEGER/12) Same As:
  PLUSDCUELBRADDR.PLUSDCUELBRADDRID(INTEGER/12) Same As:
  PLUSDCUELOADTYP.PLUSDCUELOADTYPID(INTEGER/12) Same As:
  PLUSDCUEWORKZNE.PLUSDCUEWORKZNEID(INTEGER/12) Same As:
  PLUSDCUEWRKTYPE.PLUSDCUEWRKTYPEID(INTEGER/12) Same As:
  PLUSDCULABOR.CULABORKEY(INTEGER/12) Same As:
  PLUSDCULABOR.PLUSDCULABORID(INTEGER/12) Same As:
  PLUSDCUMATERIAL.CUMATERIALKEY(INTEGER/12) Same As:
  PLUSDCUMATERIAL.PLUSDCUMATERIALID(INTEGER/12) Same As:
  PLUSDCUSERVICE.PLUSDCUSERVICEID(INTEGER/12) Same As:
  PLUSDCUSPEC.PLUSDCUSPECID(INTEGER/12) Same As:
  PLUSDCUSPEC.REFOBJECTID(INTEGER/12) Same As:
  PLUSDCUSTATUS.PLUSDCUSTATUSID(INTEGER/12) Same As:
  PLUSDCUTOOL.CUTOOLKEY(INTEGER/12) Same As:
  PLUSDCUTOOL.PLUSDCUTOOLID(INTEGER/12) Same As:
  PLUSDESTCONTRCT.PLUSDESTCONTRCTID(INTEGER/12) Same As:
  PLUSDESTCONTROL.PLUSDESTCONTROLID(INTEGER/12) Same As:
  PLUSDESTDETAIL.ESTDETAILKEY(INTEGER/12) Same As:
  PLUSDESTDETAIL.PARENTESTDTLKEY(INTEGER/12) Same As:
  PLUSDESTDETAIL.ESTDETAILKEY
  PLUSDESTDETAILTMP.PARENTESTDTLKEY(INTEGER/12) Same As:
  PLUSDESTDETAIL.ESTDETAILKEY
  PLUSDSUMCONTVIEW.PARENTESTDTLKEY(INTEGER/12) Same As:
  PLUSDESTDETAIL.ESTDETAILKEY
  PLUSDESTDETAIL.PLUSDESTDETAILID(INTEGER/12) Same As:
  PLUSDESTDETAILTMP.ESTDETAILKEY(INTEGER/12) Same As: (SHOULD BE
  SAME AS PlusDEstDetail.EstDetailKey)
  PLUSDCOSTCONTRTMPVIEW.ESTDETAILKEY(INTEGER/12) Same As:
  PLUSDESTDETAILTMP.ESTDETAILKEY
  PLUSDESTSTATUS.PLUSDESTSTATUSID(INTEGER/12) Same As:
  PLUSDESTVERSION.PLUSDESTVERSIONID(INTEGER/12) Same As:
  PLUSDSTATION.PLUSDSTATIONID(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY(INTEGER/12) Same As:
  PLUSDACGDETAIL.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDACGDETAIL.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDCOSTCONTRTMPVIEW.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDCOSTCONTRTMPVIEW.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDCOSTCONTRVIEW.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDCOSTCONTRVIEW.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDESTDETAIL.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDESTDETAIL.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDESTDETAILTMP.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDESTDETAILTMP.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTATION.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTNDETAIL.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTNDETAIL.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTNPARAM.BACKTOSTNKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTNPARAM.STATIONKEY(INTEGER/12) Same As:
  PLUSDSTATION.STATIONKEY
  PLUSDSTNDETAIL.PLUSDSTNDETAILID(INTEGER/12) Same As:
  PLUSDSTNDETAIL.STNDETAILKEY(INTEGER/12) Same As:
  PLUSDESTDETAIL.STNDETAILKEY(INTEGER/12) Same As:
  PLUSDSTNDETAIL.STNDETAILKEY
  PLUSDESTDETAILTMP.STNDETAILKEY(INTEGER/12) Same As:
  PLUSDSTNDETAIL.STNDETAILKEY
  PLUSDSTNPARAM.PLUSDSTNPARAMID(INTEGER/12) Same As:
  WPITEM.PLUSDESTDETAILID(INTEGER/12) Same As: (SHOULD BE SAME AS
  PlusDEstDetail.EstDetailKey)
  WPMATERIAL.PLUSDESTDETAILID(INTEGER/12) Same As:
  WPITEM.PLUSDESTDETAILID (SHOULD BE SAME AS
  PlusDEstDetail.EstDetailKey)
  WPSERVICE.PLUSDESTDETAILID(INTEGER/12) Same As:
  WPITEM.PLUSDESTDETAILID (SHOULD BE SAME AS
  PlusDEstDetail.EstDetailKey)
  WPTOOL.PLUSDESTDETAILID(INTEGER/12) Same As:
  WPITEM.PLUSDESTDETAILID (SHOULD BE SAME AS
  PlusDEstDetail.EstDetailKey)
  WPLABOR.PLUSDESTDETAILID(INTEGER/12) Same As: (SHOULD BE SAME
  AS PlusDEstDetail.EstDetailKey)
  
  Results
  The list of attributes above still have Integer/12.
  
  Expected Results
  The list of attributes above should be converted to BIGINT/19:
  
  Product Version:
  IBM Maximo for Utilities 7.6.0.2-20190701-1214 Build
  20171128-1353 DB Build V7602-68 HFDB Build HF7602-09
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo for Utilities users.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CUE - UNIQUE ID AND KEY ATTRIBUTES HAVE NOT BEEN CONVERTED   *
  * TO  BIGINT/19 FORMAT LOADING                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack  Release 7.6.0.2 of Base Services or request   *
  * an interim fix                                               *
  ****************************************************************
  

Problem conclusion

• Fix has been made
  

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:

Modules/Macros

• Maximo
  

Fix information

• Fixed component name

  MAXIMO UTILITIE

• Fixed component ID

  5724R5600

Applicable component levels