on 10-14-2008 4:44 AM
Dear Experts,
We have missing index problem in one of our custom table (ZFBID). We tried to re-create through SE14 but it was failed, the index is still missing.
Prior to the missing index, ZFBID structure was changed and transported to QA and PRD, however it caused problem when doing in PRD, we have to restore it by recovering through db2 level, and now the primary index is missing.
How to re-create the index? Please give me the detail steps if using db2 level command.
Thank you in advance,
Rudi
To provide help, I should know the error message received when the index is attempted to be created. There should be an SQL error reported. Look into the SYSLOG (transaction SM21) to see the error message. The SYSLOG should show you which work process received the error. If the SAP dev-Trace from that time is still available, it will contain the detailed error as well.
Malte
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rudi,
I have simillar problem. However - my solution was:
This was only solution which worked for me.
Hope it will be useful for somebody.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.