1 Reply Latest reply: Oct 18, 2011 11:51 PM by Thetchinamoorthy Ganesan RSS

    ODI -1228 - Error while writing data into Integration Tool

    894315
      Dear Concern,

      We are getting the following error while running the interface in ODI:

      ODI-1228: Task int_jda_loc (Integration) fails on the target ORACLE connection ORCL_JDADVDB.
      Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression.

      Please suggest your thoughts and suggestion on the same.. how to resolve the above issue... as it is not telling which column datatype is not matched !!!