IBM Support

IJ17042: UPGRADE TO MAXIMO 7.6.1.1 FAILS IN UPDATEDB.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    IJ17042

  • Reported component name

    UPGRADE PROGRAM

  • Reported component ID

    5724R46UP

  • Reported release

    761

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-06-19

  • Closed date

    2019-07-24

  • Last modified date

    2019-07-24

  • 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



Document information

More support for: Maximo Asset Management
Upgrade Programs

Software version: 761

Reference #: IJ17042

Modified date: 24 July 2019