IBM Support

IT14821: UNABLE TO DELETE MESSAGES FROM THE MAILBOX

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

  • Environment Information
    
    Sterling B2B Integrator version: 5241_4 on AIX 7.1
    HotfixVersion: 5020401_4_BR37578_401089_HF3
    MS SQL Server 2008 R2 (Windows)
    
    Problem Statement:
    
    Unable to delete mailbox messages as Mailbox Delete Service
    fails with the below error.
    
    ERROR Message:
    
    [2016-03-01 00:00:14.486] DEBUG
    MailboxDeleteService.processData() - Starting ...
    [2016-03-01 00:00:14.487] DEBUG
    MailboxDeleteService.registerService() - Successfully
    registered with Ops.
    [2016-03-01 00:00:14.487] DEBUG
    MailboxDeleteService.getUserToken() - Found userToken from wfc:
    [admin]
    [2016-03-01 00:00:14.487] DEBUG MailboxDeleteService
    MailboxPaths: null
    [2016-03-01 00:00:14.487] DEBUG
    PermissionManager.canExecute(S,S,i) checking user [admin] for
    permission [MailboxGlobalDelete] with rights [1]
    [2016-03-01 00:00:14.881] DEBUG RepositoryDB.deleteMessages() -
    Running delete on new transaction
    [2016-03-01 00:00:14.887] DEBUG RepositoryDB.deleteMessages() -
    deleting messages:
    [2016-03-01 00:00:14.9] DEBUG
    PermissionManager.haveMailboxPermission() entered
    mailboxPath:/WBC/SYSTEM/QVALENT_LOOP_BACK user:admin
    [2016-03-01 00:00:14.9] DEBUG
    PermissionManager.canExecute(S,S,i) checking user [admin] for
    permission [/WBC/SYSTEM/QVALENT_LOOP_BACK.mbx] with rights [8]
    [2016-03-01 00:00:14.965] DEBUG
    PermissionManager.haveMailboxPermission() <<<Permission
    Exists>>> for /WBC/SYSTEM/QVALENT_LOOP_BACK user:admin
    [2016-03-01 00:00:14.966] DEBUG
    PermissionManager.haveMailboxPermission() exiting
    mailboxPath:/WBC/SYSTEM/QVALENT_LOOP_BACK user:admin
    [2016-03-01 00:00:15.248] ERROR  [MailboxDeleteService] -
    setting WFC Status to ERROR with Advanced Status [Mailbox
    Repository Error]
    [2016-03-01 00:00:15.249] ERROR [1456750815249] Failed to load
    crypto information for an existing key.
    [2016-03-01 00:00:15.249] ERRORDTL
    [1456750815249]java.sql.SQLException: Failed to load crypto
    information for an existing key.
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:700)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:586)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:564)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:543)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:524)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.releaseDocument(RepositoryDB.java:4755)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.access$1000(RepositoryDB.java:106)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB$6.body(RepositoryDB.java:1406)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._run
    InTransaction(DatabaseOperation.java:335)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runI
    nTransaction(DatabaseOperation.java:144)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.deleteMessages(RepositoryDB.java:1354)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB$4$1.body(RepositoryDB.java:1140)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._run
    InTransaction(DatabaseOperation.java:335)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runI
    nTransaction(DatabaseOperation.java:144)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation$1.ca
    ll(DatabaseOperation.java:168)
        at
    java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:31
    5)
        at java.util.concurrent.FutureTask.run(FutureTask.java:150)
        at
    java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoo
    lExecutor.java:898)
        at
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
    cutor.java:920)
        at java.lang.Thread.run(Thread.java:736)
    
    [2016-03-01 00:00:15.249] ERROR 000000000000 GLOBAL_SCOPE
    [MailboxDeleteService] - setting WFC Status to ERROR with
    Advanced Status [Mailbox Repository Error]
    java.sql.SQLException: Failed to load crypto information for an
    existing key.
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:700)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:586)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:564)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:543)
        at
    com.sterlingcommerce.woodstock.workflow.Document.<init>(Document
    .java:524)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.releaseDocument(RepositoryDB.java:4755)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.access$1000(RepositoryDB.java:106)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB$6.body(RepositoryDB.java:1406)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._run
    InTransaction(DatabaseOperation.java:335)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runI
    nTransaction(DatabaseOperation.java:144)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB.deleteMessages(RepositoryDB.java:1354)
        at
    com.sterlingcommerce.woodstock.mailbox.impl.repositoryImpl.Repos
    itoryDB$4$1.body(RepositoryDB.java:1140)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._run
    InTransaction(DatabaseOperation.java:335)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runI
    nTransaction(DatabaseOperation.java:144)
        at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation$1.ca
    ll(DatabaseOperation.java:168)
        at
    java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:31
    5)
        at java.util.concurrent.FutureTask.run(FutureTask.java:150)
        at
    java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoo
    lExecutor.java:898)
        at
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
    cutor.java:920)
        at java.lang.Thread.run(Thread.java:736)
    [2016-03-01 00:00:15.249] DEBUG
    MailboxDeleteService.processData() - Un-registered thread with
    Ops.
    [2016-03-01 00:00:15.249] DEBUG
    MailboxDeleteService.processData() - Exiting ...
    

Local fix

  • STRRTC 494435
    JG / JG
    Circumvention: None
    

Problem summary

  • Users Affected:
    ALL
    
    Problem Description:
    Unable to delete mailbox messages when the messages are
    encrypted and crypto information is missing.
    
    Platforms Affected:
    ALL
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    Delivered In:
    5020602
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14821

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    521

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-18

  • Closed date

    2016-05-26

  • Last modified date

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

  • R526 PSY

       UP

[{"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.1","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
02 June 2016