Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Set Oracle as the source database.
  2. Set Teradata as the target database.
  3. 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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us