(SQL error -955) CREATE INDEX POS(1) Duplicate name

[Former Member]

Dear All,

we are installing SAP with system copy import using export of DEV (EHP4). at the end of IMPORT ABAP step it is generating error

and then retry but error is same

(

DB) ERROR: DDL statement failed
 (DROP INDEX "DD01L~1" ON "DD01L")
 DbSlExecute: rc = 103
  (SQL error -4011)
  error message returned by DbSl:
POS(13) Unknown index name:DD01L~1
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD01L~1 created#20110517154519
 
ERROR : Execute for create index STERM_LINK~001 on STERM_LINK failed (dbrc=102).
  (SQL error -955)
  error message returned by DbSl:
SQL-Statement: CREATE  INDEX "STERM_LINK~001" ON "STERM_LINK" ( "OBJECT"  )  
POS(1) Duplicate name
 
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20110517154519

we have did this

sqlcli PRD=> DROP INDEX "STERM_LINK~001" ON "STERM_LINK"
0 rows affected (12.804 msec)

and then retry again but error is same.

please guide we stuck.

Best Regrads

Khan

[Former Member]

hi all,

we have done the following steps:

1) sqlcli PRD=> DROP INDEX "STERM_LINK~001" ON "STERM_LINK"

0 rows affected (12.804 msec).

2) restart OS.

3) start sapinst with old option

now installation is at approx. near to end

Best Regards

Imran

[jorge_velasquez]

Hi,

I have the same issue, but before delete the indexes as you did... I want to know if after system copy was sucessfully installed it gives you any other error like missing data.

Regards

[Former Member]

hi all,

please give us hint , how we resolve that issue

[former_member229109]

Hello,

Hints:

1. Check "Special Database Platform MAXDB" section of the SAP note 888210.

2. What is the MAXDB version?

It will be helpful to check the migration logs and the entries in the database tables.

3. Create SAP message and get SAP support.

Regards, Natalia Khlopina