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