on 03-11-2010 4:10 PM
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....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
73 | |
11 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.