How do I Reset MMDB Metadata?

Sometimes it makes sense to clear all the metadata saved by MetaMiner and to pull it again from scratch.

In such cases, you need to remove all content from your MetaMiner Database.

Danger

To avoid data loss and MMTE Server crashes, do not follow this procedure unless advised by Infolytik Technical Support.

The easiest and fully automatic way to reset MMDB metadata:

  1. Open MMTE Administrator.
  2. Open Advanced Settings, section MetaMiner Database.
  3. Set the Drop Tableau schema on next MM Server restart checkbox.
  4. Restart MMTE Server.
  5. Reconnect the Tableau environments.
  6. Wait for MMTE to complete the initial pull.
  7. Make sure the Drop Tableau schema on next MM Server restart checkbox is unset.

In some situations you may need to reset the metadata manually.

To reset your MMDB metadata manually, follow these steps:

  1. Stop MMTE Server.
  2. Open MMDB in your favourite PostgreSQL client software for direct editing.
  3. If you need to clear all stored statistics, truncate all tables in the metrics schema.
  4. If you need to clear all pull history data, truncate all tables in the mms schema.
  5. If you need to clear all the SAP BO environment metadata and custom MMDB tables, truncate all tables in the public schema.
  6. If you need to clear all the Tableau environment metadata, truncate all tables in the tableau schema.
  7. Start MMTE Server.
  8. Reconnect the Tableau environments.
  9. Wait for MMTE to complete the initial pull.

All of your old business intelligence metadata is now re-created.

See Also

TRUNCATE in SQL

Back to top