JR40366: CMVC 212194 - RESOLVE MIGRATE PROMOTIONS UTILITY FAILURE ON SPECIAL CHARACTERS.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.5 Fix Pack
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• The promotion migration utility (Ant task) fails when promotion
  names or the categories or catalog entries they reference
  contain special characters:
  
  [RunMigrationForToolkit] DEBUG:
  com.ibm.commerce.promotion.migration.ant.task.PromotionMigration
  App METHOD
  getOrgEntityId: Enter
  [RunMigrationForToolkit] DEBUG:
  com.ibm.commerce.promotion.migration.ant.task.PromotionMigration
  App METHOD
  getOrgEntityId: SELECT ORGENTITY_ID FROM ORGENTITY WHERE
  DN='ou=extended
  sites seller organizationtopshop,o=extended sites seller
  organization,o=root organization'
  [RunMigrationForToolkit] DEBUG:
  com.ibm.commerce.promotion.migration.ant.task.PromotionMigration
  App METHOD
  getOrgEntityId: Exit with org entity ID=7000000000000002556
  [RunMigrationForToolkit] DEBUG:
  com.ibm.commerce.promotion.migration.ant.task.PromotionMigration
  App METHOD
  getCategoryId: SELECT CATGROUP_ID FROM CATGROUP WHERE
  MEMBER_ID=7000000000000002556 AND IDENTIFIER='??4 PROMO'
  [RunMigrationForToolkit] DEBUG:
  com.ibm.commerce.promotion.migration.ant.task.PromotionMigration
  App METHOD
  getCategoryId: com.ibm.db2.jcc.am.SqlException:
  [jcc][t4][10120][10898][4.11.88] Invalid operation: result set
  is closed.
  ERRORCODE=-4470, SQLSTATE=null
    [antcall] Exiting
  E:\IBM\WCDE_E~1\migration\optional\components
  \component-services\subcomponents\promotion\config\PromotionsMig
  ration.xml.
  
  BUILD FAILED
  E:\IBM\WCDE_E~1\migration\optional\components\component-services
  \subcomponents\promotion\config\PromotionsMigration.xml:32: The
  following
  error occurred while executing this line:
  E:\IBM\WCDE_E~1\migration\optional\components\component-services
  \subcomponents\promotion\config\PromotionsMigration.xml:59: The
  migration
  utility failed to read the CATGROUP table for Name "??4 PROMO"
  for the
  promotion with the PROMOTION ID 10190623. Check whether the
  value of Name
  is valid. For additional information about the error conditions,
  run the
  migration utility in debug mode.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7 who are migrating promotions that
  contain special characters in the names of the promotions or the
  targeted categories or catalog entries.
  
  PROBLEM ABSTRACT:
  The promotion migration utility fails when migrating promotions
  which contain special characters in their names.
  
  BUSINESS IMPACT:
  The promotion migration utility fails and promotions can not be
  migrated.
  
  RECOMMENDATION
  

Problem conclusion

• The utility was updated to read special characters using UTF-8
  encoding.
  
  -------------------------------------------------------------
  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