WE are facing the below mentioned error while running an interface in ODI which populates FDMEE. it is failing in the first step itself. I am new to ODI integration and any help will be great..
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 1
java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("drop table FDMEE.\"C$_") ; out.print(SESS_NO) ; out.print("AIF_OPEN_I . . . '' : Undefined argument: SESS_NO : at Line: 2 : in file: inline evaluation of: ``out.print("drop table FDMEE.\"C$_") ; out.print(SESS_NO) ; out.print("AIF_OPEN_I . . . '' : ( SESS_NO )
BSF info: Drop work table at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:489)
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:737)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
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: java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("drop table FDMEE.\"C$_") ; out.print(SESS_NO) ; out.print("AIF_OPEN_I . . . '' : Undefined argument: SESS_NO : at Line: 2 : in file: inline evaluation of: ``out.print("drop table FDMEE.\"C$_") ; out.print(SESS_NO) ; out.print("AIF_OPEN_I . . . '' : ( SESS_NO )
BSF info: Drop work table at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:476)
... 11 more
Caused by: org.apache.bsf.BSFException: BeanShell scri