4 Replies Latest reply: Oct 3, 2013 2:33 PM by ragavhere RSS

    ERPI Metadata load fails

    ragavhere

      Hi,

       

      1. I am trying to load metadata to classic essbase application from peoplesoft using ERPI. The process fails with the below error.

       

      ERPI Process Start, Process ID: 19
      ERPI Logging Level: DEBUG (5)
      ERPI Log File: C:\Windows\TEMP\/aif_19.log
      Jython Version: 2.1
      Java Platform: java1.4.2_08
      COMM Dimension Pre-Processing - Multi Process Validation - START
      COMM Dimension Pre-Processing - Multi Process Validation - END
      Error in Start PS Load Dimension Members
      java.lang.Exception: The scenario did not end properly.

       

      When looked at ODI, the error is as below.

       

      java.sql.SQLException: java.sql.SQLException: ORA-00001: unique constraint (TST_ERP.AIF_DIM_MEMBERS_STG_U1) violated

       

      2. Chartfields in Peoplesoft does not have the hierarchy structure of parent child relationship. How will ERPi build the hierarchy in Hyperion if the chartfield do not contain the hierarchy structure.

       

      Regards,

      Ragav.

        • 1. Re: ERPI Metadata load fails
          JeffJon

          Anytime a Unique Constraint violation is returned, the process is attempting to insert a duplciate record into the table mentioned in the error code.  In this case, a duplicate records is attempting to be inserted into the AIF_DIM_MEMBERS_STG table and is violating the constraint listed.

          • 2. Re: ERPI Metadata load fails
            ragavhere

            Jeff,

             

            Thanks for response. I had opened an SR with oracle for this. It was a bug and the resolution is below. After this change, the process succeeds. However the metadata does not flow inside Hyperion Essbase application. Load method is classic. Do I need to configure any adapters for ERPI to work with Essbase?

             

            SYMPTOMS

            Issue Clarification

            When running a metadata rule within ERPi for a PeopleSoft Source System the metadata rule fails. The ODI Operator shows that the "PS_GL_LOAD_DIMENSION_MEMBERS" process is failing at step 20 PS Extract Dimension Members.

             

            java.sql.SQLException: ORA-00001: unique constraint (ERPINTEGRATOR.AIF_DIM_MEMBERS_STG_U1) violated

             

            CAUSE

            This caused a unique constraint exception as there were multiple records with the same "NAME" but with different EFFDT values in the AIF_PS_CF_METADATA table.

             

             

            SOLUTION

            Until the fix is included in the next service pack, the following update

            statement can be run *after* every execution of the Initialize Source System

            process on a PSFT source system:

            .

            UPDATE AIF_PS_CF_METADATA

            SET EFFDT_FLAG = 'Y'

            WHERE SOURCE_SYSTEM_ID = ?

            AND EFFDT_FLAG = 'N'

            AND (

            (FIELDNAME = 'AFFILIATE_INTRA1' AND RECNAME = 'AFFINTRA1_VW')

            OR (FIELDNAME = 'AFFILIATE_INTRA2' AND RECNAME = 'AFFINTRA2_VW')

            );

             

            Regards,

            Ragav.

            • 3. Re: ERPI Metadata load fails
              TomBlakeley

              Is this application created using EPMA or Native Essbase?

              • 4. Re: ERPI Metadata load fails
                ragavhere

                Tom,

                 

                Application is a native essbase application. Though the process succeeds for any target application, I dont see any metadata coming inside Hyperion. And not sure if any adapters need to be configured.

                 

                Regards,

                Ragav.