JR56321: Preprocess utility fails after executing catalog entry type due to lock on catalog group (or vise versa)

7.0.0.0-WS-WC70Fep8Server-IFJR56321
7.0.0.0-WS-WC70Fep8Developer-IFJR56321

APAR status

• Closed as program error.

Error description

• di-preprocess utility fails after successfully completing one
  index type because of a lock found in the delta table of the
  next index type. This lock was not checked if it exists before
  starting the preprocess of the first index type.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 and Version 8 systems that might
  have preprocessing jobs overlapping and running while other jobs
   are running.
  
  PROBLEM ABSTRACT:
  Preprocess utility fails after executing catalog entry type due
  to lock on catalog group (or vise versa)
  
  BUSINESS IMPACT:
  Preprocess fails.
  
  RECOMMENDATION:
  

Problem conclusion

• The issue was fixed by first checking if there are any locks in
  the database before preprocessing any of the index types. If
  there are no locks, then locks are inserted to all delta tables
  before starting the preprocessing.
  

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