JR42698: CMVC 222009 - ADDRESS THE SQL ERROR RECIEVED WHEN MIGRATING GIFT CENTER.

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
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• The GRADDR table has two new columns in V7 SEARCHKEYFIRSTNAME
  and SEARCHKEYLASTNAME. These columns help in searching the
  registry based on first and last names. By default, these
  columns would be populated with the SOUNDEX values of FIRSTNAME
  and LASTNAME columns during registry creation and update.
  
  For a migrating user, this task helps to populate these two
  columns with the SOUNDEX values of FIRSTNAME and LASTNAME for
  all existing registries in the database.
  
  So, it makes a read of the GRADDR table, iterates over the
  result and calls an update for those rows where the search key
  column can be populated.
  
  The problem with the task was that it was not closing the result
  set and the select and update queries opened. As a result the
  following SQL error was observed:
  
  SQL.com.ibm.db2.jcc.am.SqlException: DB2 SQL Error:
  SQLCODE=-805, SQLSTATE=51002,
  

Local fix

Problem summary

• USERS AFFECTED:
  Users who migrate gift center from V6 to V7 and execute the
  migration script
  
  PROBLEM ABSTRACT:
  Migration script of gift center fails with an SQL error due to
  an unclosed result set.
  
  BUSINESS IMPACT:
  Users are unable to complete the gift center migration
  
  RECOMMENDATION:
  

Problem conclusion

• Closed the result set and the connection gracefully.
  -------------------------------------------------------------
  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