Running the database verifier

You can test a database to check for inconsistencies on both global and workspace levels.

Before you begin

Procedure

  1. To test at the workspace level, open the workspace. To test at the global level, go to step 2.
  2. Click Advanced > Verify Database. The name, description, last run date, and status of the test are displayed.
  3. Click the link to run the test. The result of the test is displayed in the Status field. the details of the issue and a link to a .txt file are displayed. The .txt file contains one or several SQL queries separated with a ; and a newline.
  4. Click the link to the SQL.txt file. The query is displayed.
  5. Copy the query.
  6. Click Advanced > SQL.
  7. Paste the query and click Execute to run the query.
    Note: The cache has to be cleared after running the SQL query for few tests.
  8. Click Advanced > Verify Database, and run the test again. The problem is resolved.

Feedback