Fixing Database Corruption

  To fix a corrupt database:

  1. Clear the database.

  2. Reload from backups.

  3. Recalculate the data.

  4. Issue the VALIDATE command in ESSCMD.

  If the database is still corrupt:

  1. Stop Essbase Server.

  2. Delete these files:

    • ARBORPATH/app/appName/databaseName/databaseName.esm

    • ARBORPATH/app/appName/databaseName/databaseName.ind

    • ARBORPATH/app/appName/databaseName/databaseName.tct

    • ARBORPATH/app/appName/databaseName/essXXXXX.ind

    • ARBORPATH/app/appName/databaseName/essXXXXX.pag

  3. If any of these temporary files are present, delete them:

    • ARBORPATH/app/appName/databaseName/databaseName.esn

    • ARBORPATH/app/appName/databaseName/databaseName.inn

    • ARBORPATH/app/appName/databaseName/databaseName.otm

    • ARBORPATH/app/appName/databaseName/databaseName.otn

    • ARBORPATH/app/appName/databaseName/databaseName.tcu

    • ARBORPATH/app/appName/databaseName/essXXXXX.inn

    • ARBORPATH/app/appName/databaseName/essXXXXX.pan

    • ARBORPATH/app/appName/databaseName/essXXXXX.tmp

  4. Create a new application and database.

  5. Reload from backups.

  6. Recalculate the new database.

  7. Restart Essbase Server.