Overview of database consistency checks (DBCCs)

A database consistency check (DBCC) is a check that ClaimCenter executes to verify that data in the database is consistent. For example, every activity should be assigned to a group and a user (or a group and a queue). The "Assignment check" DBCC verifies that every activity has a valid group/user/queue assignment. If there are activities without valid assignments, it provides SQL queries to identify the number of inconsistent activities and the specific inconsistent activities.

Cloud API provides support for DBCCs. This includes running DBCCs, retrieving information about DBCCs, and downloading DBCC reports in a zip file format.

DBCC runs

A DBCC run refers to the execution of a DBCC. DBCC run information is stored in the ClaimCenter database. Each DBCC run is assigned an id, the dbccId, which can be used to access that information any time after the DBCC was run.

DBCC scopes

DBCC runs can execute every type of check on every table in the database. DBCC runs can also be limited to a specific set of tables, and/or a specific set of check types, such as assignment checks. The complete list of DBCC check types is defined in the ConsistencyCheckType typelist.

DBCC run descriptions

Every DBCC run has a description generated by ClaimCenter. It specifies which tables and checks were executed in the DBCC run.

For example, when you execute a run with all check types on all tables, the DBCC run description is:

Tables:  All.; Checks:  All.

If you run the DBCCs only for the cc_activity table (but for all check types), then the description is:

Tables:  cc_activity; Checks:  All.

If you run only the assignment check DBCCs (on all tables), then the description is:

Tables:  All.; Checks:  assignmentcheck.

If you run only the assignment check DBCCs for only the cc_activity table, then the description is:

Tables:  cc_activity.; Checks:  assignmentcheck.