Submit Feedback
Legacy Knowledge Base
Published Sep. 10, 2025

ORA-01795: maximum number of expressions in a list is 1000_ [Sanitized]

Written By

Marcos da Silva Xavier

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

  • After performing an upgrade between DXP versions and using an Oracle database, the following errors are observed:
  • ERROR [main][UpgradeStepRegistratorTracker:185] Failed upgrade process for module com.liferay.dynamic.data.mapping.service
    com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000_ [Sanitized]

Environment

  • DXP 7.0 +

Resolution

  • What happens is that during the upgrade process, this specific method _upgradeDDMStructureLayout populates a List with structureIds as the Structure Layouts get processed.
    Once that method completes, the list containing the structureIds gets passed to _upgradeDDMStructure.
    The structureIds get used in a SQL query that uses IN(#,#). The contents of this customer’s list exceeds 1000 which then throws that error.
  • The fix would be given by a workaround hotfix where it modifies the upgrade process and creates

    a Statement that oracle should workaround Oracles 1000 entity limit.

    Therefore a ticket should be opened requesting a hotfix with LPP-50646.

 

 

 

Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?