Extended Analytics Error "One or more errors occurred during processing of command" For Data Warehouse Extracts

(Doc ID 1358184.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a HFM Extended Analytics (EA) extract with the Data Warehouse type, the extract fails and tables are not created. Other types of extracts work fine. The following error is reported in the Extended Analytics log:

<timestamp: Status : Extracting Metadata
Schema did not previously exist.
Metadata update has failed. : (-2147217900) (One or more errors occurred during processing of command.)
Processing status change: (-2147217900)
Data processing failed. : (-2147217900) (One or more errors occurred during processing of command.)
timestamp : Status : Processing completed with errors
Extended Analytics export completed with errors for Application appname using Label XXX. Error code is: >


In the Financial Management (HFM) log file Hsveventlog.log, the following error message appears:

<Description Src=ADO>One or more errors occurred during processing of command.</Description>
<Type>1</Type>
<DTime>timestamp</DTime>
<Svr>servername</Svr>
<File>MetadataProcessing.cpp</File>
<Line>172</Line>
<Ver>11.1.1.3.500.3124</Ver>
<DStr></DStr>
<ExErr></ExErr>
<PSec>
<Param>CREATE TABLE XXX_ICP (ID INT NOT NULL, Label NVARCHAR(100) NOT
NULL, Description NVARCHAR(256) NULL, IsShared INT NOT NULL, IsLeaf INT NOT
NULL, PRIMARY KEY (ID) tablespace_name) tablespace_name</Param>

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