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

Page tree

Problem


When updating Small Groups in People, this error displays: 

"DBISam Engine Error 9729. Duplicate key found in the index 'byParentIDName' of the table of the table name awgrgrp."

Products affected: People

Versions affected: Any

Solution


To resolve this, perform a People Suite backup, then reset Small Groups. 

 To perform a People 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.

 To reset Small Groups
  1. Under Advanced Tools, click the Settings tab.
  2. In the drop-down list, select Groups and click Go .
  3. Select the desired Small Group, then click Maintenance.
  4. Select Reset Small Groups and click Start.
  5. When the confirmation message displays, click Yes.
  6. Click OK, then update the Small Groups again.