This discussion is archived
4 Replies Latest reply: Oct 3, 2013 12:33 PM by ragavhere RSS

ERPI Metadata load fails

ragavhere Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    Is this application created using EPMA or Native Essbase?

  • 4. Re: ERPI Metadata load fails
    ragavhere Newbie
    Currently Being Moderated

    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.

Legend

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