JR45284: FAILED DURING PROCESSING OF THE ROW HAPPENS DURING INFLIGHTDATA UPGRADE IN DATABASETABLEUPGRADESTEP

Download Version 8.0.1 Fix Pack 2 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 error message during inflight data
  upgrade from TW 6.2.x to BPM:
  SEVERE: com.lombardi.upgrade.inflight.
  UpgradeContext - TWU-0050: Failed during batch insert tx,
  table='LSW_OPTIMIZER_DATA'.
  com.lombardi.upgrade.inflight.UpgradeException: Fatal stop:
  TWU-----:
  TRACKED_FIELD_NOT_FOUND arg x xxxxx
      This issue is caused by some TG data has been cleaned but
  the the
  optimizer table still keeps those values. So when migrate the
  error
  happens. This ifix will fix this issue and prevent the error
  message
  like this.
  

Local fix

• Modify "sql.optimizerData.select" in performancedb-sql.xml to
  ignore
  those optimizer records which don't have corresponding
  tracked_field
  
    SELECT
    TRACKING_POINT_VALUE_ID,
    TRACKED_FIELD_ID,
    NUMBER_VALUE,
    DATE_VALUE,
    STRING_VALUE
   FROM LSW_OPTIMIZER_DATA
   WHERE TRACKING_POINT_VALUE_ID IN
   (SELECT TRACKING_POINT_VALUE_ID FROM (
   SELECT DISTINCT
    TRACKING_POINT_VALUE_ID
   FROM LSW_OPTIMIZER_DATA
   WHERE TRACKING_POINT_VALUE_ID > :TRACKING_POINT_VALUE_ID
   ORDER BY TRACKING_POINT_VALUE_ID)
   WHERE ROWNUM <= {0})
    AND
   TRACKED_FIELD_ID IN
   (SELECT TRACKED_FIELD_ID FROM LSW_TRACKED_FIELD)
   ORDER BY TRACKING_POINT_VALUE_ID,TRACKED_FIELD_ID
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Business Process Manager users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Exception happen occurs when            *
  *                      migrating TeamWorks 6.x to the BPM      *
  *                      7.5.x for the data in table             *
  *                      LSW_OPTIMIZER_DATA                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using Tracking Groups on TeamWorks 6.x, data is generated
  in both process table and performance/optimizer
  (LSW_OPTIMIZER_DATA) table. When task is complete only the
  process table is cleaned while the optimzer table data is kept.
  During migration from TeamWork 6.x to BPM 7.5.x, and while
  processing the data in table LSW_OPTIMIZER_DATA, reconciling
  the entries with the empty process table fails.
  

Problem conclusion

• The fix reconciles the data between the two tables before
  processing the migration step.
  
  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.
  

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