JR46785: CMVC 228406 - Issue a non-zero exit code on missing physical data conditions during StagingProp invocation

APAR status

• Closed as program error.

Error description

• During propagation of changed data by the StagingProp utility,
  primary keys pointed to by the STAGLOG table may not exist in
  the physical table whose data is to be propagated. This can
  occur due to a variety of reasons, e.g., primary key
  update.\line \line StagingProp marks the meta-data in the
  STAGLOG table for such records with an STGPROCESSED column value
   of -5 for diagnostic purposes.\line \line To further improve
  diagnosis, the utility will also issue a non-zero exit code,
  specifically exit-code 163, once it finishes execution to make
  users aware of such issue(s).
  

Local fix

• Inspect the STAGLOG table on the staging database to see if any
  records exist with an STGPROCESSED column value of -5 after
  StagingProp has finished executing to see if any missing
  physical data conditions were encountered
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 who are prone to missing
  physical data (primary-key) conditions during StagingProp
  utility invocation
  
   PROBLEM ABSTRACT:
   Issue a non-zero exit code on missing physical data conditions
  during StagingProp invocation
  
   BUSINESS IMPACT:
   Customers may not be able to readily identify whether any
  missing physical data conditions were encountered during
  invocation of the StagingProp utility
  
   RECOMMENDATION:
   Inspect the STAGLOG table on the staging database to see if any
  records exist with an STGPROCESSED column value of -5 after
  StagingProp has finished executing to see if any missing
  physical data conditions were encountered
  

Problem conclusion

• y physical data missing conditions were encountered, the
  StagingProp utility records an indicator to exit with a special
  exit-code if no other more severe, but tolerable errors were
  encountered. Upon completion, if this indicator is set, the
  exit-code is issued.
   -------------------------------------------------------------
   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