4 Replies Latest reply on Mar 23, 2016 4:21 AM by Nishant Fukate

    FDMEE Open interface adapter from oracle

    2727166

      Hi all,

       

      Data from Oracle db is getting loaded into the AIF_OPEN_INTERFACE table , however from there it is not getting inserted into TDATASEG.

       

      Map Data for Period 'Mar - 2016'

      2016-03-22 13:37:39,660 WARN  [AIF]: Warning: No records exist for Period 'Mar - 2016'

      2016-03-22 13:37:39,685 INFO  [AIF]:

      Stage Data for Period 'Mar - 2016'

      2016-03-22 13:37:39,717 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 0

      2016-03-22 13:38:10,314 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 1000

      2016-03-22 13:38:16,897 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 1000

      2016-03-22 13:38:16,912 INFO  [AIF]: Number of Rows deleted from TDATASEG: 0

      2016-03-22 13:38:16,914 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

      2016-03-22 13:38:16,916 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

      2016-03-22 13:38:16,919 INFO  [AIF]: Number of Rows inserted into TDATASEG: 0

      2016-03-22 13:38:16,920 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 0

       

      Period mapping type is set as none in Dataloadrule

       

       

      I tried to run it again after deleting the data from AIF_OPEN_INTERFACE then i Keep getting the below error

       

       

      COMM Finalize Process -

      RuntimeError: ODI-1226: Step Launch GL Load Balances Data fails after 1 attempt(s).

      ODI-1241: Oracle Data Integrator tool execution fails.

      Caused By: oracle.odi.runtime.agent.invocation.InvocationException: HTTP/1.1 503 Service Temporarily Unavailable

       

      COMM Update Process

      org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 3, in <module>

      RuntimeError

       

      Did anyone face this kind of issue