Support Article
Extracting date property to target Teradata database fails
SA-53113
Summary
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.
Error Messages
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.
Root Cause
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.
Resolution
Apply HFix-42079.
Published April 15, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.