Submit Feedback
Legacy Knowledge Base
Published Sep. 10, 2025

Upgrade Failed due to the Error "No Group exists with the primary key xxxxxx"

Written By

Laura Li

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

  • When doing database upgrade from 7.0 de-98 to 7.4, the upgrade failed with the following error:
    ERROR [main][ReleaseManagerImpl:183] Failed upgrade process for module
com.liferay.dynamic.data.mapping.service
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.NoSuchGroupException: No Group exists with the primary key 3208897
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:136)b ~[portal-kernel.jar:?]
......

 

Environment

  • Liferay DXP 7.0, Liferay DXP 7.3

 

Resolution

  • The error means that some data in DDMStructureLayout table have a groupId that doesn't exists in Group_ table. 
  • Use the attached Groovy script to clean the orphaned data. 
  • Steps:
    1. Back up the database
    2. Go to Control Panel > Configuration > Server Administration > Script
    3. Copy the content of the attached script and paste it into the text area
    4. The script should be running successfully and deleting messages show in the log like below:
      2023-04-21 00:51:21.778 INFO [http-nio-8080-exec-8][DeleteOrphanedDDMStructureLayouts:?]
Deleting DDM structure layout 3210052 as its group id does not exist…

 

Additional Information

  • The script is successfully run in Liferay DXP 7.0 de-98 and Liferay DXP 7.3 SP3. It may also work in other DXP versions. You may backup the database and test the script at your discretion.
Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?