IV33971: UPDATEDB FAILS IN SERVICE PROVIDER SCRIPT V7511_03

APAR status

• Closed as program error.

Error description

• Client is applying SCCD fixpack 7.5.0.1.  UpdateDB fails in
  Service Provider class V7511_03 with error:
  
  java.sql.SQLException: Fail to convert to internal
  representation
   at
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
  ng.java:70)
   at
  oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.j
  ava:131)
   at
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
  .java:197)
   at
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
  .java:261)
   at
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
  .java:269)
   at
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
  .java:490)
   at
  oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.
  java:141)
   at
  oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.
  java:779)
   at
  oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImp
  l.java:712)
   at
  oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:3
  88)
   at
  psdi.serviceprovider.en.V7511_03.moveDomainValues(V7511_03.java:
  91)
  
  -- BEGINUPDATEDBERROR
  -- Product: IBM Maximo for Service Providers
  -- Error running file: V7511_03
  -- UPDATEDBFILE:V7511_03.class
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Maximo for Service Providers 7.5.1.1, while upgrading    *
  * from a previous version.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When upgrading from a previous version, script V7511_03      *
  * tries to retrieve column ROWSTAMP from table MAXDOMAIN as an *
  * integer, causing                                             *
  * error:<br/><br/><span><span>java.sql.SQLException: Fail to   *
  * convert to internal representation</span></span>             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please install the latest interim fix for this Service       *
  * Providers 7.5.1.1.                                           *
  ****************************************************************
  

Problem conclusion

• Fixed handling of field ROWSTAMP, but using long integer instead
  of integer, solving the problem.
  

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

  SERVICE PROVIDE

• Fixed component ID

  5724R46SV

Applicable component levels