Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for Process Engine Administration
  Search  |  Index
Process Reference  
Process Engine Administration
Workflow administration tasks
System administration tasks
  Configuring the Process Engine
  Configuring users and groups (Workplace)
  Configuring users and groups (Open Client/FileNet Web Services Client)
  Configuring optional features
  Running the Process Engine
  Improving system performance
  Troubleshooting
    What to do when something goes wrong
    Listing the timestamps for your software
    Verifying the workflow database
    Running vwverify
   

Verifying the workflow database

The Process Engine provides the vwverify utility to verify the workflow database. Using vwverify, you can:

  • Scan the database for inconsistencies in queues and rosters.
  • Repair inconsistencies in the database by adding, deleting, or updating records as appropriate.
  • Count the number of queues and rosters in the database.

Run the vwverify utility if there is reason to believe that some parts of a workflow database might be out of sync with others. For example, if a database restore is performed on a subset of the databases in a multi-server environment, the restored databases might be missing some of the database transactions that have been saved on the other databases.

In order to function correctly, the vwverify utility must be able to read all workflow definitions and configuration in the workflow database. The logon under which vwverify runs must have read-all capability, normally associated with the Process Engine administrators group (PEAdministrators by default for Workplace and SysAdminG for FileNet Web Services Client or Open Client).

NOTE The vwverify program is designed to locate and repair problems caused by inconsistent versions of the workflow database. It is not designed to find and fix software bugs which corrupt the database, or catch misuse of low-level database tools such as Oracle SQL*Plus or Microsoft SQL server isql.

The vwverify utility verifies workspace references in queue entries for accuracy. Each queue and each workflow roster is scanned for references to work items. The resulting list of work item references is then sorted and checked for a one-to-one correspondence.

If the “-f” or “-F” parameters are specified, the vwverify utility adds, deletes, or updates the inconsistent database records as follows:

  • If no roster record is present for a queue record, one is created.
  • If no queue record is present for a roster record, the roster record is deleted.
  • If multiple records occur for a single work item number, all but the latest are deleted.
  • If the single queue and roster records disagree, the roster record is updated.

See Running vwverify for further information.