BW migration error

[Former Member]

Hi,

During BW/oracle heterogeneous migration from Solaris to Linux, the database import on target server fails. The SAPDFACT load is the one failing.

The first errors I got were during creation of ~P compund indexes. I followd note 885441 and changed the SAPDFACT.TSK file for the ~P entries to ign and it worked.

Now, I got the error for a primary index and the same note says to create the index

Did any of you guys had such problem and what did you do in thsi case?:

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "/BIC/FZCBFIGL01~0" ON "/BIC/FZCBFIGL01" ( "KEY_ZCBFIGL01P", "KEY_ZCBFIGL01T", "KEY_ZCBF

IGL01U", "KEY_ZCBFIGL011", "KEY_ZCBFIGL012", "KEY_ZCBFIGL013" ) TABLESPACE PSAPWIA STORAGE (INITIAL 65536 NEXT

0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1452)

error message returned by DbSl:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

(DB) INFO: disconnected from DB

/sapmnt/WIA/exe/R3load: job finished with 1 error(s)

/sapmnt/WIA/exe/R3load: END OF LOG: 20070605234504

[Former Member]

Hi,

try to check your trace files and check if you have any error like

'ora-01499: table/index cross reference failure -

Please, check the note 765613 and follow the instrictions.

regards

Paulo Lidon

Lidon Technologies - IS Consulting

[Former Member]

Hi,

This means your source database has a problem or corruption in one t able or in one group of tables.

You must try to contact your functional team to analyse this problem and check In the impact of trying to drop and recreate index.

In SAP software you must not delete primary indexes because you loose all the

package consistency.

I think you must open a message at SAP Support in order to try to solve your problem.

Paulo Brandão

Lidon Trechnologies

[Former Member]

Hi cyrus brocha

I have same error.

Have you gotten any answer?