A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
The warning means the site is approaching or has exceeded the SharePoint Online overall site metadata limit. In SharePoint Online, metadata such as file size, author, creation date, file versions, lists, and other system-generated information counts toward that limit.
In this scenario, the practical remediation is to create more metadata space by cleaning up content that generates excess metadata:
- Delete old file versions in the affected lists and libraries.
Multiple versions of the same file or list item increase metadata usage. - Delete duplicate files in the affected lists and libraries.
Copies of the same file also contribute to metadata growth. - Since the issue started after a workflow loop, check whether the workflow created excessive versions or duplicate items, and remove that excess content first.
- If SharePoint 2013 workflows on the site were suspended because limits were exceeded, remove the workflows that exceeded their limits from: Settings > Site Settings > Workflow Settings > Workflow Health
- On the Workflow Health page, the workflows that caused suspension can be identified by running ShowScopeDebugInfo() in the browser developer console. If StatusDetails shows MaxTopicSize and MaxCorrelationFilter, it indicates the site suspended all SharePoint 2013 workflows.
- After removing the problematic workflows, allow time for cleanup. The process is not instant. The Workflow Health status changes to Connected when cleanup is complete.
SharePoint Online documentation also states the overall site metadata limit is 1000 GB per site.
References: