BW 7.0: several ORA-01408 during import

[ganimede_dignan]

Hi,

I'm copying my BW system with export/import procedure from prd to dev. During import, and I think only on fact-tables, there are several ORA-01408 such as:

DbSl Trace: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BIC/EAV_FAORDT~P" ON "/BIC/EAV_FAORDT" ( "KEY_AV_FAORDTP" , "KEY_AV_FAORDTT" , "KEY_AV_FAORDTU" , "KEY_AV_FAORDT1" , "KEY_AV_FAORDT2" , "KEY_AV_FAORDT3" , "KEY_AV_FAORDT4" , "KEY_AV_FAORDT5" , "KEY_AV_FAORDT6" , "KEY_AV_FAORDT7" , "KEY_AV_FAORDT8" ) TABLESPACE PSAPNBDFACT STORAGE (INITIAL 188743680 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

Note 885441 describe to igonere this indexes error... is it ok for me?

Source system has got:

SAP_ABA 700 0018 SAPKA70018

SAP_BASIS 700 0018 SAPKB70018

PI_BASIS 2006_1_700 0008 SAPKIPYM08

ST-PI 2008_1_700 0000 -

SAP_BW 700 0020 SAPKW70020

FINBASIS 600 0015 SAPK-60015INFINBASIS

SEM-BW 600 0015 SAPKGS6015

BI_CONT 703 0012 SAPKIBIIQ2

ST-A/PI 01L_BCO700 0000 -

So... it should enough updated to exclude note 925309.

Regards.

Thankyou....

[Former Member · Accepted solution]

Hi Ganimede,

Yes you can ignore these this index error. This is a common error which is encountered during most of the import of BW/BI systems which can be ignored.

Regards

Sourabh Majumdar

[stefan_koehler]

Hello,

just to be sure - did you run the SMIGR_CREATE_DDL report and include the generated files into your system copy?

Sapnote #1324665 includes such checks.

Regards

Stefan

[ganimede_dignan]

Also several ORA-01452... have you got any idea?

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "/BIC/FACC_PCO1~0" ON "/BIC/FACC_PCO1" ( "KEY_ACC_PCO1P", "KEY_ACC_PCO1T", "KEY_ACC_PCO1U", "KEY_ACC_PCO11", "KEY_ACC_PCO12", "KEY_ACC_PCO13", "KEY_ACC_PCO17" ) TABLESPACE PSAPNBDFACT 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

[ganimede_dignan]

Sure.

Regards.

[ganimede_dignan]

.