topic Missing index problem in Application Development and Automation Discussions

Missing index problem

Former Member — Tue, 11 Dec 2007 17:42:23 GMT

Hi Gurus!

I have a critical problem to solve.

I have a table without data which is inconsistent because it doesn't have the primary index. When i see missing indexes at DB02, the system tells me that the index is created, but when i go to SE14 and select the primary index, it says the index does not exists on the database and the only option that is active is the one to create the index. If I try to create the index, i get an error saying: there is already a an object named 'zmed_distr~0' ( my index name ).

Can anybody help me?

Thank you in advance.

Re: Missing index problem

Former Member — Tue, 11 Dec 2007 17:55:48 GMT

Go to SE14 and press the 'indexes' button. Select your index and then press the 'create database index' button.

rob

Re: Missing index problem

Former Member — Tue, 11 Dec 2007 18:56:48 GMT

I Rob.

Thanks for your answer.

I have already done that. The problem is that i get an error saying there is already an object created withe that name. the two buttons "Adjust and activate" and "Delete index" are deactivated. The index appears to be created at DB02. It seems the index is created on DB but not in ABAP DICTIONARY.

Re: Missing index problem

Former Member — Tue, 11 Dec 2007 19:00:12 GMT

OK - exactly what did you do when trying what I suggested?

Rob

Re: Missing index problem

Former Member — Tue, 11 Dec 2007 19:05:58 GMT

the tsystem does'nt create the index and give me this log:

Request: Create Index ZMED_DISTR-0 (FORM05/11.12.07/19:06)

Process: BLADE04_0

sql:

ALTER TABLE [ZMED_DISTR]

ADD CONSTRAINT [ZMED_DISTR~0]

PRIMARY KEY CLUSTERED

( [MANDT] ,

[ZUONR] ,

[GJAHR] ,

[KUNNR] ,

[ESTAB] ,

[TXT20] ,

[REPS] )

There is already an object named 'ZMED_DISTR~0' in the database.Could

not create constraint. See previous errors.

DDL time(___1): .........3 milliseconds

The SQL statement was not executed

Index could not be created completely in the database

Index ZMED_DISTR-0 could not be created

Request for ZMED_DISTR could not be executed