IT14876: SCHEDULE_BPLINKAGEPURGESERVICE ERROR OCCURS WHEN WF_ID > 2147483647

si_52_build_5020500_interimfix_13
si_52_build_5020500_interimfix_13
si_52_build_5020500_interimfix_13

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 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