7.0.0 DXP GA1, 7.0.0 DXP FP32, 7.0.4 CE GA5
Even though, this approach is not a good way, portal will be able to take the guard to avoid this error by setting the new property like below
Note 10000, it is 1000. Therefore, portal won't send 1000 primary keys in one list because finder cache won't be able to cache more than 1000 in this case.
This is a know limitation on Oracle side which has been met in the past as well. There will be fails with ORA-01795 , when calling JournalArticleLocalServiceUtil.getArticles(groupId, folderId).
1-) Configure DXP to connect to OracleDB
2-) Add at least 11001 web content articles
3-) Execute the following script on the Server Administration's Script tab:
Note: first execution succeeds, as it's not yet able to utilize the Finder- and EntityCache.
4-) Execute the above script again.
Result in log:
Reproduced on :