Financial Management Error "ORA-01795: maximum number of expressions in a list is 1000" When Updating Extended Analytics Star Schema

(Doc ID 1091789.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Management - Version: 9.3.1.0.00 to 11.1.1.3.00 - Release: 9.3 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2011***

Symptoms

When trying to Update an Extended Analytics star schema with many entities selected, the Extended Analytics extract fails.  Included in the Export log and in the HsvEventLog is the following error message:

ORA-01795: maximum number of expressions in a list is 1000

The error message in HsvEventLog may look like this:

<Num HEX=0x80040E14>-2147217900</Num>
<Description Src=ADO>One or more errors occurred during processing of
command.</Description>
<Type>0</Type>
<DTime>7/27/2009 4:05:04 PM</DTime>
<Svr>APPSERVER</Svr>
<File>CommonSQL.cpp</File>
<Line>403</Line>
<Ver>11.1.1.2.0.2207</Ver>
<DStr>DELETE FROM APPNAME_FACT WHERE EntityID IN (0, 1134, 824, 764, 952,
765, 458, 458, 458, 459, 459, 459, 1409, 1409, 777, 460, 460, 460, 480, 480,
.......
1086, 157, 157, 157, 183, 183, 183, 185, 185, 185, 441, 441, 441, 1188, 1188,
1188, 1269, 1269) AND ScenarioID IN (5) AND YearID IN (2009) AND PeriodID IN
(83886084)</DStr>

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