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 JUNE 16, 2022

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_VARIABLE> when connecting to an MSSQL database:

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

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
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.