Direct links to fixes
APAR status
Closed as program error.
Error description
In Accelerator (for B2B store), when creating a new Contract (or editing an existing one) for an account, there is an 'Attachment' tab that allows references to an external document for the contract details. Populating this field will insert a record in the ATTACHMENT table. However , the record is created with ATTACHMENT.MEMBER_ID set to the USER_ID of the user who is logged into Accelerator, rather than an organization id or store_id. This problem could surface when running stagingprop utility, if the ATTACHMENT was first created on the staging server. Stagingprop may fail because the MEMBER_ID (user) does not necessarily exist on production database.
Local fix
Problem summary
USERS AFFECTED: All WebSphere Commerce users on v6.0 or v7.0 who create contracts and add an attachment to the contract record. PROBLEM ABSTRACT: This fix is to assign the ownership of a contract attachment to an ORGENTITY rather than a USER. BUSINESS IMPACT: This behaviour can cause stagingprop utility to fail, as the ATTACHMENT record is owned by a user rather than an organization, but user data is not propagated by stagingprop. This can cause a foreign key violation, and lead to failed propagation. RECOMMENDATION:
Problem conclusion
The ATTACHMENT record created by the attachment section of the contract creation will now be owned by the organization who owns the store in which the contract was created, rather than by the user who created the contract. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
SE48270
Reported component name
WC BUS EDIT AS4
Reported component ID
5724I3803
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-27
Closed date
2011-09-29
Last modified date
2011-09-29
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
WC BUS EDIT AS4
Fixed component ID
5724I3803
Applicable component levels
R600 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
29 September 2011