Hi All
I’m seeking advice from the community on which is the better way to delete tenants from Acumatica.
My setup is PCS running 25R1. Is it better to use Acumatica Configuration an choose Perform Database Maintenance and delete the tenants there or to delete the tenants from within the application itself?
Also, will there have to be any reindexing of the database after deleting tenants?
Thanks in advance.
Amit
Best answer by Pallika Sharma
Hello
The recommended approach is to delete tenants directly from within the application using the Tenants (SM203520) screen or Delete Snapshots and Tenants (SM503000). This ensures that all related data and system references are properly cleaned up and helps maintain database integrity.
Using the Acumatica Configuration tool under “Perform Database Maintenance” to delete tenants is generally not advised for routine use, as it bypasses application-level logic and may leave behind orphaned records or inconsistencies.
Regarding database maintenance, reindexing is not typically required after deleting tenants. However, if the tenant being removed was large or if you notice any performance impact, it would be reasonable to run standard index maintenance as part of regular database upkeep.
Hello
The recommended approach is to delete tenants directly from within the application using the Tenants (SM203520) screen or Delete Snapshots and Tenants (SM503000). This ensures that all related data and system references are properly cleaned up and helps maintain database integrity.
Using the Acumatica Configuration tool under “Perform Database Maintenance” to delete tenants is generally not advised for routine use, as it bypasses application-level logic and may leave behind orphaned records or inconsistencies.
Regarding database maintenance, reindexing is not typically required after deleting tenants. However, if the tenant being removed was large or if you notice any performance impact, it would be reasonable to run standard index maintenance as part of regular database upkeep.
Hi
Thank you for reaching out. I’ll take the route of deleting the tenants from the application.
Thanks
Amit
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
