Verify Locks command

Use the verify locks (verilk) command to check and repair:

  • The parent_list, which contains information about the relationships between parent and child objects. For each child object, it contains the object ID of the parent, the object ID of the child, and the current revision of the child.
  • project post lists and project locks.

The verilk command should be executed with the -relations switch before you execute reap_delete or if you encounter errors with the parent_list or the post list.

Before executing the verilk command, it is recommended that you log in to the database in and remove entries from the parent_list and subcfgs tables.

To do this for Oracle databases, run sqlplus as dbname/password — where dbname is the name of the Contenta database and password is the Contenta password for the database (if you do not know the Contenta password for the database, contact RWS Customer Support). Then issue the following commands at the SQL prompt:

delete from parent_list;
delete from subcfgs;
quit
To do this for SQL Server databases, run sqlcmd -S sqlservername -U xyadmin -d dbname -P password -where sqlservername is the name of the system that has SQL Server installed, dbname is the name of the Contenta database and password is the xyadmin password (if you do not know the xyadmin password, contact RWS Customer Support). Then issue the following commands at the SQL prompt:
ddelete from databasename.dbo.parent_list
go
delete from datbasename.dbo.subcfgs
go
quit

Then issue the verilk command.