This discussion is archived
2 Replies Latest reply: Mar 21, 2013 11:57 AM by GCAPO RSS

Extended Analytic template error

922185 Newbie
Currently Being Moderated
After we migrated from 9.3.1 to 11.1.2.1, we can no longer run one of the EA templates to extract Currency from HFM to the SQL database.

Here is the error log. Any idea??? No problem for running the other templates for IS, BS and stat accounts. Thanks!

Extended Analytics Export - log:

////////////////////////////////////////////////////////////////////////
// Financial Management Data Extract
// Date: 11/16/2012 11:09:24 AM
// User: Hyp_Sched@MSAD
// Source Financial Management Application: NOVELISHFM
// Destination:
// Extract Type: Warehouse Extract
// Options: Create New / Replace Existing
// Dynamic Accounts: Yes
//
////////////////////////////////////////////////////////////////////////

11/16/2012 11:09:24 AM : Status : Queued
11/16/2012 11:09:24 AM : Status : Initializing

Selected Scenarios:
Actual
Selected Years:
2013
Selected Periods:
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Selected Views:
Periodic
Selected Entities:
[None]
Selected Values:
[None]
Selected Accounts:
EOMRATE
OPERATE
Selected ICPs:
[ICP None]
Selected Custom1:
USD
EUR
GBP
AUD
BRL
CAD
CHF
DKK
JPY
KRW
MYR
NOK
SEK
CNY
INR
MXN
VEF
VND
Selected Custom2:
USD
Selected Custom3:
[None]
Selected Custom4:
[None]

11/16/2012 11:09:24 AM : Status : Extracting Metadata
Schema did not previously exist.
Metadata successfully updated.
11/16/2012 11:09:36 AM : Status : Extracting Data
11/16/2012 11:09:36 AM : Starting Sub-Cube: Actual - 2013 - Apr - [MEMBERNOTUSED].[None]
Failed to write records for Extended Analytics extract. Retrying operation. hr=-2147217873, Scenario=1, Year=2013, Period=67108864, View=1, Entity=0, Parent=-1, Value=0, Account=2184, ICP=2130706432, Custom1=2130706450, Custom2=2130706433, Custom3=0, Custom4=0, Data=0.047960
Failed to write records for Extended Analytics extract. Retrying operation. hr=-2147217873, Scenario=1, Year=2013, Period=67108864, View=1, Entity=0, Parent=-1, Value=0, Account=2184, ICP=2130706432, Custom1=2130706450, Custom2=2130706433, Custom3=0, Custom4=0, Data=0.047960
Failed to write records for Extended Analytics extract for 3 times. hr=-2147217873, Scenario=1, Year=2013, Period=67108864, View=1, Entity=0, Parent=-1, Value=0, Account=2184, ICP=2130706432, Custom1=2130706450, Custom2=2130706433, Custom3=0, Custom4=0, Data=0.047960
An error occured while processing cube! Scenario=1 Year=2013 Entity=0 Parent=-1 Value=0 : (-2147217873) (Value violated the integrity constraints for a column or table.)
Processing status change: (-2147217873)
Data processing failed. : (-2147217873) (Value violated the integrity constraints for a column or table.)
11/16/2012 11:09:37 AM : Status : Processing completed with errors
Data extract completed with errors for Application NOVELISHFM using prefix CUR. Error code is

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points