4 Replies Latest reply on Jul 25, 2019 12:28 PM by Quan Tran

    Get error message with date field in Informatica when the workflow is run

    Quan Tran New Member

      I am getting the following error when I try to link a date field from Source Qualifier to Target table in Informatica: ERROR 7/19/2019 9:05:26 AM node01_dev WRITER_1_*_1 WRT_8229 Database errors occurred: FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Timestamp parameters with zero scale must have a precision of 13, 16, or 19. Parameter number: 1, precision: 12. FnName: Execute -- [DataDirect][ODBC lib] Function sequence error

      I have done the same thing (used datetime for a target) with another workflow and it ran successfully.

      I have done a search on the internet with this error message but none of the solutions from my search resolved the problem.

      The target table SA_Cases needs to have the data insert into it. Right now, the Monitor shows that all of the rows are rejected.