Extracting date property to target Teradata database fails
SQLException occurs on extracting date property. This occurs when the DDL generated for the target database creates an EffectiveDate property map to a VARCHAR2(8) column.
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC ] [Error 857] [SQLState HY000] Two different data types are being set for parameter 14 (765 & 449)
Steps to Reproduce
- Set Oracle as the source database.
- Set Teradata as the target database.
- Extract the Date property to the target database.
A defect in Pegasystems’ code or rules.
When the value for the Date column iss Null, the setTimestamp Bind method is used instead of setString. Hence, the exception occurs because some of the Insert statements are Null while the others are strings.
0% found this useful