12 Replies Latest reply on Oct 7, 2018 10:38 AM by adnan645

    FDMEE-Source Initialization Issue

    Mishra Chandan

      Hi All,

       

      We recently upgraded our Hyperion application to 11.1.2.4.900 version on Windows 2012 R2 and also applied 220 patch to the FDMEE. We are facing below 2 issues in FDMEE: -

      1. Error during ODI Process Submission. ODI Connection information may not be correct or ODI Agent may not be running. Please check and resubmit the job

      This is appearing everytime if we change any details in FDMEE/ODI or refresh Members etc.

      2. To resolve the above issue we have to restart the FDMEE services but it shows successful also but in the log I can see the violation message: -

      2018-09-12 09:35:34,818 FATAL [AIF]: Error in LKM EBS Extract Summary Nodes - Load Summary Dim Members Stage - Independent Value Set - Source System Id: 2 - Value Set Id: 1016132

      Traceback (most recent call last):  File "<string>", line 404, in loadSummaryDimMembersStage

      SQLIntegrityConstraintViolationException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (HYP_FDM.AIF_DIM_MEMBERS_STG_U1) violated

       

      2018-09-12 09:35:34,849 FATAL [AIF]: Error in LKM EBS Extract Summary Nodes - Load Summary Dim Members Stage - Independent Value Set - Source System Id: 2 - Value Set Id: 1016135

      Traceback (most recent call last):

        File "<string>", line 404, in loadSummaryDimMembersStage

      SQLIntegrityConstraintViolationException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (HYP_FDM.AIF_DIM_MEMBERS_STG_U1) violated

       

      Regards,

      Chandan Mishra