WebCenter Analytics Document and Content Item Reports Do Not Display Results And Cause ORA-01795 Error (Doc ID 1154235.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle WebCenter Analytics - Version 2.1 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jan-2014***

Symptoms

When you attempt to create reports on 'Document Views' or 'Content Item Views' in WebCenter Analytics Console, no results are displayed and the following error appears in the analyticsui.log file:

ERROR JDBCExceptionReporter - [plumtree][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000


This problem only occurs when the WebCenter Analytics database has been installed on Oracle RDBMS.

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