IBM Support

IBM Sterling B2B Integrator errors when Max Workflow ID value is reached

Troubleshooting


Problem

Errors that can occur when max wf_id value is greater than 2147483648.

Symptom

Unable to view child business processes in Business Process Monitor.

External purge fails.

BP Meta data service fails to find the workflow_id.

NumberFormatException observed in logs for workflow_ids exceeding the allowable integer data type 2147483648. wf.log, noapp.log, extpurge logs may contain errors similar to the following,


noapp.log:
ALL 000000000000 GLOBAL_SCOPE java.lang.NumberFormatException: For input string:"2157982124"
...

extpurge.log:


java.lang.NumberFormatException: For input string: "2148107610"
at java.lang.NumberFormatException.forInputString
...

wf.log:

WORKFLOW.SERVICES.ERR_BPMetaDataService_Exception9 Caught DB error while retrieving WFD_ID by WORKFLOW_ID

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
11 February 2020

UID

swg21699816