JR50832: Workspace approval with approveUniqueViolationAction enabled cau ses Index out of bounds exception.

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• Workspace approval with approveUniqueViolationAction enabled may
  experience an Index out of bounds exception if a unique/foreign
   key conflict is detected on a workspace table with foreign keys
   with child tables (or ancestor tables) that are NOT workspace
  enabled.
  
  The problem only occurs when the conflicting records are both in
   the same workspace and loaded via dataload.  For example, the
  SEOURLKEYWORD table may have two records with identical
  KEYWORD+STORE_ID columns and different primary keys.  The Task
  Group ends up in a Commit Failed state and data is not approved.
  

Local fix

• Customers can avoid issues by ensuring they do not create
  records with both duplicate Unique indexes and different primary
   keys.  Conflicting changes can be removed using the undo
  function.
  

Problem summary

• USERS AFFECTED:
  WC customers using workspaces with configuration value
  approveUniqueViolationAction enabled.
  
  PROBLEM ABSTRACT:
  Workspace approval with approveUniqueViolationAction enabled
  causes Index out of bounds exception.
  
  BUSINESS IMPACT:
  WC customers may not be able to approve a workspace task group.
  
  RECOMMENDATION:
  

Problem conclusion

• Processing logic was changed so that child tables that are not
  workspace enabled are bypassed and additional checks for the
  index size on Lists were added.
  

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