Extended Analytics Error "One or more errors occurred during processing of command" For Data Warehouse Extracts
(Doc ID 1358184.1)
Last updated on APRIL 23, 2018
Applies to:Hyperion Financial Management - Version 126.96.36.199.00 and later
Information in this document applies to any platform.
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>
<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>
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!