Error while using startcmd.sh for OdiExportScen in ODI 11g
811595May 5 2011 — edited Oct 13 2011Hi,
I have upgraded ODI 10g to ODI 11g.
I have a package wherein I have defined a procedure which has the following jython code for export of scenarios to ODI server.
import os
scen='#DEPLOYMENT.PVV_GET_SCN'
scen_name=scen[5:-7]
scen_ver=scen[-7:-4]
file_name='/soaap/ODI_HOME/Scenarios/#DEPLOYMENT.PVV_GET_SCN'
odiscen="/soaap/ODI_HOME/oracledi/bin/startcmd.sh OdiExportScen -SCEN_NAME="+scen_name+" -SCEN_VERSION="+scen_ver+" -FILE_NAME="+file_name
if os.system(odiscen) <> 0:
raise odiscen
This code was working fine on ODI 10g but now I am getting this error when exeuting on ODI 11g :
org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 8, in ?
/soaap/ODI_HOME/oracledi/bin/startcmd.sh OdiExportScen -SCEN_NAME=SCN_PKG_DEPLOYMENT -SCEN_VERSION=002 -FILE_NAME=/soaap/ODI_HOME/Scenarios/SCEN_SCN_PKG_DEPLOYMENT002.XML
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:345)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:169)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2374)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java:1615)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java:1580)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2755)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:619)
Please guide for this.
Thanks,
Divya