Right clicking the controller and selecting "Distribute Personnel" results in NO distribution
There is no error
Corrupted Personnel Distribution table in SQL ContinuumDB
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 Lessons Learned Article #4635 for details on how to backup your database and if not already installed, where to get Management Studio from)
- Make a backup of the Continuum database as a precaution.
- Close ALL CyberStation workstations.
In SQL Management Studio execute the following query.
truncate table PersonnelDistribution
Once the table is truncated it must be re-populated by one of the following methods...
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'
In SQL Management Studio Invoke the stored SQL procedure that initializes the PersonnelDistribution table using the query
- 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'
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.