IV85360: WHEN TRYING TO RUN UPDATERICHTEXT.BAT FOR A BIG AMOUNT OF RECORDS IT FAILS FOR INSUFFICIENT TEMPORARY SPACE IN THE D

APAR status

• Closed as program error.

Error description

• When trying to run updateRichText.bat for a big amount of
  records it fails for insufficient temporary space in the DB
  
  
  PROBLEM:
  
  When trying to run updateRichText.bat for a big amount of
  records it fails for insufficient temporary space in the DB
  
  10970101 10970102 08:27:04:327 PM The following SQL is used to
  retrieve
  the set of attributes to migrate: select
  longdescriptionid,ldtext from
  longdescription where longdescriptionid > 10970102 order by
  longdescriptionid ASC
  java.sql.SQLException: ORA-01652: unable to extend temp segment
  by 128
  in table space TEMP.
  
  
  PERFORMANCE ISSUE: No.
  
  
  STEPS TO REPRODUCE:
  
  Run updateRichText.bat for a big amount of records.
  
  
  CURRENT ERRONEOUS RESULT:
  
  It is not reconnecting to the database between restart queries
  to release temporary space.
  
  
  EXPECTED RESULT:
  
  It should reconnect to the database between restart queries to
  release temporary space.
  
  
  ENVIRONMENT (SYSTEM INFO):
  
  App Server IBM WebSphere Application Server 8.5.5.3
  
  Version
  IBM Maximo for Nuclear Power 7.5.1.0-20151228-1225 Build
  20121004-0300
  DB Build V7510-17 HFDB Build HF7510-60
  Tivoli's process automation engine 7.6.0.3 Build 20160114-1313
  DB Build
  V7603-151
  IBM TPAE Integration Framework 7.6.0.3 Build 20160108-1912 DB
  Build
  V7603-21
  IBM Maximo Asset Management 7.6.0.3 Build 20160113-2204 DB
  Build V7603-
  01
  
  Server OS Linux 2.6.32-431.40.1.el6.x86_64
  Server DB Oracle 11.2 (Oracle Database 11g Enterprise Edition
  Release
  11.2.0.4.0 - 64bit Production With the Partitioning option)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running updateRichText.bat with a large number of records    *
  * fails with insufficient temporary space in the DB.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest release.                                   *
  ****************************************************************
  STEPS TO REPRODUCE:
  Run updateRichText.bat for a big amount of records.
  
  CURRENT ERRONEOUS RESULT:
  Following error is logged.
  10970101 10970102 08:27:04:327 PM The following SQL is used to
  retrieve the set of attributes to migrate: select
  longdescriptionid,ldtext from longdescription where
  longdescriptionid > 10970102 order by longdescriptionid ASC
  java.sql.SQLException: ORA-01652: unable to extend temp segment
  by 128 in table space TEMP.
  
  EXPECTED RESULT:
  It should reconnect to the database between restart queries to
  release temporary space.
  

Problem conclusion

• updateRichText.bat releases temporary space in the DB when
  restarting queries.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Fix Pack Release 7.6.0.6 TPAE
  

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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels

• R760 PSY

     UP