IBM Support

IT22974: LARGE MAILBOX MESSAGE ID'S (MORE THAN 2147483647) CAUSE SERVICE ERRORS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Error description
    IBM Sterling B2B Integrator V5.2.6 and earlier.
    
    When a mailbox message ID greater than 2^31-1 (2147483647)
    resides in a mailbox, the Mailbox Rule Evaluate services and
    Mailbox Extract services returns errors.
    
    Mailbox Evaluate Routing Rule / Evaluate All Automatic Routing
    Rules (in mailbox.log):
    [2017-10-29 09:52:56.946] ERROR 000110060004
    WORKFLOW.ACTIVITY_ENGINE.
    ERR_ActivityEngineHelper_invokeService2 ActivityEngineHelper.
    invokeService() caught exception while attempting to execute
    service
    MailboxEvaluateAllAutomaticRules
    [2017-10-29 09:52:56.946] ERROR [1509285176946] Numeric Overflow
    [2017-10-29 09:52:56.946] ERRORDTL [1509285176946]java.sql.
    SQLException: Numeric Overflow
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow
    (NumberCommonAccessor.java:4381)
    at
    oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAcces
    sor.
    java:132)
    at
    oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImp
    l.
    java:942)
    at com.sterlingcommerce.woodstock.services.mailbox.
    MailboxEvaluateAllASAPRulesService.loadCurrentMessages
    (MailboxEvaluateAllASAPRulesService.java:190)
    at com.sterlingcommerce.woodstock.services.mailbox.
    MailboxEvaluateAllASAPRulesService.primitiveProcessData
    (MailboxEvaluateAllASAPRulesService.java:130)
    at
    com.sterlingcommerce.woodstock.services.mailbox.MailboxService$1
    .run
    (MailboxService.java:137)
    at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.
    runContained(DatabaseOperation.java:102)
    at
    com.sterlingcommerce.woodstock.services.mailbox.MailboxService.
    processData(MailboxService.java:135)
    at com.sterlingcommerce.woodstock.workflow.activity.engine.
    ActivityEngineHelper.invokeService(ActivityEngineHelper.java:182
    6)
    at com.sterlingcommerce.woodstock.workflow.activity.engine.
    ActivityEngineHelper.nextMainLogic(ActivityEngineHelper.java:631
    )
    at com.sterlingcommerce.woodstock.workflow.activity.engine.
    ActivityEngineHelper.next(ActivityEngineHelper.java:362)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.
    doWork(WorkFlowQueueListener.java:461)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.
    run(WorkFlowQueueListener.java:240)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.
    onMessage(WorkFlowQueueListener.java:197)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.
    onMessage(WorkFlowQueueListener.java:184)
    at
    com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run
    (wfTransporter.java:444)
    
    Mailbox Extract Begin Service:
    2017-10-30 07:34:14.214] ERRORDTL
    [1509363254214]com.sterlingcommerce.woodstock.workflow.WorkFlowE
    xception
    : Problem in service FileGatewayArrivedFileService (Exception
    com.sterlingcommerce.woodstock.workflow.WorkFlowException:
    Mandatory
    Parameter Missing: MessageId in FileGatewayArrivedFileService.
    at
    com.sterlingcommerce.fg.services.FileGatewayArrivedFileService.p
    rimitive
    ProcessData(FileGatewayArrivedFileService.java:71)
    at
    com.sterlingcommerce.fg.services.TransformingRouterService.proce
    ssData(T
    ransformingRouterService.java:79)
    at
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHe
    lper.invokeService(ActivityEngineHelper.java:1826)
    at
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHe
    lper.nextMainLogic(ActivityEngineHelper.java:631)
    at
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHe
    lper.next(ActivityEngineHelper.java:362)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.doWo
    rk(WorkFlowQueueListener.java:461)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.run(
    WorkFlowQueueListener.java:240)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.onMe
    ssage(WorkFlowQueueListener.java:197)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.onMe
    ssage(WorkFlowQueueListener.java:184)
    at
    com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run(
    wfTransp
    orter.java:444)
    at
    com.sterlingcommerce.woodstock.workflow.queue.BasicExecutor$Work
    er.run(B
    asicExecutor.java:508)
    at java.lang.Thread.run(Thread.java:798)
    

Local fix

  • STRRTC - 554301
    DCM / DCM
    
    No workaround available
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    Mailbox Extract service cannot handle message ID's greater than
    2^31.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    Delivered In:
    5020603_3
    5020500_18
    5020601_10
    5020602_6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22974

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    526

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-30

  • Closed date

    2017-11-06

  • Last modified date

    2018-06-04

  • 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":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
04 June 2018