Direct links to fixes
APAR status
Closed as program error.
Error description
The Schedule_BPLinkagePurgeService process is failing when WORKFLOW_LINKAGE.ROOT_WF_ID exceeds the maximum integer value of 2147483647. The records are not deleted and the following error is found in the system log: [2016-03-07 05:00:13.862] ERROR WFLinkagePurgeService:Exception occured while purging. [2016-03-07 05:00:13.862] ERROR [1457348413862] For input string: "2147483778" [2016-03-07 05:00:13.862] ERRORDTL [1457348413862]java.lang. NumberFormatException: For input string: "2147483778" at java.lang.NumberFormatException.forInputString (NumberFormatException.java:77) at java.lang.Integer.parseInt(Integer.java:507) at java.lang.Integer.parseInt(Integer.java:539) at com.sterlingcommerce.woodstock.services.wflinkagepurge. WFLinkagePurgeService.purgeEligibleLinkage(WFLinkagePurgeService .java: 259) at com.sterlingcommerce.woodstock.services.wflinkagepurge. WFLinkagePurgeService.run(WFLinkagePurgeService.java:450) at java.lang.Thread.run(Thread.java:795) [2016-03-07 05:00:13.862] ERROR 000000000000 GLOBAL_SCOPE WFLinkagePurgeService:Exception occured while purging. java.lang.NumberFormatException: For input string: "2147483778" at java.lang.NumberFormatException.forInputString (NumberFormatException.java:77) at java.lang.Integer.parseInt(Integer.java:507) at java.lang.Integer.parseInt(Integer.java:539) at com.sterlingcommerce.woodstock.services.wflinkagepurge. WFLinkagePurgeService.purgeEligibleLinkage(WFLinkagePurgeService .java: 259) at com.sterlingcommerce.woodstock.services.wflinkagepurge. WFLinkagePurgeService.run(WFLinkagePurgeService.java:450) at java.lang.Thread.run(Thread.java:795) The customer queried their WORKFLOW_LINKAGE Table and found the following values: max(ROOT_WF_ID) = 2147483793 max(P_WF_ID) = 2147484066 max(C_WF_ID) = 2147484071 This problem was also observed on support instances 5020500_8 (Oracle), 5020600 (SQL Server) and 5020601 (DB2). To reproduce the problem, update WORKFLOW_LINKAGE to set ROOT_WF_ID equal to 2147484000. Run Schedule_BPLinkagePurgeService. Observe that Business Process Linkage Data Purge Service step reports "Error occured in purging process.". Find "java.lang.NumberFormatException: For input string:" error in system log. Note that problem was a little different in 5020601: The Schedule_BPLinkagePurgeService completed successfully and there was no error in the system log. However, the record (with ROOT_WF_ID = 2147484000) was still not deleted from the WORKFLOW_LINKAGE table. When I updated the value to "555555" and ran Schedule_BPLinkagePurgeService again, it was deleted.
Local fix
STRRTC - 494732 PC / PC Circumvention: Run PurgeAll and reset WFUNIQUEID.MAX_VALUE to "1" (one). Disable Schedule_BPLinakgePurgeService and manually delete all rows from WORKFLOW_LINKAGE where ROOT_WF_ID < MIN(WF_ID) from ARCHIVE_INFO where GROUP_ID = 1.
Problem summary
PLATFORMS AFFECTED: ALL PROBLEM DESCRIPTION: Schedule_BPLinkagePurgeService error occurs when WF_ID > 2147483647. The Schedule_BPLinkagePurgeService process fails when WORKFLOW_LINKAGE.ROOT_WF_ID exceeds the maximum value of 2147483647 USERS AFFECTED: ALL
Problem conclusion
A code fix is provided. The fix removes the parent child BP linkage when the WF_ID is greater than 2147483647. DELIVERED IN: 5020500_13 5020603 5020601_7
Temporary fix
Comments
APAR Information
APAR number
IT14876
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
524
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-04-20
Closed date
2016-05-27
Last modified date
2017-03-08
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
STR B2B INTEGRA
Fixed component ID
5725D0600
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
11 September 2023