0057873: Performance error with Assortment

Description

We got the error: The query took longer than expected and has been canceled. Please enter a more restrictive criteria to try to make the query faster

When we want to filter the tab “Product” in the Assortment.
It is by the amount of products that the assortment has loaded but cannot filter the product.

Part of the problem is the number of read organizations that this role has access to.
With fewer organizations (e.g. 5), an index is used.
But for example, at 10 or more, no index is used.

Then adding the index is most likely useless, because it seems that there is already another one that can be used in other conditions.

Steps To Reproduce

1 - The error is reproduced if we have many organizations and the role we use has access to them.

2 - Search for a product in an assortment relationship with an organization that is a parent of many organizations.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0177697) AugustoMauch (administrator) 2025-03-29 08:07	Exported to Jira: https://openbravo.atlassian.net/browse/RM-17810 [^]

Issue History
Date Modified	Username	Field	Change
2025-02-05 13:18	sofidossant	New Issue
2025-02-05 13:18	sofidossant	Assigned To	=> Triage Platform Base
2025-02-05 13:18	sofidossant	OBNetwork customer	=> Gold
2025-02-05 13:18	sofidossant	Modules	=> Core
2025-02-05 13:18	sofidossant	Support ticket	=> 110115
2025-02-05 13:18	sofidossant	Triggers an Emergency Pack	=> No
2025-02-21 10:03	AugustoMauch	Assigned To	Triage Platform Base => AugustoMauch
2025-02-21 10:03	AugustoMauch	Status	new => acknowledged
2025-03-29 08:07	AugustoMauch	Status	acknowledged => scheduled
2025-03-29 08:07	AugustoMauch	Note Added: 0177697
2025-03-29 08:07	AugustoMauch	Status	scheduled => closed
2025-03-29 08:07	AugustoMauch	Resolution	open => duplicate