Index does not exist in database system MaxDB

[Former Member]

Hi!

Could some one tell me what can I do with this error message.

This message is in Prod, it doesn't happen in Qas and Test environment. The Database and sap was down and up again.

The Index was active in prod. again.

I really need help.

Thanks in advance

[Former Member]

Hi!

Yes MaxDB is in Sap.

It was corrected with the transaction SE11, with the menu option Utilities / Database Utility, this option shows the index to create, and that's all.

Thanks

[former_member229109]

Dear Mr. Rodriguez,

You wrote that the problem occurred on the PROD system.

Are you SAP customer?

If you are SAP customer plese see the SAP notes::

928037 FAQ: MaxDB Indexes

940420 FAQ: Database structure check (VERIFY)

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

896023 Incorrect CREATE INDEX statement in DFACT.SQL

767598 Available documentation

If you are SAP customer, please create the ticket on queue BC-DB-SDB for

your issue.

Please review the Rules of Engagement at

Please provide more information to get clear on your problem:

-> What is the database version?

< dbmcli -d <SID> -u control,<control> show version >

-> What were the errors in the knldiag* files?

-> If you restarted the database ones, it will be helpful to

review the knldiag.old file for additional information.

-> Please run Database structure check & review the results.

Thanks you and best regards, Natalia Khlopina