Hi experts,
I want to use ODIsqlunload but It gives error always. My OS win7
error :
oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:620)
at com.sunopsis.dwg.function.SnpsFunctionBase.getSunopsisApi(SnpsFunctionBase.java:494)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1415)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:540)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
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: ODI-30044: Invalid parameter:-file
at com.sunopsis.dwg.function.SnpsFunctionBase.actionSetParameters(SnpsFunctionBase.java:251)
at com.sunopsis.dwg.function.SnpsFunctionBase.setParameters(SnpsFunctionBase.java:799)
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:616)
... 18 more
and the code is :
SnpsSqlUnload "-file=F:\temp/data_6001_1001.dat" "-driver=oracle.jdbc.OracleDriver" "-URL=jdbc:oracle:thin:@musty-Pc:1521:XE" -user=system -pass=<@=snpRef.getInfo("SRC_ENCODED_PASS") @> -file_format=variable -charset_encoding=UTF8 "-row_sep=\n" "-date_format=yyyy-MM-dd" -fetch_size=1000 "-field_sep=#"
select /*+ */
columns....
from table...
where (1=1)
I try this -file parameters :
F:\data_6001_1001.dat
F:\test.txt
C:\Test\test.txt
C:/data_6001_1001.dat
C:\Test/data_6001_1001.txt
c:/Test/data_6001_1001.txt
C:\Test/data_6001_1001.dat
all of them same result :(
pls help me experts :(