Set the account code property

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer
  • After importing customer account information, update the com.snc.cs_base.last.generated.code.tree.path property with the correct account code value.

    Vorbereitungen

    Role required: import_admin and sn_crm_foundation_admin

    Warum und wann dieser Vorgang ausgeführt wird

    The com.snc.cs_base.last.generated.code.tree.path system property stores the Account Code value for the most recently created customer account in the Account (customer_account) table.

    When you create a customer account record, the system uses this property to generate a unique account code. The property is then updated with the latest value, confirming the next account record receives a new unique code.

    The value of the com.snc.cs_base.last.generated.code.tree.path property must match the value of the Account Code field for the last inserted customer account record. When you create customer account records by importing data from other sources or instances, these values can get out of synchronization. If these values don’t match, the system generates an error on the creation of the next new record in the Account table:

    java.sql.BatchUpdateException: Duplicate entry for key account_path

    Use the following steps to fix this error.

    Prozedur

    1. Determine the highest or last used account code value from the account (customer_account) table.
    2. Navigate to the System Property [sys_properties] table.
    3. Set the com.snc.cs_base.last.generated.code.tree.path property to the value determined in step 1.