IBM Support

IT31926: MAILBOXQUERYSERVICE THROWS NULLPOINTEREXCEPTION IF END_TIME COLUMN VALUE IN ACT_XFER TABLE IS NULL

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

  • [2019-09-21 03:39:46.063] DEBUG DuplicatePolicyFactory
    returning: com.sterlingcommerce.woodstock.mailbox.impl.repositor
    yImpl.DuplicatesAllowedPolicy@5a40d866
    [2019-09-21
    03:39:46.063] DEBUG MailboxQueryService - Query Parameters
    [MessageQuery: 22169042true] queried successfully.
    [2019-09-21
    03:39:46.085] ERROR [MailboxQueryService] - setting WFC Status
    to ERROR with Advanced Status [Mailbox Service
    Error]
    [2019-09-21 03:39:46.085] ERROR [1569033586085]
    null
    [2019-09-21 03:39:46.086] ERRORDTL
    [1569033586085]java.lang.NullPointerException
    at com.sterlingcom
    merce.woodstock.services.mailbox.MailboxQueryService.buildExtrac
    tedElement(MailboxQueryService.java:506)
    at com.sterlingcommerce
    .woodstock.services.mailbox.MailboxQueryService.setWFCSuccessRes
    ponse(MailboxQueryService.java:400)
    at com.sterlingcommerce.wood
    stock.services.mailbox.MailboxQueryService.primitiveProcessData(
    MailboxQueryService.java:278)
    at com.sterlingcommerce.woodstock.
    services.mailbox.MailboxService$1.run(MailboxService.java:137)
    a
    t com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.ru
    nContained(DatabaseOperation.java:102)
    at com.sterlingcommerce.w
    oodstock.services.mailbox.MailboxService.processData(MailboxServ
    ice.java:135)
    at com.sterlingcommerce.woodstock.workflow.activit
    y.engine.ActivityEngineHelper.invokeService(ActivityEngineHelper
    .java:1826)
    at com.sterlingcommerce.woodstock.workflow.activity.
    engine.ActivityEngineHelper.nextMainLogic(ActivityEngineHelper.j
    ava:631)
    at com.sterlingcommerce.woodstock.workflow.activity.eng
    ine.ActivityEngineHelper.next(ActivityEngineHelper.java:362)
    at
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.doWork(WorkFlowQueueListener.java:461)
    at com.sterlingcommer
    ce.woodstock.workflow.queue.WorkFlowQueueListener.run(WorkFlowQu
    eueListener.java:240)
    at com.sterlingcommerce.woodstock.workflow
    .queue.WorkFlowQueueListener.onMessage(WorkFlowQueueListener.jav
    a:197)
    at com.sterlingcommerce.woodstock.workflow.queue.WorkFlow
    QueueListener.onMessage(WorkFlowQueueListener.java:184)
    at com.s
    terlingcommerce.woodstock.workflow.queue.wfTransporter.run(wfTra
    nsporter.java:447)
    at com.sterlingcommerce.woodstock.workflow.qu
    eue.BasicExecutor$Worker.run(BasicExecutor.java:508)
    at
    java.lang.Thread.run(Thread.java:798)
    

Local fix

  • B2BISFG-7763
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    A condition exists between the time DMI information
    about a mailbox event and the time a business
    process invokes the
    MailboxQueryService to consume it.  The MailboxQueryService may
    throw a NullPointerException if the END_TIME column from a row
    in the ACT_XFER table has not been initialized.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    A solution was provided to fix the timing issue.
    
    Delivered in:
    5020603_14
    5020604_4
    5020605_2
    6000302
    6000202
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31926

  • 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

    2020-02-20

  • Closed date

    2020-03-13

  • Last modified date

    2020-09-02

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
03 September 2020