error when recreate secondary indexes

[Former Member]

hi all

in db02 i have two missing secondary indexes.

when i try recreate :

in db02 select missing index -> choose processing type: direct processing -> create

i have error :

Internal error 1 in module DD_LONGNPROT_NAME_GET occurred

Diagnosis

An unexpected SQL error occurred in the ABAP/4 Dictionary interface.

System response

A system log entry has been written. This gives more precise information about where the termination occurred and the reason for the termination. The current transaction has been cancelled.

Procedure

Please check the system log and eliminate the cause of the SQL error.

in sm21 no errors

in db alert log no errors

how can resolve this problem?

thanks

[Former Member]

hi all

in db02 i have two missing secondary indexes.

when i try recreate :

in db02 select missing index -> choose processing type: direct processing -> create

i have error :

Internal error 1 in module DD_LONGNPROT_NAME_GET occurred

Diagnosis

An unexpected SQL error occurred in the ABAP/4 Dictionary interface.

System response

A system log entry has been written. This gives more precise information about where the termination occurred and the reason for the termination. The current transaction has been cancelled.

Procedure

Please check the system log and eliminate the cause of the SQL error.

in sm21 no errors

in db alert log no errors

how can resolve this problem?

thanks

[yuri_ziryukin]

Hello Andrey,

I did not find any messages or notes with this error. I think you can create an SAP message under component BC-DB-DBI and report your problem there.

SAP support should be able to help you.

Yuri

[Former Member]

Hi Andrey,

Please try to active the secondary indexes in transaction SE14. Please gothrough the note 1248769 as how to active the

indexes.

Many thanks.

Mohammed Hussain.

[Former Member]

thanks for your answers

Thanks Mohammed

i try to active the secondary indexes in transaction SE14

[Former Member]

i activate secondary indexes . In db02 missing 0 but this indexes now in "Unknown indexes in ABAP Dictionary"