Auto Number table is copied at the same time as others causing inconsistencies in auto number values
Last updated 2022-02-10 ·Reference W-2727385 ·Reported By 7 users
When a sandbox is being copied, the auto_number table can be copied at the same time as other tables, instead of being copied last. This can cause inconsistencies in auto number values, for example you would be able to create new records that end up having the same auto number value as an existing record.
You can check the last auto number used in your production environment and calculate the gap between production and sandbox. From there, you can insert dummy records in sandbox to increase the auto number values and catch up with production.
After that newly created records should not result in duplicate values.
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.