Hello,
I have an issue whereby we are not able to import a flatfile via FDMEE to both HFM and Planning locations.
- The last time this has worked was April 14th (for Planning).
- The HFM file we are testing with has been tested in all ascii and UTF-8 encoding with the same error appearing.
- The 'encode character' cited below is 'é', which is a french canadian character but this character does NOT exist in the load file; this leads me to believe that perhaps the staging tables are not being cleared?
- The only change in our environment would be that the DBA has enabled 'advanced encryption' on our Oracle 11g database - could this be the culprit?
Any help would be greatly appreciated. I've exhausted the knowledge base
See the errors found in the ODI job below:
<?xml version="1.0" encoding="UTF-8" ?>
- <odiLog>
- <odiSessionLog>
<deleteCount>0</deleteCount>
<endTime>2015-04-28T16:53:20-04:00</endTime> - <errorMessage>
- <![CDATA[
ODI-1217: Echec de la session COMM_LOAD_BALANCES (100501) avec le code retour 7000.
ODI-1226: Echec de l'étape FAILED - Map Data après 1 tentative(s).
ODI-1232: Echec de l'exécution de la procédure COMM Finalize Process.
Caused By: UnicodeEncodeError: 'ascii' codec can't encode character u'\xe9' in position 21: ordinal not in range(128)
at org.python.core.codecs.strict_errors(codecs.java:228)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.python.core.JavaFunc._call_(Py.java:2036)
at org.python.core.PyObject._call_(PyObject.java:367)
at org.python.core.codecs.encoding_error(codecs.java:1226)
at org.python.core.codecs.PyUnicode_EncodeIntLimited(codecs.java:900)
at org.python.core.codecs.PyUnicode_EncodeASCII(codecs.java:852)
at org.python.core.codecs.encode(codecs.java:185)
at org.python.core.PyString.str_encode(PyString.java:2429)
at org.python.core.PyString.encode(PyString.java:2416)
at org.python.core.PyUnicode.unicode__str_(PyUnicode.java:228)
at org.python.core.PyUnicode._str_(PyUnicode.java:223)
at org.python.core.PyBaseException.BaseException__str_(PyBaseException.java:163)
at org.python.core.PyBaseException$BaseException__str_exposer.call_(Unknown Source)
at org.python.core.PyBaseExceptionDerived._str_(PyBaseExceptionDerived.java:27)
at org.python.core.Py.formatException(Py.java:1117)
at org.python.core.Py.displayException(Py.java:1036)
at org.python.core.PyException.printStackTrace(PyException.java:79)
at org.python.core.PyException.toString(PyException.java:98)
at java.lang.String.valueOf(String.java:2826)
at java.lang.StringBuffer.append(StringBuffer.java:219)
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
at java.lang.Thread.run(Thread.java:662)
Further along in the log we see this:
Start Date Tuesday, April 28, 2015 4:53:19 PM GMT-04:00
End Date Tuesday, April 28, 2015 4:53:19 PM GMT-04:00
Duration (s) 0
Status
Return Code 7000
Message org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 6, in <module> File "<string>", line 3377, in mapData File "<string>", line 2169, in mapData File "<string>", line 1727, in updateTDATASEG_T_TDATASEGW RuntimeError: [u"Error: No records exist for Period 'P11-2014'"] at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146) at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322) at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473) at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48) at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83) at java.lang.Thread.run(Thread.java:662) Caused by: Traceback (most recent call last): File "<string>", line 6, in <module> File "<string>", line 3377, in mapData File "<string>", line 2169, in mapData File "<string>", line 1727, in updateTDATASEG_T_TDATASEGW RuntimeError: [u"Error: No records exist for Period 'P11-2014'"] at org.python.core.PyException.fillInStackTrace(PyException.java:70) at java.lang.Throwable.<init>(Throwable.java:181)
Thanks in advance for the help!
William