6 Replies Latest reply: Dec 3, 2012 4:01 AM by Bhabani Ranjan RSS

    Date data load error while loading xml data to oracle db

    user705850
      I am using staging different from target. I have specified oracle in the stagng area
      In my xml data the date data comes in as (returned by a web service response file)
      <ExpCatStDt>1987-01-01</ExpCatStDt>

      ODI-1217: Session TST22-1 (106001) fails with return code 0.
      ODI-1226: Step TST22-1 fails after 1 attempt(s).
      ODI-1240: Flow TST22-1 fails while performing a Loading operation. This flow loads target table ODI_PSFT_FUS_EXPTYPE_MAP.
      ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection ORCLDS.
      Caused By: java.sql.BatchUpdateException: ORA-01861: literal does not match format string

      The target db has this column defined as date column

      Any help?