Truncating a corrupted personnel distribution table.

NOTICE

POTENTIAL FOR DATA LOSS.
The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure, please contact Product Support Services prior to attempting the procedure below.

NOTICE

COMPLEX PROCEDURE REQUIRED.
The resolution of this article has many complex steps that may result in unforeseen results if not performed correctly. If you are at all unfamiliar with the requirements, please contact Product Support Services for assistance.

Issue

There may be cases when the personnel distribution table in the ContinuumDB becomes corrupted and must be truncated.

Product Line

Andover Continuum

Environment

CyberStation

Cause

Table corruption issues.

Resolution

WARNING: Unless knowing exactly what you are doing, deleting entries from your database can cause irreversible harm to your database and can potential cause corruption. Make sure to perform a full SQL Database backup before attempting to make any changes to the database. (See Lessons Learned Article #4635 for details on how to backup your database and if not already installed, where to get Management Studio from)

Should an issue arise in Continuum that requires a cleanup of the PersonnelDistribution table in the Continuum database follow this procedure to truncate the table and re-populate it.

  1. Make a backup of the Continuum database as a precaution.
  2. Close ALL CyberStation workstations.
  3. In SQL Management Studio execute the following query.
    truncate table PersonnelDistribution
  4. Once the table is truncated it must be re-populated by one of the following methods...
    1. If the total number of personnel objects is reasonably small (in the hundreds) launch Continuum and bring a list view of all the personnel objects, select all then right click and perform a 'Send to controller'
      OR
    2. In SQL Management Studio Invoke the stored SQL procedure that initializes the PersonnelDistribution table using the query
      dt_DIST_Init_Personnel_Dist_Table

IMPORTANT:

Truncating the PersonnelDistribution table will remove all pending personnel distribution including personnel deletions; controllers could potentially continue to allow access to doors for the deleted personnel until reloaded. Conversely, removing a pending personnel distribution could potentially cause a person to be denied access at a door until a distribution is performed to the controller.