IJ17042: UPGRADE TO MAXIMO 7.6.1.1 FAILS IN UPDATEDB.

APAR status

• Closed as program error.

Error description

• Abstract
  Upgrade to Maximo 7.6.1.1 fails in UpdateDB.
  
  Problem Description:
  Client is upgrading Maximo 7.6.0.9 to 7.6.1.1.  All scripts and
  patches are applied, then UpdateDB fails with very little error
  information:
  
  - Updating MaxAdmin user to match local database.
  update crontaskinstance set runasuserid = (select propvalue
  from maxpropvalue where propname = 'mxe.adminuserid') where
  runasuserid = 'MAXADMIN' and exists (select 1 from maxpropvalue
  where propname = 'mxe.adminuserid' and propvalue != 'MAXADMIN')
  ;
  // Updated 0 records.
  commit
  ;
  ERROR: null
      at psdi.tools.UpdateDB(UpdateDB.java: 3297)
      at psdi.tools.UpdateDB(UpdateDB.java: 3240)
  
  STEPS TO REPRODUCE:
  Install Maximo 7.6.1.1.  Run UpdateDB.
  
  EXPECTED RESULTS:
  UpdateDB should run start to finish with no interruption.
  
  PRODUCT VERSION:
  Maximo Asset Management 7.6.1.1.
  

Local fix

• We discovered that UpdateDB queries the value of maxvar ISDEMO.
   If 'ISDEMO' is not defined in tables MAXVARS and MAXVARTYPE,
  UpdateDB fails.  I provided this work around that client
  confirmed was successful:
  
  Create 'ISDEMO' using the following SQL statements, then
  restart UpdateDB.  UpdateDB should resume form where it left
  off and run to completion.
  
  On Oracle:
  Insert Into maxvars(varname, varvalue, maxvarsid) Values
  ('ISDEMO', '0', maxvarsseq.nextval) ;
  Insert Into maxvartype(varname, vartype, defaultvalue,
  description, maxvartypeid) Values ('ISDEMO', 'SYSTEM',
  '0','ISDemo maxvar', maxvartypeseq.nextval) ;
  Update maxsequence Set maxreserved=(Select max(maxvarsid) From
  maxvars) Where sequencename='MAXVARSSEQ' ;
  Update maxsequence Set maxreserved=(Select max(maxvartypeid)
  From maxvartype) Where sequencename='MAXVARTYPESEQ' ;
  
  On DB2:
  Insert Into maxvars(varname, varvalue, maxvarsid) Values
  ('ISDEMO', '0', nextval For maxvarsseq) ;
  Insert Into maxvartype(varname, vartype, defaultvalue,
  description, maxvartypeid) Values ('ISDEMO', 'SYSTEM',
  '0','ISDemo maxvar', nextval For maxvartypeseq) ;
  Update maxsequence Set maxreserved=(Select max(maxvarsid) From
  maxvars) Where sequencename='MAXVARSSEQ' ;
  Update maxsequence Set maxreserved=(Select max(maxvartypeid)
  From maxvartype) Where sequencename='MAXVARTYPESEQ' ;
  
  On SQL Server:
  Insert Into maxvars(varname, varvalue, maxvarsid) Select
  'ISDEMO', '0', max(maxvarvarsid)+1 From maxvars ;
  Insert Into maxvartype(varname, vartype, defaultvalue,
  description, maxvartypeid) Select  'ISDEMO', 'SYSTEM',
  '0','ISDemo maxvar', max(maxvartypeid)+1 From maxvartype ;
  Update maxsequence Set maxreserved=(Select max(maxvarsid) From
  maxvars) Where sequencename='MAXVARSSEQ' ;
  Update maxsequence Set maxreserved=(Select max(maxvartypeid)
  From maxvartype) Where sequencename='MAXVARTYPESEQ' ;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Admins                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ISDEMO maxvar missing from environment; if statement was not *
  * checking for if null                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• added a check for if null
  

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

  UPGRADE PROGRAM

• Fixed component ID

  5724R46UP

Applicable component levels