legacy-knowledge-base
公開されました Jun. 30, 2025

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

learn-legacy-article-disclaimer-text

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+.

Additional Information

  • Before making any changes to your database, it's crucial to back up your data. Having a recent backup ensures that you can restore your database to its original state if something goes wrong, preventing potential data loss or system downtime.

 

 

did-this-article-resolve-your-issue

legacy-knowledge-base