ORA-01795: maximum number of expressions in a list is 1000 can be obtained when invoking BasePersistenceImpl.fetchByPrimaryKeys

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, 7.3.X, Master
• Fix Version/s: 7.0.0 DXP FP102, 7.0.10.16 DXP SP17, 7.0.X, 7.1.10 DXP FP26, 7.1.10.7 SP7, 7.1.X, 7.2.10 DXP FP15, 7.2.X, 7.3.X, 7.4.13 DXP GA1, 7.4.3.4 CE GA4, Master
• Component/s: Core Infrastructure > Database Access
• Labels:
  • INACTIVE
  • backend_test
  • ee-ts
  • liferay-dxp-70-sp17
  • liferay-dxp-71-sp7
  • liferay-fixpack-de-102-7010
  • liferay-fixpack-dxp-15-7210
  • liferay-fixpack-dxp-26-7110
  • pt-app-security-review
  • pt-upgrade-review
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/shuyangzhou/liferay-portal/pull/10229

When working with a database like Oracle where the maximum number of expressions in an IN clause is limited we can still obtain the following error, even after LPS-68101:

 

at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:269)
at com.liferay.portal.service.persistence.impl.PortletPreferencesPersistenceImpl.fetchByPrimaryKeys(PortletPreferencesPersistenceImpl.java:5894)
at com.liferay.portal.cache.internal.dao.orm.FinderCacheImpl._primaryKeyToResult(FinderCacheImpl.java:364)
at com.liferay.portal.cache.internal.dao.orm.FinderCacheImpl.getResult(FinderCacheImpl.java:144)
at com.liferay.portal.kernel.dao.orm.FinderCacheUtil.getResult(FinderCacheUtil.java:49)
at com.liferay.portal.service.persistence.impl.PortletPreferencesPersistenceImpl.findByO_O_P(PortletPreferencesPersistenceImpl.java:2427)
at com.liferay.portal.service.persistence.impl.PortletPreferencesPersistenceImpl.findByO_O_P(PortletPreferencesPersistenceImpl.java:2380)
at com.liferay.portal.service.persistence.impl.PortletPreferencesPersistenceImpl.findByO_O_P(PortletPreferencesPersistenceImpl.java:2334)

 

This can happen when the result of a finder returns more than N elements and we try to retrieve them all to save them in the EntityCache.