Resolving Product Specification Update Errors in Vlocity Product Designer (Too many query rows: 50001)

To resolve this error and successfully save Product Specifications, the volume of Project Item records assigned to the affected user must be reduced to below the 50,000-record threshold.

1. Identify Affected Users
Execute the following SOQL query using the Salesforce Developer Console, Salesforce Inspector, or a similar data tool. This query aggregates the count of project items assigned to each user in the organization, sorted from highest to lowest:

SELECT vlocity_cmt__ProjectId__r.Owner.Username, COUNT(Id) FROM vlocity_cmt__ProjectItem__c GROUP BY vlocity_cmt__ProjectId__r.Owner.Username ORDER BY COUNT(Id) DESC LIMIT 100

2. Remove Excess Records
Review the query results to identify users who exceed the 50,000-record limit.

• Delete obsolete, unneeded, or orphaned Project Item records assigned to these specific users.
• For large data volumes, it is recommended to use the Data Loader or execute a batch deletion process to safely remove the records without hitting further platform limits.

3. Reattempt the Update
Once the assigned record count for the affected user is successfully reduced below the 50,000 threshold, return to the Product Designer. The Product Specification field will now save correctly without triggering the SOQL limit exception.