IJ32672: WHEN RUNNING UPDATEDB AFTER INSTALLING MAXIMO 7.6.1.2 YOU GET AN ISSUE WITH THE CLASS FILE : PSDI.IOTCONN.EN.V7603_28

APAR status

• Closed as program error.

Error description

• PROBLEM:
  
  When running updatedb after installing Maximo 7.6.1.2 you get
  an issue with running updatdb for the script .V7603_28
  
  
  STEPS TO REPLICATE:
  
  Install Maximo 7.6.1.2
  run updatedb
  
  you will get this issue in logfile:
              Calling the class file : psdi.iotconn.en.V7603_28
  Thu Feb 11 14:53:20 CET 2021
     ------------------------------------------------------------
  -------
               Calling the script file : V7603_28 Thu Feb 11
  14:53:20 CET 2021
     ------------------------------------------------------------
  -------
  update maxsequence set maxreserved = (select max(maxreserved)
  from maxsequence where sequencename in ('MAXATTRIBUTESEQ',
  'MAXATTRIBUTECFGSEQ') ) where sequencename in
  ('MAXATTRIBUTESEQ', 'MAXATTRIBUTECFGSEQ')
  ;
  
  // Updated 2 records.
  
  commit
  ;
  
  /* * freeform: script file V7603_28
  */
  commit
  ;
  
  commit
  ;
  
  ERROR: null
  	at psdi.util.StringUtility(StringUtility.java: 424)
  	at psdi.iotconn.en.V7603_28(V7603_28.java: 62)
  	at psdi.script.AutoUpgradeTemplate(AutoUpgradeTemplate.java:
  420)
  	at psdi.iotconn.en.V7603_28(V7603_28.java: 40)
  	at sun.reflect.NativeConstructorAccessorImpl(NativeConstructor
  AccessorImpl.java:Native Method)
  	at sun.reflect.NativeConstructorAccessorImpl(NativeConstructor
  AccessorImpl.java:83)
  	at sun.reflect.DelegatingConstructorAccessorImpl(DelegatingCon
  structorAccessorImpl.java:57)
  	at java.lang.reflect.Constructor(Constructor.java: 437)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  451)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  277)
  	at psdi.tools.RunScripts(RunScripts.java: 156)
  	at psdi.tools.UpdateDB(UpdateDB.java: 2888)
  	at psdi.tools.UpdateDB(UpdateDB.java: 2763)
  	at psdi.tools.UpdateDB(UpdateDB.java: 2275)
  	at psdi.tools.UpdateDB(UpdateDB.java: 5593)
  	at psdi.tools.UpdateDB(UpdateDB.java: 282)
  	at psdi.tools.UpdateDB(UpdateDB.java: 3245)
  
  EXPECTED RESULTS:
  Updatedb run with issue
  
  ENVIRONMENT:
  
  IBM Maximo Asset Management Work Centers 7.6.0.4 Build
  20200715-0100 DB Build V7604-119 HFDB Build HF7680-10,
  IBM Maximo Asset Management Scheduler 7.6.8.0 Build
  20200715-0100 DB Build V7680-148 HFDB Build HF7680-15,
  IBM Tpae Integration Framework 7.6.1.2 Build 20200615-2330 DB
  Build V7612-11,
  IBM Maximo Asset Management 7.6.1.2 Build 20200715-0100 DB Build
  V7611-01,
  IBM Maximo for Oil and Gas 7.6.1.0-20200805-1125 Build
  20161020-0803 DB Build V7610-139 HFDB Build HF7610-56,
  IoT Connection Utility 7.6.0.3 Build 20200701-1409 DB Build
  V7603-32
  -- Database Server Name: Microsoft SQL Server
  Database Server Version: 14.00.3238
  Database Server Major Version: 14 , Minor Version: 0
  Database Server Driver Name: Microsoft JDBC Driver 7.4 for SQL
  Server
  Database Server Driver Version: 7.4.1.0
  Database Server Driver  Major Version: 7 , Driver Minor Version:
  4
  Java Version: 1.8.0_151
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When running updatedb after installing Maximo 7.6.1.2 you    *
  * get                                                          *
  *  an issue with running updatdb for the script .V7603_28      *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels