cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01408:such column list already indexed error 'SAPDFACT' import package

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor

Did you execute SMIGR_CREATE_DDL before you started the export?

Markus

Former Member
0 Kudos

Did you execute SMIGR_CREATE_DDL before you started the export?

Markus

-


Hi Markus,

I did not execute the command, also when should I do it during export ?

Thanks and Regards,

Jebin Sebastian

Former Member
0 Kudos

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

Former Member
0 Kudos

I'll execute the SMIGR_CREATE_DDL and do the export. Let you know the result soon.

Former Member
0 Kudos

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

Answers (3)

Answers (3)

tobias_ptz
Participant
0 Kudos

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

ACE-SAP
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Dear All,

Sorry for the delay in reply.

I tried SMIGR_CREATE_DDL, but it gave timeout error. Any have it is my DEV and I got an option of doing P2V for VMware. Let me try that.

Later I'll try to resolve this issue.

Thank you for all who replied.

Regards,

Jebin Sebastian

Former Member
0 Kudos

Hello,

You could give a try to execute it in background, or by increasing the parameter value for rdisp/wp_max_runtime - parameter is dynamic.

Thanks

former_member188883
Active Contributor
0 Kudos

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

Former Member
0 Kudos

> 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

Former Member
0 Kudos

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.

Former Member
0 Kudos

> 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

Former Member
0 Kudos

I tried the command drop index "/BI0/E0FIGL_C01~0"; but, no luck .