Applies to Product - Dynamics 365 Commerce
What’s happening?
Customers are experiencing issues where categories and subcategories under "Navigation Categories" cannot be deleted. When attempting to delete, the operation times out and an error message is displayed.
Reason:
The timeout issue appears to be related to performance problems with the ECORESCATEGORY table, which contains a large number of records (over 1000 categories). The presence of foreign key constraints and potential cascading deletes may also contribute to the complexity and timeouts during deletion attempts.
Resolution:
- Ensure that the attribute or category being deleted is not in use elsewhere.
- Reset the Channel Attribute Override by navigating to the appropriate setup for channel categories and product attributes, then republish the channel update.
- If the issue persists, consider reducing the number of categories in the hierarchy to below 1000.
- For categories that are part of a hierarchy, start by deleting child nodes and progress upwards toward the root category.
- Delete any associated records (e.g., products, commodity codes) linked to the category before attempting to delete the category itself.