Fixes are available
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 number
JR45284
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-01-04
Closed date
2013-03-21
Last modified date
2013-03-21
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 January 2022