Issue With Number Of Assets In Recommendation
Last updated on NOVEMBER 03, 2016
Applies to:Oracle WebCenter Sites - Version 7.6.2 and later
Information in this document applies to any platform.
A recommendation has more than 1000 assets in, loading the recommendation fails with:
[2015-08-03 17:48:22.157][CS.DB][ERROR] SQLException executing query: SELECT classname,id FROM RuleSetDef j1 WHERE EXISTS(SELECT 'x' FROM MyAssetType_P_Extension WHERE j1.id=rulesetid AND (ownerid IN (...more than 1000 assetids..)))
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
If the number of recomendations is reduced to < 1000, then loading the recommendation succeeds.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms