JR50445: Feature Pack 7 foundation and store-enablement fails on IBM-i.

APAR status

• Closed as program error.

Error description

• Feature Pack 7 foundation/store-enablement fails during the
  creation of the CIVD_ATTRDICTSF trigger on table
  ATTRDICTSRCHCONF.
  
   The failure appears as a DB2 syntax error exception -
  "Specified delete rule not allowed with trigger on table
  ATTRDICTSRCHCONF in DEMO".
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 who have installed FEP 7 on
  IBM-i and would like to enable the features
  
   PROBLEM ABSTRACT:
   Feature Pack 7 foundation and store-enablement fails on IBM-i.
  
   BUSINESS IMPACT:
   Impacts upgrade of WebSphere Commerce instances.
  
   RECOMMENDATION:
  

Problem conclusion

• To enable the trigger and subsequent triggers to be created
  successfully, the following SQL statements were added to the
  components/foundation/schema/fep7/os400/wcs.cascade.trigger.foun
  dation.production.sql script:
  
   ALTER TABLE ATTRDICTSRCHCONF DROP CONSTRAINT F_3679#
   ALTER TABLE ATTRDICTSRCHCONF DROP CONSTRAINT F_3681#
   ALTER TABLE ATTRDICTSRCHCONF DROP CONSTRAINT F_3680#
  
   ALTER TABLE ATTRDICTSRCHCONF ADD CONSTRAINT F_3679 FOREIGN KEY
  (MASTERCATALOG_ID) REFERENCES CATALOG (CATALOG_ID)#
   ALTER TABLE ATTRDICTSRCHCONF ADD CONSTRAINT F_3681 FOREIGN KEY
  (ATTRTYPE_ID) REFERENCES ATTRTYPE (ATTRTYPE_ID)#
   ALTER TABLE ATTRDICTSRCHCONF ADD CONSTRAINT F_3680 FOREIGN KEY
  (ATTR_ID) REFERENCES ATTR (ATTR_ID)#
  
   The aforementioned statements convert cascade-delete foreign
  key relationships to a no-action foreign key relationship so
  that the "after delete" triggers can be created successfully in
  the IBM-i environment.
   -------------------------------------------------------------
   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