JR53484: Migrating Database from v6 to v7 environment results in PX_ELEMENT table error.

APAR status

• Closed as program error.

Error description

• The migration utility might fail due to a large number of
  database connections and improper closing of result sets and
  prepared statements.
  
  Errors similar to the following might appear in the migration
  log:
  
  ERROR:  [migrateOrderLevelFreeGiftPromotions] The migration
  utility failed to read the PX_ELEMENT table due to a database
  error.
  
  ERROR:  BUILD FAILED
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:32:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:45:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/db.xml:5: The
  following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/db.xml:9: The
  following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:56:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:60:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/features/promo
  tions/db/60/build.xml:27: com.ibm.db2.jcc.am.SqlException: DB2
  SQL Error: SQLCODE=-805, SQLSTATE=51002,
  SQLERRMC=NULLID.SYSLH21E 0X5359534C564C3031, DRIVER=4.15.100
  
  
  ====== OR
  
  ERROR:  [migrateOrderLevelFreeGiftPromotions] The migration
  utility failed to read the PX_ELEMENT table due to a database
  error.
  
  ERROR:  BUILD FAILED
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:32:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:45:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/db.xml:5: The
  following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/db.xml:9: The
  following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:56:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/build.xml:60:
  The following error occurred while executing this line:
  
  ERROR:
  /opt/IBM/WebSphere/CommerceServer70/migration/xml/features/promo
  tions/db/60/build.xml:27:
  com.ibm.db2.jcc.am.SqlNonTransientConnectionException:
  [jcc][t4][10335][10366][4.15.100] Invalid operation: Connection
  is closed. ERRORCODE=-4470, SQLSTATE=08003
  

Local fix

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce users migrating from V6 to V7 who have a
  large number of promotions.
  
  PROBLEM ABSTRACT:
  Migrating Database from v6 to v7 environment results in
  PX_ELEMENT table error.
  
  BUSINESS IMPACT:
  Order level free gift promotions will not be migrated
  successfully.
  
  RECOMMENDATION:
  

Problem conclusion

• The promotion OrderLevelFreeGift migration tool was updated to
  optimize the use of database resources including prepared
  statements, resultsets and connections.
  

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