2 Replies Latest reply: Mar 21, 2013 1:57 PM by GCAPO RSS

    Extended Analytic template error

    922185
      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