home

ACS

RealmMinistryPlatformPDSACSAccountingGivingConnectShepherdGrowth MethodGo MethodMissionInsiteGatherHeadMaster ChildcareTrust CenterData Governance and Business DocsACST Content Standards
RealmMinistryPlatformPDSACSAccountingGivingConnectShepherdGrowth MethodGo MethodMissionInsiteGatherHeadMaster ChildcareTrust CenterData Governance and Business DocsACST Content Standards

What would you like to know more about?

Show Contents

thumbnailACS

Accounts Payable Troubleshooting

Error 9729 - Duplicate Key in Primary of Table

This troubleshooting article addresses the "Error 9729 - Duplicate Key in Primary of Table" issue that occurs when creating an ACH file in Accounts Payable. The error is due to a corrupt table with a duplicate entry. The guide provides a step-by-step solution to resolve this issue.

When trying to create an ACH file in Accounts Payable, this error displays:

Dbisam engine error #9729 duplicate key found in the index "Primary" of the table achapbrk".

  • Producst Affected: Accounts Payable

  • Versions affected: Any

The table is corrupt with a duplicate entry.

  1. Make a financial backup.
  2. Go to Utility Manager > Table Maintenance > Financial, and locate the ACHAPBRK table. The file will be in the acsfdat data folder.
  3. Reinstall the table, then close the menu and log into ACS Financial Suite.
    The client should be able to create the ACH file.
  4. If the error message displays again and you can't create the file, create a new financial dataset.
  5. Next, locate ACHAPBRK in the new acsfdat folder and copy the file into the acsfdat in which the error occurs.
    Example: If you're having issues with the dataset path of acsnet\acsfdat\data1, and the new test dataset path is acsnet\acsfdat\data2, locate ACHAPBRK.ACSDAT and ACHAPBRK.ACSIDX in the Test dataset, acsnet\acsfdat\data2. Copy both the table and index ACHAPBRK.ACSDAT and ACHAPBRK.ACSIDX into the acsnet\acsfdat\data1 folder.
    The customer should be able to log in and create the ACH file.
Troubleshooting
ACS
Financial Suite

Last updated: March 3, 2026