You can test a database to check for inconsistencies on
both global and workspace levels.
Before you begin
- You must be a Global administrator to verify the database. To
run the verifier at workspace level, you must be added to the workspace.
- When you run tests, the performance of the product might be slow.
Run tests when few users are logged in.
- You must take a backup of the database before running the SQL
queries.
Procedure
- To test at the workspace level, open the workspace. To
test at the global level, go to step 2.
- Click . The name, description,
last run date, and status of the test are displayed.
- 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.
- Click the link to the SQL.txt file. The query is displayed.
- Copy the query.
- Click .
- 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.
- Click , and run the test again. The problem is resolved.