error during upgrade of CRM 5.0

[Former Member]

Hello,

Following are two errors I encountered during an upgrade of CRM 5.0 to 7.0 in EU_IMPORT phase. Any ideas on these objects USR01_{0 and USR02}0 as to if they should they be deleted from existing DB?

###################################

(DB) INFO: USR01~ created

(DB) ERROR: DDL statement failed

(ALTER TABLE [USR01_{] ADD CONSTRAINT [USR01}0] PRIMARY KEY CLUSTERED ( [MANDT], [BNAME] ) )

DbSlExecute: rc = 102

(SQL error 2714)

error message returned by DbSl:

There is already an object named 'USR01~0' in the database.

Could not create constraint. See previous errors.

(IMP) INFO: import of USR01~ completed (9 rows) #20090408033510

###################################

(DB) INFO: USR01~001 created

(DB) INFO: USR01~002 created

(DB) INFO: USR01~003 created

(DB) INFO: USR02~ created

(DB) ERROR: DDL statement failed

(ALTER TABLE [USR02_{] ADD CONSTRAINT [USR02}0] PRIMARY KEY CLUSTERED ( [MANDT], [BNAME] ) )

DbSlExecute: rc = 102

(SQL error 2714)

error message returned by DbSl:

There is already an object named 'USR02~0' in the database.

Could not create constraint. See previous errors.

(IMP) INFO: import of USR02~ completed (9 rows) #20090408033510

###################################

Thank a lot for your help,

One Idea

[Former Member]

Closing the thread now...the error occurred because of name change in two of the tables earlier and were never deleted from the system. They were having these objects in them and created this conflict.