2 Replies Latest reply on Nov 28, 2014 10:20 AM by Chuggans-Oracle

    Maximum Errors Allowed






      Coming from a background of using ODI for Source to Essbase integration, I was wondering if FDMEE has a concept of the MAXIMUM_ERRORS_ALLOWED option that we have in the SQL to Essbase IKM.


      In other words, can we tolerate a certain amount of exceptions on load without the whole thing failing?



        • 1. Re: Maximum Errors Allowed
          Soumya Banerjee



          I am not very sure about MAXIMUM_ERRORS_ALLOWED in FDMEE, but check whether you can skip the errors during your dataload.



          • 2. Re: Maximum Errors Allowed

            With FMDEE when you get to the export to target stage (e.g. loading data into Essbase from the FDMEE schema) loads will usually continue until they have finished and make note of any row rejections and the reasons for them. There's no concept of MAXIMUM_ERRORS_ALLOWED as you get with the Essbase IKMs for custom ODI data integrations. Data loads only tend to fail when some kind of fatal error occurs that completely stops a load from taking place.


            When any issues occur during a data or metadata load then the process details screen will show an exclamation mark to indicate that there were some issues along the way although the step succeeded.