Unable to Delete Personnel Records

Article ID: SWH-KB-nID-000017564

Published: Mar-29-2022




Symptom

Following a conversion of a SAS to Standalone, personnel records cannot be deleted.

The following error is found in both SystemTrace and the Windows Application Event Log:

 

 

Cause

The stored procedure is missing from the ACVSCORE database

Solution

Pull a copy of the stored procedure ‘ACVSCore.Access.PersonnelCustomCascadeDelete’ from an existing 2.80SP2 ACVSCORE database, and re-create the stored procedure in the affected ACVSCORE database.

 

No service restarts are necessary.

 

CCure9000_SWH-KB-nID-000017564.lt_.en_-1.pdf