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 to [Release 11gR1]
Information in this document applies to any platform.


In ODI, 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.


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.