2021 is coming to a close, so it's time for your books to do the same!

Page tree

Problem


When promoting individuals, this error displays: 

"DBISam engine error 9729, duplicate key found in the index by group field description of the table awgrfdef."

Products affected: Attendance

Versions affected: Any

Solution


To resolve this, perform a People Suite backup, then contact Support to delete the duplicate keys from the awgrfdef table. 

 To perform a People Suite backup
  1. Open the ACS Backup utility.
    a.) Windows 7: On your Windows desktop, click the Start button  in the lower-left corner of the screen. The Start menu displays. Click All Programs > ACS Technologies > ACS Tools > ACS Backup.
    b.) Windows 8.1: On the Windows desktop, click the Start button  in the lower-left corner of the screen. The Start screen displays. Click the arrow button . The Apps view displays. In the ACS Technologies section, click ACS Backup.
    c.) Windows 10: On the Windows desktop, click the Start button  in the lower-left corner of the screen. The Start menu displays. Scroll to the ACS Technologies section, and click ACS Backup.


    Link
  2. Log in using your ACS user name and password.
  3. Under Data Options, select People Data Backup.
  4. Optional: Under Additional Options, select Verify Backup.
  5. Under Configuration, note the Backup Destination Directory. To change the location, click Lookup .
  6. Click Backup
  7. In the Select Datasets window, clear any datasets you do not want to back up. We recommend backing up all datasets in each backup in case your data needs to be repaired, but if you include pictures, the backup may be very large.

  8. Click OK.

Note

If you use ACS OnDemand, log into OnDemand as an administrator to make a backup.