Forum Discussion

Ratt_507's avatar
Ratt_507
Level 4
7 years ago

Error message on Enterprise Vault 11 - Deleted items waiting to be deleted from indexes

While starting Re-run all checks getting below error message for one of vault store:- Deleted items waiting to be deleted from indexes There are 999689 items that have been deleted from Vault Store "Store01" but have not yet been deleted from the indexes.
  • GertjanA's avatar
    GertjanA
    Moderator
    7 years ago

    Hello,

    There can be several reasons for this. One of them might be that you are not running the maintenance plans on the EV databases. See https://www.veritas.com/support/en_US/article.100022023.html for how to. Check with your DBA on this.

    To check the amount of deleted items, see https://www.veritas.com/support/en_US/article.100039333.html

    This has a query you can run against the vault store. If you run it once every two hours, the count should go down.

    It might also be that there is an issue on the index server(s), check EV eventlog for obvious alerts (failed to remove etc.)

    As you are on EV11, try to go to 11.0.1 CHF5, which is the latest 11 version. If possible, then upgrade to 12.3, so you get the latest possible version.

    • Ratt_507's avatar
      Ratt_507
      Level 4
      7 years ago
      Hi, Maintenance plans on the EV databases - All Indexes are in recommended limits and maintenance plan schedule run on DB server. EV event log for obvious alerts - No such relevant alerts found on the server. We are on 11.0.1 CHF4 and no such plan for up-gradation. Getting Below error while running sql query on respective vault store Msg 207, Level 16, State 1, Line 2 Invalid column name 'IndexCommited'.
      • ChrisLangevin's avatar
        ChrisLangevin
        Level 6
        7 years ago

        The column in JournalDelete is called "IndexCommitted" with two ts. Change the spelling and the query should work. I'll update the article when I get a moment.

        --Chris