My Oracle Support Banner

Date Variable Fails With "java.text.ParseException: Unparseable date:" Exception When Scheduled With ODI Standalone Agent in an MSSQL Environment (Doc ID 2213733.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

In ODI 11.1.1.7.0, a scheduled Load Plan execution using an ODI standalone agent fails with below error at the refresh variable step for ODI_TIMESTAMP when connecting to an MSSQL database:

oracle.odi.core.exception.OdiRuntimeException: ODI-1022: The variable value for variable CAPS_METADATA_INTEGRATION.ODI_TIMESTAMP is not compatible with the variable type D
at com.sunopsis.dwg.dbobj.SnpSession.updateVarWithSessVar(SnpSession.java:3154)
at com.sunopsis.dwg.dbobj.SnpSession.treatSessVariables(SnpSession.java:2713)
at com.sunopsis.dwg.dbobj.SnpSession.treatSessionPreTrt(SnpSession.java:2671)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2013)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
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.text.ParseException: Unparseable date: ""
at java.text.DateFormat.parse(DateFormat.java:337)
at oracle.odi.runtime.agent.invocation.request.support.OdiDateFormat.parse(OdiDateFormat.java:40)
at com.sunopsis.dwg.dbobj.SnpVarSess.setValue(SnpVarSess.java:963)
at com.sunopsis.dwg.dbobj.SnpVarSess.setValue(SnpVarSess.java:667)
at com.sunopsis.dwg.dbobj.SnpSession.updateVarWithSessVar(SnpSession.java:3138)
at com.sunopsis.dwg.dbobj.SnpSession.treatSessVariables(SnpSession.java:2723)
... 10 more

 

However, manually running the ODI Load plan and scenarios (for loading data), using the same date variable, is successful.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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