6 Replies Latest reply: May 3, 2011 3:04 AM by 641812 RSS

    Consolidation Unknown Error

    641812
      After consolidation, i check messages, find many errors. I don't know why.

      Error Code:{4BAFAE85-A9EF-403B-B91A-6F2DB4E67D5B}
      System Message Summary
      Config consolidation muliti dimension data set.
      An unknown error has occurred in the HsvDSData2 object.
      CFTEST consolidation stop id:409116216,Actual,2011,.G01,APR-APR, Consolidation type:ALL
      System Message Detail
      Error Reference Number: {4BAFAE85-A9EF-403B-B91A-6F2DB4E67D5B}
      Num: 0x43481;Type: 1;DTime: 2011-5-2 12:11:43;Svr: HYSER;File: DataSetCubes.cpp;Line: 228;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:44;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:45;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:46;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:47;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:48;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:49;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:50;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:51;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:52;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 5809;Ver: 11.1.2.1.000.3082;DStr: ORA-00001: unique constraint (ICSS_HFM.SYS_C0034873) violated;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 4660;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 4229;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 2710;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 0;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 2595;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 2165;Ver: 11.1.2.1.000.3082;
      Num: 0x80040e2f;Type: 1;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 1437;Ver: 11.1.2.1.000.3082;DStr: Cube update was not successful.;
      Num: 0x80041e80;Type: 1;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 1440;Ver: 11.1.2.1.000.3082;
      Num: 0x80041e80;Type: 0;DTime: 2011-5-2 12:11:53;Svr: HYSER;File: DataSetCubes.cpp;Line: 596;Ver: 11.1.2.1.000.3082;
      Num: 0x80041c92;Type: 1;DTime: 2011-5-2 12:11:54;Svr: HYSER;File: CHsvDSCalculate.cpp;Line: 11976;Ver: 11.1.2.1.000.3082;
        • 1. Re: Consolidation Unknown Error
          GiacomoL
          That Oracle error smells like a bug. Open a case with support, making sure to specify how you created this app ( classic from scratch, classic updated from previous release, through copyapp, epma etc etc).
          • 2. Re: Consolidation Unknown Error
            CBarbieri
            If I'm not mistaken, there is a note in the readme regarding invalid records. Please check the readme for HFM, and I think you'll see a note to the effect that you should run "delete invalid records" in the database module (after first backing up your schema).

            --Chris                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
            • 3. Re: Consolidation Unknown Error
              641812
              After run delete invalid records, consolidation still error.
              • 4. Re: Consolidation Unknown Error
                715379
                Hi,

                Looks like you are using 11.1.2.1 version??
                If so i am facing the same issues and i have already raised this issue with oracle support team, have not heard back from them.
                We recently upgraded from 11.1.2 to 11.1.2.1 and we are facing lot of issues and one of them is consolidation issues.
                And let me know if you have tired the below solution:

                Applies to:

                Hyperion Financial Management - Version: 11.1.1.3.00 and later [Release: 11.1 and later ]
                Information in this document applies to any platform.
                Symptoms

                Consolidation hangs at 100% for a specific Scenario/Year POV. The consolidation does not complete and the hsvdatasource process eventually has to be killed.
                The Parent has CN status, whereas all its children have OK status, from Entity currency to Contribution total.
                The following error is generated in the Hsveventlog log:

                File: DataTransactions.cpp Version: 11.1.1.3.50.2839 Line: 3163
                Error: (-2147213696)(0x80041E80)(An unknown error has occurred in the HsvDSData2 object.)

                If the UseConsolidationRules are disabled, the consolidation then completes.

                Cause

                The database schema is missing tables for the affected POV, scenario x and year yyyy:

                APPNAME_ETX_x_yyyy
                APPNAME_RTD_x_yyyy
                APPNAME_RTS_x_yyyy

                Two of three tables, RTS and RTD, are used if ConsolidateRules is set to Y or R, and this is the direct cause of the error message generated. It is not known whether these tables ever existed or have been inadvertently deleted.
                Solution

                Restore Financial Management (HFM) repository database from the backup, if the missing tables exist in a prior backup. If no suitable backup exists, contact Oracle Support. A script may be provided by Oracle Development to create the missing tables and corresponding sequence and indexes.

                Regards,
                Bhargav
                • 5. Re: Consolidation Unknown Error
                  beyerch2
                  ^

                  Wow, that bug report are reasons I don't early adopt anything be it from Oracle or MS. I hope they sort that out soon enough!
                  • 6. Re: Consolidation Unknown Error
                    641812
                    Version is 11.1.2.1,The database schema's not missing tables (_ETX_, RTD ,_RTS_ all exist).

                    I create a HFM aplication using EPMA for testing, then import C1-C4 dimension memeber from database interface, redeployment application and data synchronization using EPMA batch client, first consolidation using task automation is OK.

                    Then I run batch script once again, import member, redeployment and data synchronization. Now the Parent has CN status, its children have OK SC status. run consolidation all task, failed, HsvDSData2 error in message, the Parent has CN status, its children have OK status.