IV68166: TDTOOLKIT FAILS TO UPDATE REPORTAPPAUTH TABLE.

APAR status

• Closed as program error.

Error description

• During the upgrade from TSRM/CCMDB 7.2.1 to ISCCD 7.5.1,
  tdtoolkit fails with the following error.
  
  2014-12-17 18:57:04 - BMXAA7498E - SQL Error -803
  2014-12-17 18:57:04 - BMXAA7499I - SQL Error message One or
  more values in the INSERT statement, UPDATE statement, or
  foreign key update caused by a DELETE statement are not
  valid because the primary key, unique constraint or unique
  index identified by "2" constrains table "MAXADMIN.
  REPORTAPPAUTH" from having duplicate values for the index
  key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.11.69
  2014-12-17 18:57:04 - BMXAA7500I - SQL Error statement
  update reportappauth set runtype = 'KASUTAMU' where
  runtype = 'CUSTOM'
  
  Note that 'KASUTAMU' means Japaense version of 'CUSTOM'
  
  This is recreatable in L2 test environment.
  
  STEPS TO REPRODUCE:
  1) Install TSRM 7.2.1 and CCMDB 7.2.1 specifying Japanese
  as a base language and English as an additional language.
  
  2) Apply TSRM 7.2.1.6 and CCMDB 7.2.1.4.
  
  3) Upgrade Websphere from 6.1 to 7.0.
  
  4) Upgrade from 7.2.1 to ISCCD 7.5.1. During the upgrade,
  uncheck the following option.
  
  - Copy files now, but perform the installation configuration
  step later
  
  Then the following options are automatically selected.
  
  - Deploy application files manually later
  - Defer the Update of the Maximo Database
  
  5) Without running updatedb and tdtoolkit at this stage,
  apply ISCCD 7.5.1.1 because the following techntoe suggests so.
  
  http://www-01.ibm.com/support/docview.wss?uid=swg21639876
  
  During the installation of ISCCD 7.5.1.1, uncheck the following
  option.
  
  - Copy files now, but perform the installation configuration
  step later
  
  Then the following options are automatically selected.
  
  - Deploy application files manually later
  - Defer the Update of the Maximo Database
  
  6) Then run updatedb -v1.
  
  7) Then run "TDToolkit -IMPORT -SLEN - TLJA" but it encounters
  the following error.
  
  2014-12-17 18:56:54 - BMXAA7569I - Updating domains from XLIFF
  file : ..\..\tools\maximo\ja\xliff\SYNONYMDOMAIN.xliff.
  2014-12-17 18:56:54 - BMXAA7573I - Sorting domain records for
  SYNONYM domain.
  2014-12-17 18:57:04 - BMXAA7498E - SQL Error -803
  2014-12-17 18:57:04 - BMXAA7499I - SQL Error message One or
  more values in the INSERT statement, UPDATE statement, or
  foreign key update caused by a DELETE statement are not
  valid because the primary key, unique constraint or unique
  index identified by "2" constrains table "MAXADMIN.
  REPORTAPPAUTH" from having duplicate values for the index
  key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=4.11.69
  2014-12-17 18:57:04 - BMXAA7500I - SQL Error statement
  update reportappauth set runtype = 'KASUTAMU' where
  runtype = 'CUSTOM'
  
  This was also written into TDToolkit20141217185551.log.
  
  8) I tried to run the following SQL manually
  but it failed with the same error.
  
  update reportappauth set runtype = 'KASUTAMU' where runtype =
  'CUSTOM'
  
  This is a issue with script V7500_422.dbc.
  The problem is that the script "blindly" inserts these values
  even if they have already been inserted and translated.
  So when the TDToolkit try to translate it again, it runs
  into this problem due to duplicates.
  

Local fix

• Delete the duplicates from the database before running
  tdtoolkit.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All non-English Users                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Duplicates in the database causes TDToolkit error in log.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack Release 7.5.0.8 of Base Services or request an *
  * interim fix.                                                 *
  ****************************************************************
  

Problem conclusion

• Fix has been made to issue above.
  

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

  PRODUCT INSTALL

• Fixed component ID

  5724R46IT

Applicable component levels

• R750 PSY

     UP