Large Amount of Object Data within the `analyticsmessage` table.
Written By
Emma Carr-Gardner
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
Legacy Article
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
Issue
- We're experiencing slow database restore times due to excessive large object data, primarily within the `analyticsmessage` table.
- When planning an upgrade, we've found a table with millions of objects, slowing down the process.
Environment
- Upgrading from DXP 7.4 > Liferay DXP Quarterly Releases
Resolution
- The `analyticsmessage` table stores audit data related to users, groups, organizations, and other entities that are synchronized with the Analytics Cloud. Although this data is usually deleted after being sent to the Analytics Cloud, a high volume of entries can sometimes cause a backlog.
- If this table is causing delays in your database backups before upgrading, our team has determined that it is safe to clean up the `analyticsmessage` table. The improved syncing method, which now uses batching, no longer relies on this table. However, to prevent any potential data loss, please reconfigure your Analytics Cloud settings to resync contacts after upgrading to 2023.Q4+.
Did this article resolve your issue ?