The following example describes a Consistency Checker report. In this case, the tool detected five inconsistencies in the Users & Groups section.

Beginning Consistency Checks.....

Repository Name:   buzzard
Server Version: 5.1.0.63 Win32.SQLServer
Database:       SQLServer

#################################################
##
## CONSISTENCY_CHECK: Users & Groups
##
##     Start Time: 09-10-2002 10:15:55
##
##
#################################################

Checking for users with non-existent group
  WARNING CC-0001: User ’docu’ belongs to 
non-existent group ’’
  WARNING CC-0001: User ’engr’ belongs to 
non-existent group ’’
 WARNING CC-0001: User ’marketing’ belongs to 
non-existent group ’’
  WARNING CC-0001: User ’nagboat’ belongs to 
non-existent group ’’
  WARNING CC-0001: User ’admingroup’ belongs to
 non-existent group ’’
Rows Returned: 5

Checking for users belonging to groups not in dm_user
Checking for users not listed in dmi_object_type
Checking for groups not listed in dmi_object_type
Checking for groups belonging to non-existent groups
Checking for groups with non-existent super groups

##################################################
##
##
## CONSISTENCY_CHECK: ACLs ##
## 
##     Start Time: 09-10-2002 10:15:55 
##
##
##################################################

Checking for ACLs with non-existent users
Checking for ACLs with missing dm_acl_r table entries
Checking for sysobjects with acl_domain set to
 non-existent user
Checking for sysobjects that belong to 
non-existent users
Checking for sysobjects with non-existent ACLs
Checking for ACL objects with missing dm_acl_s entry
Checking for ACL objects with r_accessor_permit 
value but missing r_accessor_name value
Checking for ACL objects with r_accessor_name value
 but missing r_accessor_permit value
Checking for ACL objects with r_is_group value but
 missing r_accessor_permit value
Checking for ACL objects with r_is_group value but
 missing r_accessor_name value
Checking for ACL object with r_accessor_name value
 but missing r_is_group value
Checking for ACL object with r_accessor_permit value
 but missing r_is_group value

################################################
##
##
## CONSISTENCY_CHECK: Sysobjects
##
##
##     Start Time: 09-10-2002 10:15:58 
##
##
#################################################

Checking for sysobjects which are not referenced in 
dmi_object_type
Checking for sysobjects that point to non-existent
 content
Checking for sysobjects that are linked to non-existent
 folders
Checking for sysobjects that are linked to non-existent
 primary cabinets
Checking for sysobjects with non-existent i_chronicle_id
Checking for sysobjects with non-existent i_antecedent_id
Checking for sysobjects with missing 
dm_sysobject_r entries
Checking for sysobjects with missing 
dm_sysobject_s entry

#################################################
##
##
## CONSISTENCY_CHECK: Folders and Cabinets
##
##     Start Time: 09-10-2002 10:16:02 
##
##
#################################################

Checking for folders with missing dm_folder_r table
 entries
Checking for folders that are referenced in dm_folder_r
 but not in dm_folder_s
Checking for dm_folder objects that are missing an 
entry in dmi_object_type
Checking for dm_folder objects that are missing 
corresponding dm_sysobject entries
Checking for folders with non-existent ancestor_id
Checking for cabinet that have missing dm_folder_r 
table entries
Checking for cabinets that are missing an entry in 
dmi_object_type
Checking for folder objects with missing 
dm_sysobject_r entries
Checking for folder objects with null r_folder_path

#################################################
##
##
## CONSISTENCY_CHECK: Documents
##
##
##     Start Time: 09-10-2002 10:16:03
##
##
#################################################

Checking for documents with a dm_sysobject_s entry
 but no dm_document_s entry
Checking for documents with missing dm_sysobect_s
 entries
Checking for documents with missing dmi_object_type
 entry

#################################################
##
##
## CONSISTENCY_CHECK: Content
##
##     Start Time: 09-10-2002 10:16:03
##
##
##
#################################################

Checking for content objects that reference 
non-existent parents
Checking for content with invalid storage_id
Checking for content objects with non-existent format

#################################################
##
##
## CONSISTENCY_CHECK: Workflow
##
##
##     Start Time: 09-10-2002 10:16:03
##
##
#################################################

Checking for dmi_queue_item objects with non-existent
 queued objects
Checking for dmi_workitem objects that reference 
non-existent dm_workflow objects
Checking for dmi_package objects with missing 
dmi_package_s entries
Checking for dmi_package objects that reference
 non-existent dm_workflow objects
Checking for workflow objects with non-existent
 r_component_id
Checking for workflow objects with missing 
dm_workflow_s entry
Checking for work item objects with missing 
dm_workitem_s entry

################################################
##
##
## CONSISTENCY_CHECK: Types 
##
##     Start Time: 09-10-2002 10:16:04
##
##
################################################

Checking for dm_type objects with a non-existen
t dmi_type_info object
Checking for dmi_type_info objects with a non-existent
 dm_type object
Checking for type objects with corrupted property
 positions
Checking for types with invalid property counts

#################################################
##
##
## CONSISTENCY_CHECK: Data Dictionary
##
##     Start Time: 09-10-2002 10:16:04
##
##
#################################################

Checking for duplicate dmi_dd_attr_info objects
Checking for duplicate dmi_dd_type_info objects
Checking for any dmi_dd_attr_info objects that are
 missing an entry in dmi_dd_common_info_s
Checking for any dmi_dd_type_info objects that are
 missing an entry in dmi_dd_common_info_s
Checking for any dmi_dd_attr_info objects that are
 missing an entry in dmi_dd_attr_info_s
Checking for any dmi_dd_type_info objects that are
 missing an entry in dmi_dd_type_info_s

################################################
##
##
## CONSISTENCY_CHECK: Lifecycles
##
##     Start Time: 09-10-2002 10:16:11
##
#################################################

Checking for sysobjects that reference non_existent
 policy objects
Checking for any policy objects that reference 
non-existent types in included_type
Checking for any policy objects with missing 
dm_sysobject_s entry
Checking for any policy objects with missing 
dm_sysobject_r entries
Checking for policy objects with missing dm_policy_r
 entries
Checking for policy objects with missing dm_policy_s
 entry

################################################
##
##
## CONSISTENCY_CHECK: FullText
##
##     Start Time: 09-10-2002 10:16:11
##
################################################

Checking for tdk index objects that point to 
non-existent fulltext index objects
Checking for any tdk collect objects that point to
 non-existent tdk index objects
Checking for any fulltext index objects that point
 to non-existent tdk index objects
Checking for any tdk index objects that point to 
non-existent tdk collect objects
Checking for any non-orphaned dmr_content objects 
that point to types that do not exist
Checking for any non-orphaned dmr_content objects 
that point to non-existent formats
Checking for any dmr_content objects that point to 
a non-existent fulltext index
Checking for any fulltext index propertys that are
 no longer in dm_type

#################################################
##
##
## CONSISTENCY_CHECK: Indices
##
##     Start Time: 09-10-2002 10:16:11
##
#################################################

Checking for dmi_index objects that reference
 non-existent types
Checking for types with non-existent dmi_index 
object for <type>_s table
Checking for types with non-existent dmi_index 
object for <type>_r table
Checking for index objects with invalid property
 positions

################################################
##
##
## CONSISTENCY_CHECK: Methods
##
##     Start Time: 09-10-2002 10:16:11
##
################################################

Checking for java dm_method objects that reference
 jview

Consistency Checker completed successfully
Total number of inconsistencies found: 5
Disconnected from the server.