Skip to main content

Hi Community,

I am facing an issue when i am trying to transfer legacy data to input container with the date field. other date field mapping like valid_until and acquisition date are working just fine. The error i am getting is for the VALID_UNTIL column which has a value as 30.12.2049. the value for other column are also in the same format. The error is am getting is “Unable to start IC_ADD_AND_META_VALID - ORA20110: DatInputContainerUtil.EXEERR: Error while selecting data from legacy file(s). ORA01861: literal does not match format string”. Can anyone please explain me why this is happening.

I even checked the training video but there is not much information on handling date column when transferring data to input container.

I would Appreciate your input on solving this.

 

Tank you

HI I was able to fix this mhy changing the date format from YYYY:MM:DD to DD:MM:YYYY on the legacy data page. and it works just fine.


Reply