Issue With Number Of Assets In Recommendation (Doc ID 2085079.1)

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.

Symptoms

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.

Cause

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