IV72828: BMXAA7025E SCRIPT FAILED APPLYING HOTFIX TO TPAE 7.5.0.6 HF7520_17 MODIFY_TABLE SKDLABORHRS

APAR status

• Closed as program error.

Error description

• Problem :
  Running updatedb after applying hotfix 10 of 7.5.0.6
  
  During the processing of HF7520_17     * modify_table
  SKDLABORHRS
  
  
  BMXAA7025E -- Script failed while running.;
  
  sql#17059;
  Konvertierung zu interner Darstellung nicht erfolgreich
  
  psdi.util.MXSystemException: sql#17059
  
      at psdi.dbmanage.FrameworkData.selectFirstInteger(Unknown
  Source)
      at
  psdi.dbmanage.statement.MaximoMboModel.executeUpdate(Unknown
  Source)
       at psdi.dbmanage.statement.MaximoMboModel.execute(Unknown
  Source)
       at psdi.dbmanage.statement.ModifyMboStatement.run(Unknown
  Source)
       at psdi.dbmanage.statement.Script.runStatement(Unknown
  Source)
  
  .........
  
  Caused by: java.sql.SQLException: Konvertierung zu interner
  Darstellung
  nicht erfolgreich
  
      at
  oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.
  java:147
  )
       at
  oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.
  java:818
  )
       at
  oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImp
  l.java:9
  28
  
  
  It appears to be some form of integar conversion related
  problem.
  
  
  
  Reporting environment :
  Tivoli's process automation engine 7.5.0.6-IFIX201 5021
  1 -1 21 6
  Build 20140404-0005 DB Build "-/7506-33 HFDB Build HF7506-16 I
  App Server IBM WebSphere Application Server 7.0.0.35
   IBM Maximo Asset Management 7.5.0.6 Build 20140404-0000 DB
  Build "-/7506-00 1
  } IBM Maximo for Transportation 7.5 .1 .0-20150209-0647 Build
  20150209-0647 DB Build "-/7510-10 HFDB Build HF7510-23
   Tivoli's process automation engine 7.5 .0 .6-IFIX201 5021 1 -1
  21 6
  Build 20140404-0005 DB Build "-/7506-33 HFDB Build HF7506-16 I
  { IBM Maximo for Service Providers 7.5 .3 .0-201 501 29-1 21 3
  Build
  20150129-1213 DB Build "-/7530-19 HFDB Build HF7530-05
   IBM Maximo Asset Configuration Manager 7.5.1 .1-20150210-0622
  Build
  20110623-0635 DB Build "-/7511-06 HFDB Build HF7511-06
  1' IBM Maximo Asset Management Scheduler 7.5.2.0 Build
  20140404-0005 DB
  Build "-/7520-156 HFDB Build HF7520-15
  ' IBM TPAE Integration Framework 7.5 .1 .1 Build 20140411-2000
  DB Build
  "-/7511-01
  Server OS Windows Server 2006 6.0 build 6002 Service Pack 2 I
  Server DB Oracle 11 .2 (Oracle Database 11g Enterprise Edition
  Release
  11 .2 .0 .3 .0 - 64bit Production With the Partitioning, OLAP,
  Data
  Mining and Real Application Testing options) g
  _ (c) Copvright IBM Corp. 2012 ,
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo Users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Incorrectly written script.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack Release of 7.6.0.4 of Base Services.           *
  ****************************************************************
  

Problem conclusion

• Incorrect script has been fixed.
  

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

  UPGRADE PROGRAM

• Fixed component ID

  5724R46UP

Applicable component levels

• R760 PSY

     UP