JR49982: This fix is to ensure relevant records in STAGLOG correctly have their STGPROCESSED columns updated after propagation completes

APAR status

• Closed as program error.

Error description

• This fix is to ensure relevant records in STAGLOG correctly have
  their STGPROCESSED columns updated after propagation completes
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who have installed APAR
  JR42158. Note that this APAR is included in FixPack 6.
  
  PROBLEM ABSTRACT:
  StagingProp may not mark some propagated STAGLOG records as
  processed due to database timestamp discrepancies
  
  BUSINESS IMPACT:
  StagingProp utility may not mark all propagated STAGLOG records
  as processed. Subsequent invocations of the StagingProp utility
  may attempt propagation of records that have already been
  propagated, which could potentially cause unique (primary) key
  or foreign key violations.
  
  RECOMMENDATION:
  Follow the local fix specified in the "Workaround" section or
  contact WebSphere Commerce Support for assistance
  

Problem conclusion

• Logic in the StagingProp utility assumed that values in both the
   STGRFNBR and STGSTMP would be increasing and uses values from
  these columns (among others) to select the set of records to
  mark as processed.
  
  In some databases, long-running transactions use timestamps from
  when query execution first begins. This can cause concurrent
  transactions that start later, to potentially insert records in
  the STAGLOG table that have lower STGRFNBR values but higher
  STGSTMP values, which violates the assumption previously stated.
  As a result, no records are selected which can then be marked as
  processed.
  
  To rectify, the utility no longer makes assumptions about
  monotonicity between the two columns.
  
  -------------------------------------------------------------
  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 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 EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP