2 Replies Latest reply: Feb 9, 2007 7:56 PM by Gilda Rodriguez RSS

Index does not exist in database system MaxDB

Gilda Rodriguez
Currently Being Moderated

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

  • Re: Index does not exist in database system MaxDB
    Natalia Khlopina
    Currently Being Moderated

    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

    Welcome and Rules of Engagement

     

    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

  • Re: Index does not exist in database system MaxDB
    Gilda Rodriguez
    Currently Being Moderated

    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

Actions

Incoming Links