1 Reply Latest reply on Jun 2, 2015 12:35 PM by SH_INT

    FDMEE Import Script Skipping all lines

    2837320

      Hi All ,

       

      I created an import script such that for one of the Custom the value should be the Location name . But its not getting that value and also skipping all the lines and in log it shows as Skipped From Script for all lines . Please advise why this is happening .

       

      ************

      def Parse_Entity(strfield, strrecord):

          org = fdmContext['LOCNAME']

          return org

      *****************

       

      2015-06-02 06:20:09,724 INFO  [AIF]: ERPI-105011:EPMERPI- Instantiating JythonInterpreter

      2015-06-02 06:20:10,110 INFO  [AIF]: 105039:EPMERPI - Log File Name :D:\Oracle\FDMAPPS\outbox\logs\SAHFM_141.log

      2015-06-02 06:20:10,112 DEBUG [AIF]: ERPI-105011:EPMERPI- Passing script file for execution to jython interpretor: D:\Oracle\FDMAPPS/data/scripts/import/Test.py

      2015-06-02 06:20:10,114 INFO  [AIF]: 105039:EPMERPI - Execute File: D:\Oracle\FDMAPPS/data/scripts/import/Test.py

      2015-06-02 06:20:10,116 DEBUG [AIF]: 105039:EPMERPI - LOG_LEVEL: 5

      2015-06-02 06:20:10,116 DEBUG [AIF]: 105039:EPMERPI - Script File encoding: UTF-8

      2015-06-02 06:20:10,117 DEBUG [AIF]: 105039:EPMERPI - def Parse_Entity(strfield, strrecord):

          org = fdmContext['LOCNAME']

          return org

       

      2015-06-02 06:20:10,131 DEBUG [AIF]: ERPI-105011:EPMERPI- compiling script:Test(strField,strRecord)

      2015-06-02 06:20:10,135 INFO  [AIF]: ERPI-105011:EPMERPI- File Name Testing.txt

      periodKey2014-11-30

      2015-06-02 06:20:10,137 DEBUG [AIF]: ERPI-105011:EPMERPI- Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace(PyException.java:70)

      java.lang.Throwable.<init>(Throwable.java:181)

      java.lang.Exception.<init>(Exception.java:29)

      java.lang.RuntimeException.<init>(RuntimeException.java:32)

      org.python.core.PyException.<init>(PyException.java:46)

      org.python.core.PyException.<init>(PyException.java:43)

      org.python.core.PyException.<init>(PyException.java:61)

      org.python.core.Py.NameError(Py.java:220)

      org.python.core.PyFrame.getname(PyFrame.java:276)

      org.python.pycode._pyx955.f$0(<script>:1)

      org.python.pycode._pyx955.call_function(<script>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyCode.call(PyCode.java:18)

      org.python.core.Py.runCode(Py.java:1204)

      org.python.core.__builtin__.eval(__builtin__.java:504)

      org.python.util.PythonInterpreter.eval(PythonInterpreter.java:164)

      com.hyperion.aif.file.common.util.DataLoadEngine$Expression.evaluateScript(DataLoadEngine.java:1031)

      com.hyperion.aif.file.common.util.DataLoadEngine$Expression.access$200(DataLoadEngine.java:924)

      com.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:834)

      com.hyperion.aif.file.common.util.DataLoadEngine.processFileRow(DataLoadEngine.java:656)

      com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:385)

      com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:374)

      sun.reflect.GeneratedMethodAccessor795.invoke(Unknown Source)

      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      java.lang.reflect.Method.invoke(Method.java:597)

      org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

      org.python.core.PyObject.__call__(PyObject.java:355)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:381)

      org.python.core.PyObject.__call__(PyObject.java:385)

      org.python.pycode._pyx941.importData$2(<string>:91)

      org.python.pycode._pyx941.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyBaseCode.call(PyBaseCode.java:297)

      org.python.core.PyBaseCode.call(PyBaseCode.java:191)

      org.python.core.PyFunction.__call__(PyFunction.java:385)

      org.python.core.PyMethod.__call__(PyMethod.java:215)

      org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

      org.python.core.PyMethod.__call__(PyMethod.java:206)

      org.python.core.PyObject.__call__(PyObject.java:432)

      org.python.core.PyObject.__call__(PyObject.java:436)

      org.python.pycode._pyx944.f$0(<string>:5)

      org.python.pycode._pyx944.call_function(<string>)

      org.python.core.PyTableCode.call(PyTableCode.java:165)

      org.python.core.PyCode.call(PyCode.java:18)

      org.python.core.Py.runCode(Py.java:1204)

      org.python.core.Py.exec(Py.java:1248

      ***********************

      [BLANK]

      [BLANK]

      [SKIPED FROM SCRIPT ] ACC           Description                        Beginning Balance               Debits              Credits       Ending Balance

      [SKIPED FROM SCRIPT ] --------------- ------------------------------- -------------------- -------------------- -------------------- --------------------

      [SKIPED FROM SCRIPT ] 1010            CASH IN BANKS                              84,410.91        33,419,258.45        35,189,715.65        -1,686,046.29

      [SKIPED FROM SCRIPT ] 1050            CASH EQUIVALENTS                      320,422,492.02       181,734,281.41       222,421,493.83       279,735,279.60

      [SKIPED FROM SCRIPT ] 1059            RESTRICTED CASH                           920,357.21                 0.00                 0.00           920,357.21

      Rows Loaded: 0

      Rows Rejected: 19

      **********************