Direct links to fixes
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 number
JR42698
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-03
Closed date
2012-06-28
Last modified date
2012-06-28
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 June 2012