FlatFileconnector Date Attribute Fails with "convertDataType : Exception while parsing..." (Doc ID 2167496.1)

Last updated on MARCH 08, 2017

Applies to:

Identity Manager Connector - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

After installing Flat File connector FlatFile-11.1.1.6.0 and using FlatFile as Trusted Reconciliation, Date field fails to Reconcile.
- Works for all other attributes.


Tried date format (1999/11/02 10:00:00 IST), which gave following error:
convertDataType : Exception while parsing 1999/11/02 10:00:00 IST to yyyy-MM-dd

Changed date format to yyyy-MM-dd and tried date(1999-11-02)
then it is giving following error:
convertDataType : Exception while parsing 1999-11-02 to yyyy/MM/dd HH:mm:ss z



The issue can be reproduced at will with the following steps:

1. Created Resource Object Attribute of type Date
2. Mapped in Process definition to Hire Date with Recon Attribute
3. Mapped in Lookup.<>.ReconAttrMap with recon attribute and csv HireDate header
4. In schema.properties made entry
HireDate.DataType=Date
SystemDateFormat=yyyy/MM/dd



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