My Oracle Support Banner

Wrong Date Format Passed In Parameter in ODI Console (Doc ID 2579310.1)

Last updated on AUGUST 09, 2021

Applies to:

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


When attempting to run a scenario that uses a date variable in ODI Console, the below error occurs:

ODI-1217: Session <SESSION_NAME> (<NUMBER>) fails with return code 7000.
Caused By: oracle.odi.core.exception.OdiRuntimeException: ODI-1022: The variable value Tue Apr 16 16:47:11 EEST 2019 for variable <VARIABLE_NAME> is not compatible with the variable type D
at oracle.odi.runtime.agent.execution.SessionExecutor.updateVarWithSessVar(
at oracle.odi.runtime.agent.execution.SessionExecutor.treatSessVariables(
at oracle.odi.runtime.agent.execution.SessionExecutor.initSessVariables(
at oracle.odi.runtime.agent.execution.SessionExecutor.initSession(
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(
at java.util.concurrent.Executors$
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.text.ParseException: Unparseable date: "Tue Apr 16 16:47:11 EEST 2019"
at java.text.DateFormat.parse(
at com.sunopsis.dwg.dbobj.SnpVarSess.setValue(
at com.sunopsis.dwg.dbobj.SnpVarSess.setValue(
at oracle.odi.runtime.agent.execution.SessionExecutor.updateVarWithSessVar(
... 19 more

The issue can be reproduced at will with the following steps:
1. Create a package that uses a date variable and generate a scenario from it.
2. Run the scenario in ODI Studio.
3. Run the scenario in ODI Console.

There appears to be a difference in the date format passed to the variable in ODI Console and ODI Studio.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.