Large redirect spreadsheets can block the distribution queue in Adobe Experience Manager
When you publish a large redirect spreadsheet in Adobe Experience Manager (AEM), the distribution queue can become blocked, which prevents other content from being published. To avoid and resolve the issue, assess the size of the spreadsheet, compare your production and non-production environments, check the queue for stuck jobs, and schedule large publishes for periods of low traffic.
Description description
Environment
Adobe Experience Manager (AEM) production environment.
Symptoms
When you attempt to publish a large redirect spreadsheet, the publishing distribution queue in AEM becomes stuck. This prevents all other content from being published to the live site. The issue is observed in the production environment but not in non-production environments when publishing the same file.
Cause
A very large redirect spreadsheet can overwhelm the AEM distribution queue in production. The queue can then become stuck and block subsequent content publishes. This might be due to resource constraints or queue processing limits in the production environment.
Resolution resolution
Follow these steps to resolve the issue.
- Assess the size of the redirect spreadsheet before publishing. Large files are more likely to cause performance issues.
- Compare the configuration and resource allocation between your production and non-production environments. Differences in these settings may explain why the issue only occurs in production.
- Use AEM’s monitoring tools to check the status of the distribution queue. Look for any stuck or long-running jobs that are blocking the queue.
- Do not publish large files during peak usage times. Schedule large content publishes during maintenance windows or periods of low traffic to minimize impact on other publishing activities.
- After taking these steps, verify that the distribution queue is processing jobs normally and that new content can be published successfully.