Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error inserting a row in the database when refreshing a personnel template.

Issue

Getting error inserting a row in the database when refreshing a personnel template.

Environment

CyberStation

Cause

AreaLink table contains NULL instead of zero  in the ClearanceLevel column.

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)

Run the following query:

Update AreaLink Set ClearanceLevel = 0 where ClearanceLevel is null

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-10 06:09 AM
Updated by: