OdiStartScen Command Fails With Error "oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool" When Command Contains Carriage Returns (Doc ID 2207403.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The following message is signalled:

oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool
 at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:618)
 at com.sunopsis.dwg.function.SnpsFunctionBase.getSunopsisApi(SnpsFunctionBase.java:494)
 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1431)
 at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44
 ...

when running an Oracle Data Integrator (ODI) process which calls the OdiStartScen tool, and the implemented command contains carriage returns, such as:

OdiStartScen -SCEN_NAME=TEST_CUBE_TO_DB_DYN
-BIAPPS.01_REPORT_SCRIPT_ID=13
-BIAPPS.01_REP_SCRIPT_PERIOD=Jan-16
-BIAPPS.01_STORENET_REP_NUM=47

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms