Direct links to fixes
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":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
02 June 2016