No Personnel distribution

[Product_Support]

Issue

Right clicking the controller and selecting "Distribute Personnel" results in NO distribution

There is no error

Product Line

Andover Continuum

Environment

CyberStation

Cause

Corrupted Personnel Distribution table in SQL ContinuumDB

Resolution

Truncate table PersonnelDistribution and re-populate it, then distribute personnel once again.

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 Move / Backup / Restore a database on a Single User SQL2005 Express system for details on how to backup your database and if not already installed, where to get Management Studio from)

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.