JR44901: ERROR DURING INFLIGHT DATA UPGRADE FROM TW 6.2.2 TO IBM BPM 7.5.X (TWU-0050: FAILED DURING BATCH INSERT TX)

Version 8.0.1 Fix Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• Customer may meet following issue when inflight data upgrade
  from Teamworks 6.2.2 to IBM BPM 7.5.x versions. This APAR will
  fix this issue.
  
  SEVERE: com.lombardi.upgrade.inflight.
  UpgradeContext - TWU-0050: Failed during batch insert tx,
  table='twperf2.TG_IC_KCI_Result'.
  org.springframework.jdbc.BadSqlGrammarException:
  PreparedStatementCallback; bad SQL grammar [
  INSERT INTO BPM_PERF.TG_IC_KCI_Result (
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  IBM Business Process Management users       *
  ****************************************************************
  * PROBLEM DESCRIPTION: TWU-0050: Failed during batch insert    *
  *                      tx may happen when upgrading inflight   *
  *                      data from TeamWorks 6.2.2 to BPM 7.5.x  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When upgrading inflight data from TeamWorks 6.2.2 to BPM
  7.5.x with Oracle DB as the database, the migration tool
  may incorrectly treating the new column name in 7.5
  (resultType) as a reserved SQL word and therefore reports
  TWU-0050: Failed during batch insert tx.
  

Problem conclusion

• The iFix provided will treat the new column name as the right
  one.
  
  Install/Dependency information is available in the readme.txt
  on FixCentral. When the user goes to the download files page
  in FixCentral, the readme will be available with the fix
  package as a separate download. The ifix can be downloaded on
  the fix central.
  

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

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R750 PSY

     UP