2 Replies Latest reply on Aug 26, 2013 6:52 PM by 1034416

    FDMEE import Script is not workng.

    1034416

      Hello Folks,

       

      We are trying to import data from a file and wrote a simple jython script. the script is not working. I am getting the following error. Without the script it is loading perfect.

       

        2013-08-21 15:51:29,887 DEBUG [AIF]: The EpmOracleHome is set to: D:\Oracle\Middleware\EPMSystem11R1

      2013-08-21 15:51:29,887 DEBUG [AIF]: The EpmOracleInstance is set to: D:\Oracle\Middleware\user_projects\XXXX09

        2013-08-21 15:51:29,887 DEBUG [AIF]: The JavaHome is set to:%EPM_ORACLE_HOME%/../jdk160_35

        2013-08-21 15:51:29,887 DEBUG [AIF]: The executeEventScript is set to: YES

        2013-08-21 15:51:29,887 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

        2013-08-21 15:51:29,887 DEBUG [AIF]: The AppRootFolder is set to: //XXXX12/FDMEEData

        2013-08-21 15:51:29,887 DEBUG [AIF]: Comm.doScriptInit - END 

      2013-08-21 15:51:29,887 DEBUG [AIF]: Comm.executeScript -START

        2013-08-21 15:51:29,887 DEBUG [AIF]: The following script does not exist: //XXXX12/FDMEEData/data/scripts/event/BefImport.py

      2013-08-21 15:51:29,903 DEBUG [AIF]: Comm.executeVBScript - START

        2013-08-21 15:51:29,903 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

        2013-08-21 15:51:29,903 DEBUG [AIF]: The following script does not exist: \\XXXX12\FDMEEData\data\scripts\event\BefImport.vbs

        2013-08-21 15:51:29,903 DEBUG [AIF]: Comm.executeVBScript -END

        2013-08-21 15:51:29,903 DEBUG [AIF]: Comm.executeScript -END

      2013-08-21 15:51:30,012 INFO  [AIF]: ERPI-105011:EPMERPI- Instantiating JythonInterpreter

      2013-08-21 15:51:30,230 INFO  [AIF]: 105039:EPMERPI - Log File Name ://XXXX12/FDMEEData\outbox\logs\FCXHFM_138.log

      2013-08-21 15:51:30,230 DEBUG [AIF]: ERPI-105011:EPMERPI-Passing script file for execution to jython interpretor: //XXXX12/FDMEEData/data/scripts/import/TestMe.py

      2013-08-21 15:51:30,230 INFO  [AIF]: 105039:EPMERPI -Execute File: //XXXX12/FDMEEData/data/scripts/import/TestMe.py

      2013-08-21 15:51:30,230 DEBUG [AIF]: 105039:EPMERPI - LOG_LEVEL: 4

      2013-08-21 15:51:30,230 DEBUG [AIF]: 105039:EPMERPI - def TestMe ( strfield, strrec) : 

        strfield = strfield + strrec[15:25]

        return strfield

      2013-08-21 15:51:30,230 ERROR [AIF]: 105039:EPMERPI - 105041:EPMERPI - Error compiling the script.null

        2013-08-21 15:51:30,230 ERROR [AIF]: ERPI-105011:EPMERPI-Traceback (innermost last): (no code object) at line 0

        SyntaxError: ('invalid syntax', ('//XXXX12/FDMEEData/data/scripts/import/TestMe.py', 2, 1, 'strfield = strfield + strrec[15:25]'))

         2013-08-21 15:51:30,246 DEBUG [AIF]: ERPI-105011:EPMERPI- update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?

      2013-08-21 15:51:30,246 ERROR [AIF]: ERPI-105011:EPMERPI-ERPI-105011:EPMERPI- {0}

        2013-08-21 15:51:30,246 DEBUG [AIF]: AIFUtil.callOdiServlet

      - END

        2013-08-21 15:51:30,261 FATAL [AIF]: Error in FileData.importData

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

        RuntimeError: Exception in the file import servlet call.

        ERPI-105011:EPMERPI- {0}

        java.lang.RuntimeException: ERPI-105011:EPMERPI- {0}

       

      Thanks in advance