on 09-29-2011 1:35 PM
Dear Experts,
SAP System Copy failed due to ABAP Import error "ORA-01408:such column list already indexed " on SAPDFACT' package.
SAP Package : ECC 6/ ERP
OS : Windows 2003 64 bit R2
DB: Oracle 10g
HW : VmWare
Please find the below details I collected from my system and requesting your assistance.
************************************************************************************************************************************************
Error from SAPDFACT.log is below.
-
DbSl Trace: ORA-1408 occurred when executing SQL statement (parse error offset=57)
(DB) ERROR: DDL statement failed
(CREATE INDEX "/BI0/E0FIGL_C01~P" ON "/BI0/E0FIGL_C01" ( "KEY_0FIGL_C01P" ,
"KEY_0FIGL_C01T" , "KEY_0FIGL_C01U" , "KEY_0FIGL_C011" , "KEY_0FIGL_C012" , "KEY_0FIGL_C013"
) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 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
************************************************************************************************************************************************
SAPDFACT.TSK Status
-
T /BI0/E0FIGL_C01 C ok
D /BI0/E0FIGL_C01 I ok
P /BI0/E0FIGL_C01~0 C ok
I /BI0/E0FIGL_C01~01 C ok
I /BI0/E0FIGL_C01~02 C ok
I /BI0/E0FIGL_C01~03 C ok
I /BI0/E0FIGL_C01~04 C ok
I /BI0/E0FIGL_C01~05 C ok
I /BI0/E0FIGL_C01~06 C ok
I /BI0/E0FIGL_C01~P C err
T /BI0/F0FIGL_C01 C xeq
D /BI0/F0FIGL_C01 I xeq
P /BI0/F0FIGL_C01~0 C xeq
I /BI0/F0FIGL_C01~01 C xeq
I /BI0/F0FIGL_C01~02 C xeq
I /BI0/F0FIGL_C01~03 C xeq
I /BI0/F0FIGL_C01~04 C xeq
I /BI0/F0FIGL_C01~05 C xeq
I /BI0/F0FIGL_C01~06 C xeq
************************************************************************************************************************************************
/BI0/E0FIGL_C01 INDEX
-
SQL> connect sapsr3 /as sysdba
Enter password:
Connected.
SQL> select index_name from dba_indexes where index_name like '/BI0/E0FIGL_C01%'
;
INDEX_NAME
-
/BI0/E0FIGL_C01~0
/BI0/E0FIGL_C01~01
/BI0/E0FIGL_C01~02
/BI0/E0FIGL_C01~03
/BI0/E0FIGL_C01~04
/BI0/E0FIGL_C01~05
/BI0/E0FIGL_C01~06
7 rows selected.
SQL>
***************************************************************************************************************************************************
Thanks and Regards,
Jebin Sebastian
Did you execute SMIGR_CREATE_DDL before you started the export?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Well this might be a mistake as well, you should have run that report.
SMIGR_CREATE_DDL report should be run just before executing the 'EXPORT procedure via SAPinst. Then, the files generated are to be placed in sapinst_instdir I think.
Just try to refer the system copy guide once more for the EXPORT/IMPORT procedure.
Thanks
Hello,
After execution of SMIGR_CREATE_DDL report, please confirm if some .sql files are created at OS directory (directory mentioned while execution of report). If files are created then it is confirmed that your current IMPORT problem is due to non-execution of this report.
If it doesn't create any files now, then probably the current problem is not w.r.t this report.
However just a thought, there might be some changes in the source system after the previous export execution and current behaviour can't be confirmed exactly. In that case, better to re-run the export, if you have time.
Thanks
Hi,
Because I stumbled over the same error years ago, I found a SAP Note that explains the error.
885441 - Common Migration Errors
My ERP system doesn't created a SQL file, so I had to set the "err" to "ign" and start the report after the import, that generates all indexes again.
Report: "SAP_INFOCUBE_INDEXES_REPAIR"
Maybe that helps someone to find the solution faster.
BR
Tobias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You might need to apply some notes in order to have SMIGR_CREATE_DDL working :
1416108 - Error in consistency check of tables (transaction SE14)
1417127 - SMIGR_CREATE_DDL: Performance optimization for Oracle
1101045 - Oracle: Optimization of homogeneous migration (1)
1049955 - Oracle homogene migration: SMIGR_CREATE_DDL generates dump
1516813 - Primary index not LOCAL for partitioned table
1324665 - SMIGR_CREATE_DDL: save list of generated .SQL files
When I last used that report on a 7.0 SP18 the last note 1324665 was requiered in order to have SMIGR_CREATE_DDL creating some outputs.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jebin,
As per the logs index creation for "/BI0/E0FIGL_C01~P" has errors.
You are trying to delete some other index as per the thread.
Can you try deleting this index /BI0/E0FIGL_C01P . after successful deletion change the status of line item /BI0/E0FIGL_C01P to xeq from err in .TSK file.
repeat the import process .
Hope this helps.
Regards,
Deepak Kori
> SQL> connect sapsr3 /as sysdba
> Enter password:
> Connected.
> SQL> select index_name from dba_indexes where index_name like '/BI0/E0FIGL_C01%'
> ;
>
> INDEX_NAME
> -
> /BI0/E0FIGL_C01~0
> /BI0/E0FIGL_C01~01
> /BI0/E0FIGL_C01~02
> /BI0/E0FIGL_C01~03
> /BI0/E0FIGL_C01~04
> /BI0/E0FIGL_C01~05
> /BI0/E0FIGL_C01~06
>
> 7 rows selected.
>
> SQL>
>
> ***************************************************************************************************************************************************
>
> Thanks and Regards,
> Jebin Sebastian
Hello,
I got to see the similar issue in this thread, please check the suggestion by Eric -
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have checked it earlier.
I tried to drop the index, but I got the below error.So I posted a new Thread . Moreover i got confused with his question "this is a BW system" and doubted the applicability in my case.
**********************************************************************************************************************************************************
SQL> connect sapsr3 /as sysdba
Enter password:
Connected.
SQL> select index_name from dba_indexes where index_name like '/BI0/E0FIGL_C01%'
;
INDEX_NAME
-
/BI0/E0FIGL_C01~0
/BI0/E0FIGL_C01~01
/BI0/E0FIGL_C01~02
/BI0/E0FIGL_C01~03
/BI0/E0FIGL_C01~04
/BI0/E0FIGL_C01~05
/BI0/E0FIGL_C01~06
7 rows selected.
SQL> drop index '/BI0/E0FIGL_C01~0';
drop index '/BI0/E0FIGL_C01~0'
*
ERROR at line 1:
ORA-00953: missing or invalid index name
SQL>
**********************************************************************************************************************************************************
Please let me know how to proceed.
> SQL> drop index '/BI0/E0FIGL_C01~0';
> drop index '/BI0/E0FIGL_C01~0'
> *
> ERROR at line 1:
> ORA-00953: missing or invalid index name
>
> SQL>
> **********************************************************************************************************************************************************
> Please let me know how to proceed.
Hello,
Not sure if it will help but what if try the command with double quotes ?
drop index ''/BI0/E0FIGL_C01~0'';
Thanks
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.