Set the account code property
After importing customer account information, update the com.snc.cs_base.last.generated.code.tree.path property with the correct account code value.
Before you begin
Role required: admin
About this task
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 new customer account record, the system uses this property to determine a unique account code value for the account. The property is then updated with this latest assigned value so that the next account code value can be set as a unique value for the next account record insert.
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 sync. If these values do not match, the system generates an error upon creation of the next new record in the Account table:
java.sql.BatchUpdateException: Duplicate entry for key account_path
Use the steps below to fix this error.
Procedure
- Determine the account code for the last created account.
- Navigate to the System Property [sys_properties] table.
- Set the com.snc.cs_base.last.generated.code.tree.path property to the value determined in step 1.