JR57592: Database migration from V7 to V8 might fail with 'Specified delete rule not allowed' error

APAR status

• Closed as program error.

Error description

• Database migration from WebSphere Commerce Version 7 to Version
  8 might fail on IBM i operating systems with 'Specified delete
  rule not allowed' error.
  For example:
  
  ERROR:
  /CommerceServer80/migration/xml/features/BASE/db/70/databaseTask
  s.xml:283: The following error occurred while
  executing this line:
  ERROR:
  /CommerceServer80/migration/xml/features/BASE/db/70/commonEnable
  mentTasks.xml:43: com.ibm.db2.jdbc.app.DB2SQLS
  yntaxErrorException: Specified delete rule not allowed with
  trigger on table PLLOCSTATIC in STAGING.
  
  Note: table name can be PLLOCSTATIC, SHPMODCLCD , EXPRESSION,
  etc.
  

Local fix

• 1. In schema/os400/wcs.tables.with.after.delete.triggers.xml,
  copy <table>shpmodclcd</table> from <fp0> section and add to
  <fp9> section to fix the shpmodclcd issue.
  
  2. In
  {WC}/components/common/xml/os400/wcs.tables.with.after.delete.tr
  iggers-foundation.xml, add the below <fepmigration> code sample
  (after </fep8> and before </featurepack>)
  
  <fepmigration>
      <staged>
        <table>expression</table>
        <table>pagelayout</table>
        <table>pllocstatic</table>
        <table>plproperty</table>
      </staged>
      <cacheivl>
        <table>expression</table>
        <table>pagelayout</table>
        <table>pllocstatic</table>
        <table>plproperty</table>
      </cacheivl>
    </fepmigration>
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on Version 7 who use iSeries backend
  databases and want to migrate to Version 8.
  
  PROBLEM ABSTRACT:
  Database migration from V7 to V8 might fail with 'Specified
  delete rule not allowed' error
  
  BUSINESS IMPACT:
  Client on iSeries cannot migrate to WebSphere Commerce Version
  8.
  
  RECOMMENDATION:
  

Problem conclusion

• Added sections to 2 XML files to enable successful migration on
  iSeries platforms.
  

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

• R800 PSY

     UP