6320ch_migrating.fm Draft Document for Review July 28, 2004 7:33 pm
212 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
[2004.04.29 21:08:36] Error: [IBM][CLI Driver][ DB2/NT] SQL0605W The index was not created
because the index "DBUSR01.I0000433" already ex ists with the required description.
SQLSTATE=01550
.
.
.
[2004.04.29 21:09:35] Info : CREATE INDEX I0000 539 ON contract ( member_id ASC )
[2004.04.29 21:09:35] Error: [IBM][CLI Driver][ DB2/NT] SQL0601N The name of the object to be
created is identical to the existing name "DBUSR01.I0000539" of typ e "INDEX". SQLSTATE=42710
.
.
.
[2004.04.29 21:53:37] Info : SELECT MAX(trdrefa mt_id) as maxId FROM trdrefamt
[2004.04.29 21:53:37] Info : SELECT * FROM keys WHERE KEYS_ID=-1214
[2004.04.29 21:53:37] Info : Executed command: update.wcs.bo otstrap.keys
[2004.04.29 21:53:37] Event: Post migration ends.
[2004.04.29 21:53:37] Event: Migration has term inated successfully.
When we checked the log file after running the migration script we found
numerous errors split up in 2 SQL codes ‘SQL0605W’ and ‘SQL0601N’.
Error SQL0605WA sample of this error in the log:
[2004.04.29 21:08:36] Info : CREATE INDEX I0000433 ON accmbrgrp ( own er_id
ASC )
[2004.04.29 21:08:36] Error: [IBM][CLI Driver][DB2/NT] SQL 0605W The index
was not created because the index "DBUSR01.I000 0433" already exists with
the required description. SQLSTATE=01550
This SQL code can be ignored as its more a info message than error. The
description of the SQL code clearly tells us that the index already exists with the
required criteria and thus can be ignored.
Error SQL0601NA sample of this error in the log:
[2004.04.29 21:09:35] Info : CREATE INDEX I0000539 ON contract ( memb er_id
ASC )
[2004.04.29 21:09:35] Error: [IBM][CLI Driver][DB2/NT] SQL 0601N The name
of the object to be created is identical to the existing name
"DBUSR01.I0000539" of type "INDEX". SQLSTATE=4 2710
This error can have one of the following meanings:
The index is missing (regardless of the message saying that it alread y exists).
To correct this the index has to be created manually: