Feature Pack 5 or later

Enabling interim fix JR54402

Interim fix JR54402 resolves unique index violations when you use the Data Load utility to reload searchable attribute values.

If you completed the procedures in any of the following topics, then you need to complete additional steps to avoid primary key collisions:

Before you begin

Install the interim fix for JR54402.

Procedure

  1. Connect to your database.
  2. Update the KEYS table by running the following SQL command.
    update keys set counter = case when (select max(srchattr_id) from srchattr) > counter then (select max(srchattr_id) from srchattr) else counter end where tablename = 'srchattr'
  3. Restart the WebSphere Commerce server.